Key for Integration ODS for 2LIS_12_VCHDR AND 2LIS_12_VCITM

[Former Member]

Hey Gurus,

What would be the key for integration ODS of Delivery Header 2LIS_12_VCHDR and Delivery Item 2LIS_12_VCITM ???

1) If I make Delivery number as my key then item details will be over written.

2) If I make both Delivery number and delivery item number as my key, then how about the records which gets uploaded by HDR datasource. Those records will get Balnk value for ITEM NUMBER primary Key.

PLEASE CORRECT ME IF I AM WRONG.

replies are awarded for sure.

EXPERTS PLEASE HELP ME OUT.

Thanks

[Former Member · Accepted solution]

Hi,

as far as I understood you want to have both datasources in the same ODS, correct?

You have several alternatives:

- even if that's not your requirement, you could keep them separated since as you just realized, the DS have different primary keys. You would then report on these two ODSs via a multiprovider.

- Add one custom IObj in your ODS key indicating from wich Datasource the record is coming; you'll then have your HDR and ITM in separated records. The key would then be DSource / DocNo / ItmNo.

- if you need to merge HDR and ITM data in one single record I suggest to first load your data in an HRD ODS. You'll load then ITM data in your merged ODS and enhance the HDR part of your record by looking up to your HDR ODS.

hope this helps...

Olivier.

Message was edited by:

Olivier Cora

[Former Member · Accepted solution]

Hi Olivier Cora

Thanks for a very quick reply....! appreciate your response.

Yeah you are right I want to merge both HDR and ITM Data sources into single ODS. And i think the last option you have suggested seems to be a very good option... so u want me to load ITM first and then lookup for HDR details right....

Thanks

[Former Member · Accepted solution]

Hi,

you go it except that you have first to load HDR and them ITM; indeed, being given one doc, all items will have the same HDR data.

The process:

1. Load HDR in an HDR ODS; activate data

2. Load ITM in your "merged" ODS and enhance the HDR fields by looking the data in your HDR ODS.

hope this clears your doubts...

Olivier.

[Former Member]

if you use Last Option, you need to work with Exception aggregation. Otherwise there is no meaning for your model...

assume...

HDR:

Delivery No Delivery Value

1000 $1200

1001 $666

ITM:

Delivery No Item Quantity

1000 1 1

1000 2 2

Your ODS Will look like this...

Delivery No Item Quantity Value

1000 1 1 1200

1000 2 2 666

or...

Load your HDR data as part of Delivery Document Header Data if possible. this way you won't run into any issues (this purely depends on requirement).

Nagesh Ganisetti.

• Assign points if it helps.

[Former Member]

Hi Nagesh,

I got your point.... yeah if i laod itm and then look up for hdr details i may end up having duplicate data as you clearly shown in the reply...

<i><u>"Load your HDR data as part of Delivery Document Header Data if possible. this way you won't run into any issues (this purely depends on requirement)."</u></i>

i didnt quite get ur statement... how shud i go around doing what you finally conveyed.. can u like explain me again??

Thanks for a very explanatory reply...

Thanks

[Former Member]

it's type mistake... hdr to Delivery Document master Data... not Delivery Document Header Data.

I just gave one more thought. But, Exception aggregation one is best one to implement.

Nagesh Ganisetti.

• Assign points if it helps.

[Former Member]

Hi

All deliveries in SAP is based on shipping point

Make shipping point as key because all delivery items in a delivery will be from a single shipping point

Regards

N Ganesh