Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
I have a requirement to call a custom RFC function module and store the data into BW table. We have one filed in the FM output PS_PSP_PNR which is having internal and external format. When I call this FM into BW, I am getting the data in internal format. Can you help me how I can get the external format.
PS_PSP_PNR Data Element (Work Breakdown Structure Element (WBS Element)) is using Domain PS_POSNR that has Conversion Routine ABPSP.
1-) On BW side if you are using InfoObject or/and InfoObject referenced field / data element (like /BI0/* or /BIC/* then make sure the InfoObject using the same ABPSP Conversion Routine in the definition. As long as the InfoObject using ABPSP Conversion Routine in BW side then values will be stored in internal format but displayed in external format. That would be the best practice - matching on SAP and BW side and not relying on external format.
2-) If you are using just a regular data element & domain in BW side the same thing either you can make sure the domain has the same ABPSP Conversion Routine then internal & external conversion will be taken care of OR you can use function modules in your ABAP for converting between internal and external values:
a-) CONVERSION_EXIT_ABPSP_INPUT Conversion External > Internal WBS Element Number
b-) CONVERSION_EXIT_ABPSP_OUTPUT Conversion Internal > External WBS Element Number
I have a requirement to call a custom RFC function module and store the data into BW table. We have one filed in the FM output PS_PSP_PNR which is having internal and external format. When I call this FM into BW, I am getting the data in internal format. Can you help me how I can get the external format.
PS_PSP_PNR Data Element (Work Breakdown Structure Element (WBS Element)) is using Domain PS_POSNR that has Conversion Routine ABPSP.
1-) On BW side if you are using InfoObject or/and InfoObject referenced field / data element (like /BI0/* or /BIC/* then make sure the InfoObject using the same ABPSP Conversion Routine in the definition. As long as the InfoObject using ABPSP Conversion Routine in BW side then values will be stored in internal format but displayed in external format. That would be the best practice - matching on SAP and BW side and not relying on external format.
2-) If you are using just a regular data element & domain in BW side the same thing either you can make sure the domain has the same ABPSP Conversion Routine then internal & external conversion will be taken care of OR you can use function modules in your ABAP for converting between internal and external values:
a-) CONVERSION_EXIT_ABPSP_INPUT Conversion External > Internal WBS Element Number
b-) CONVERSION_EXIT_ABPSP_OUTPUT Conversion Internal > External WBS Element Number
Thanks for the answer. In the BW, I am using the regular data element. When I execute the conversion FM's in BW, I am not getting the data where as if I execute in S4, we are getting the data. So, The only way we can get is to do the conversion in S4 and get the data in BW. Please correct me if I am wrong.
Do we have any setting where we can get the external format as a FM output.
I see that even tough the FM CONVERSION_EXIT_ABPSP_OUTPUT exists in BW its code has a call function for FM CONVERSION_EXIT_KONPR_OUTPUT which does not exist in BW. Because it seems PS (Project Systems) app not installed in BW.
In this case yes you can do the conversion in S4 and transfer to BW.
Bluesky
