Division in Delivery Header

[Former Member]

Hi All,

I want to have the SPARA/ SPART field in 2LIS_12_VCHDR. From which R/3 table would be right to have it? I think it should be from Sales order header i.e. VBAK. Please throw in your suggestions.

Rgds,

Sonali

Message was edited by: Sonali Pohane

[Former Member · Accepted solution]

Hi Sonali,

It depends on what division you want. If you want the division on item level (material), it generally makes no sense to add this on a delivery header level since a delivery can have multiple items/materials with different divisions.

Regards,

Eddy

[Former Member · Accepted solution]

Hi Eddy,

Thank you for your reply. But Division is not needed on material level.

Regards,

Sonali

[Former Member]

Hi,

find out the underlined tables for 2LIS_12_VCHDR datasource then look at the primary key of table see the relationship between between primary key & Division if it fetches single value ...should work.

for every record of datasource it should be able to pick up single value.

hope it helps

regards

Vikash

[Former Member]

Hi Vikash,

Thank you for your reply. I will try to find this. Probably we might push this back to R/3 to add in the LIKP table, since this is the report requirement and security being on Division.

Regards,

Sonali