MANDT field missing ODP data source to BODS

[#1]

Hi Experts,

We are transferring data from our ECC environment to a non-SAP system with the help of BODS. The source of data are ODP data sources.

The loads from ECC were running fine until recently. Suddenly, BODS stopped receiving the MANDT field which was coming earlier from all the standard data sources (eg. 0VENDOR_ATTR, 0MATERIAL etc.)

This has lead to field mismatch during BODS transformation. Is there a way to switch back to receiving the MANDT field.

[Former Member]

sanjeev.kulkarni02

Are you pulling only a minor subset of the data or full data set. If you are only pulling a minor dataset then use the ODP object as source in an ABAP data flow. If you are using ABAP Data flow then you can check what is the code generated by Extractor.

If you are using a regular data flow to pull data from ODP Data source(Extractor), DS uses RFC to call the ODP data replication API. The where-conditions are not pushed down to the extractor. That means all data are pulled from the extractor and filtering is done afterwards in DS.

ODP Extractors can be found in the SAP Table ROOSATTR, All the Extractors which are released & active will be listed in this table

Also you can try using the Data Services inbuilt function

sy('mandt') Result:The client ID number of the current SAP application client

You can use this function inside the query transform in ABAP data flow. Refer SAP Supplement Guide

Regards

Arun Sasi