2LIS_13_VDITM as source (Data Services)

[Former Member]

Dear all:

we are using extractors as source (Data Services).

We have some additional fields added to  2LIS_13_VDITM datasource

• Fashion Brand (char 3)
• Partner_YA (char 10)
• Document Number (char 10)

Their value come from CMOD.

If I check the extraction using RSA3 in ECC I get data for all these additional fields.

Data Services gets data for only one field (Fashion Brand);  the other two are <null>.

Does anyone know the reason for this strange behaviour?

Thanks everybody.

Sabrina

[Former Member]

Hi Sabrina,

Could you please check in RSA6 if you have unhide the 3 new fields or not, if not then unhide the fields. Also check if the customer exit check box is checked for new 3 fields at Data source level.

Regards,

Lukesh.

[Former Member]

Dear Lukesh:

custom new field are unhide , exit chek box is checked and customer exit works fine.

sabrina

[former_member182470]

Did you mean, the data is not coming correctly in BI side? If yes, please replicate your datasource and activate it in BW. Then, run the infopackage to see the data in PSA.

[Former Member]

Data are not transferred to a BW system. We upload data into SQL server via DataServices. In DataServices Designer you don't replicate datasource; you can only Reimport. I did so, but only one field is not null.

[former_member182470]

Could you activate it in RSA6 again and check in RSA3 ?After that, try again to reimport in SQL

[amine_lamkaissi]

Hi Sabrina,

May be a probem on your SQL code.

Could you share the code?

Amine

[Former Member]

Hi Amine:

there is no sql code.

DataServices Desidner --> Datastore --> Import By Name --> 2LIS_13_VDITM.

Once imported in DataServices, View Data.

Some fields (BELNR and PARTNER_YA) are <Blank>, but they are not blank in SAP, as we can see in RSA3.

sabrina

[amine_lamkaissi]

Hi Sabrina,

Just to locate your problem. If you have a BW connected to ECC can you try the following:

-Replicate your problematic datasource in BW

-Create and execute a full infopackage

-Check in PSA if your fields are populated.

Could you communicate your system details : ECC version and SP, SQL server version.

Let us know.

Amine

[Former Member]

Dear Amine:

we can't upload data to a BW system.

Our system details are:

Sap System SAP ECC 6.0.

SAP_ABA 700 0020 SAPKA70020

PI_BASIS 2005_1_700 0020 SAPKIPYJ7K

ST-PI 2008_1_700 0006 SAPKITLRD6

SAP_BW 700 0020 SAPKW70020

SAP_AP 700 0017 SAPKNA7017

SAP_APPL 603 0005 SAPKH60305

SAP_HR 600 0003 SAPKE60003

EA-IPPE 400 0016 SAPKGPID16

Database :

MSSQL 10.50.2769

DataServices: 14.0.3.273

Thanks in advance for your kind reply.

Sabrina

[amine_lamkaissi]

Sabrina,

Can you try to import another datasource and see if you still facing this issue (If powwible 100% standard datasource)?

Also, with your first datasource. Check if you have in ECC any dumps or warnings using the following transactions and process (SLG1 - SM12 - SM37 - SQL Trace - ST22)

Amine