I am trying to get fields from VBRK,VBRP,VBAK and MARA so pl tell me what I need to put in join condition ? Do i need to go like follows?
or do i need to joint all 4 tables ? How?
also when i am trying to add NETWR in view field and and when i go to create and save data source based on this view , its giving me the following error .So pl tell me what I need to do to solve this error?
<b>Invalid extract structure template YVBILL of DataSource KR_1
Message no. R8359
You tried to generate an extract structure with the template structure YVBILL. This operation failed, because the template structure quantity fields or currency fields, for example, field NETWR refer to a different table.
Use the template structure to create a view or DDIC structure that does not contain the inadmissable fields</b>