SD REPORT ISSUE FROM R/3 NEW SYSTEM

[former_member183334]

Hi Experts..

i have requirement for SD report i am not able to find the data source  which having tables like KNA1(Filed-BRSCH),VBKD(fIeld-BSTKD),J_1IEXCHDR(Field-EXNUM)(i need data source name for these table? it is 7.3 new implementation system.

[KodandaPani_KV · Accepted solution]

Hi,

please check the 0CUSTOMER_ATTR data source

here all data maintatian customer related.

Thanks,

Phani.

[former_member183334 · Accepted solution]

hi pani

can i get your mail id i have some important  discussions.

[KodandaPani_KV · Accepted solution]

Hi,

about these fields SD consultans know where they are storing the data about fileds.

J_1IEXCHDR(Field-EXNUM ,  VBKD(fIeld-BSTKD),

check the tables names with the SD consultants after enhance the data source  0CUSTOMER_ATTR 

enhacement steps - CMOD -

funciton exit - EXIT_SAPLRSAP_001

include program - ZXRSAU01.

click on the source code tab

after write the abap logic for the above objects

Thanks,

Phani.

[former_member183334 · Accepted solution]

Hi Pani..

this is input screen is related to SD..

Input   Screen	Table Name	Field Name	From	To
Plant	T001W	WERKS	From	To
Sales   Organisation	TVKO	VKORG	From	To
Distribution   Channel	TVTW	VTWEG	From	To
Division	TSPA	SPART	From	To
Sales   Office	VKBUR	VKBUR	From	To
Order   Type	TVAK	AUART	From	To
Sales Employee	PA0000	PERNR	From	To
Product Group	TVM2	MVGR2	From	To
Sales   District	T171	BZIRK	From	To
Bill Creation   Date	VBRK	FKDAT	From	To
Customer	KNA1	KUNNR	From	To
Tax Code	T007A	MWSKZ	From	To

Based in this Requirement i have to generate bex query. Total 12 table fields are there in that.

pls tell me the flow ? how to load data from R/3 to BI.

Regards

Satish

[former_member183334 · Accepted solution]

Thanks pani i will go through ....