Question:
Hello BW Fans
I have a PSA table. In this table i have 3 keyfields REQUEST, DATAPAKID and RECORD. I want to create an ODS with the same structure of PSA with the above 3 fields. Is it possible? if so please advice.
thanks
sampath
Answer:
Yes it is possible.
we created three custom fields and added transfer rules for each field
for record no filed - following was the code
* DATA: l_s_errorlog TYPE rssm_s_errorlog_int.
RESULT = RECORD_NO.
* returncode <> 0 means skip this record
RETURNCODE = 0.
* abort <> 0 means skip whole data package !!!
ABORT = 0.
For request number
* DATA: l_s_errorlog TYPE rssm_s_errorlog_int.
RESULT = G_S_MINFO-REQUNR .
* returncode <> 0 means skip this record
RETURNCODE = 0.
* abort <> 0 means skip whole data package !!!
ABORT = 0.
for datapacket id
* DATA: l_s_errorlog TYPE rssm_s_errorlog_int.
RESULT = G_S_MINFO-DATAPAKID.
* returncode <> 0 means skip this record
RETURNCODE = 0.
* abort <> 0 means skip whole data package !!!
ABORT = 0.
regards
phemrajani
Answer:
Thanks Phemrajani for your reply. Your idea works fine for me.
But i have following issue.
I created ODS_1 with keyfields RECORDNO, REQUEST NO and DATAPAKID (similar to PSA - getting data from item and SCL)
and ODS_2, with key fields DOC_NUM and DOC_ITEM, getting data from ODS_1.
When i load data to first ODS_1 (PSA and then data target), i am getting the following entries :
DOC_NUM DOC_ITEM ORDER_QUAN
65000000 10 1000
65000000 10 0
Again when i load data from ODS_1 to ODS_2, i am getting the following entries :
DOC_NUM DOC_ITEM ORDER_QUAN
65000000 10 0
I want to get the entry 1000 for the field ORDER_QUAN.
Any help is appreciated.
Note : The property for the field ORDER_QUAN in ODS_2 is "Overwrite"
thanks
sampath