Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Validity Date Data Modelling Quesiton

We want to design a Product Repository.

The main table will store product information based on VALIDITY DATES.

We have say 30 fields in the main table.

Any of the 30 fields could change based on the validity date.

We have the practise of working with SKU in the future.

Ex:

<u>ProductID Description SalesUnit Start Validity Date End Validity Date</u>

Printer01 HP Inkjet EA 02/06/2006 06/06/2006

Printer01 HP Special Jet EA 06/07/2006 04/04/2007

How can you represent the same SKU based on validity dates?

Note: Any of the 30 fields in the main table could change based on validity date.

In the Example above, Printer01 is called HP Inkjet based on a validity date.

The same Product Printer01 is called HP Special Jet based on a future validity date.

Qn: How can we model this scenario.

Any leads is appreciated.

I promise to reward the answers which are helpful.

Thanks,

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question