Skip to Content

Plant Change on Date capture

Hello BW gurus,

We have multiple manufacturing warehouses, for example (M) and multiple distribution warehouses for example (D)

We often ship goods directly from Manufacturing w/house or some times move from Manufacturing w/house to Distribution w/house and then ship from there.

I want to capture the "change on" date where my goods are moved from M to D. If the goods move from manufacturing w/house to Distribution warehouse then i should have the change on date based on the document number.

The data will be filtered using the date(s) provided by the user against VBAK – ERDAT and VBAK – AEDAT to validate if the order should be included in the data set as a new order.

Once this subset of changed mismatch orders has been determined, it will be filtered again against table CDHDR. based on document number. If the date matches those selected then the DOC NO should be recorded and after that a secondary check needs to be done against CDPOS using the DOC NO. If the Field WERKS is found then that record should be kept and presented in the dataset to the user. If that DOC NO does not contain the field WERKS than the order should be eliminated from the list.

How can I go about and achieve it, can I create generic extractor based on tables VBAK, CDHDR and CDPOS and then use the change on date for plant from CDPOS, if YES then what fields do I need to use from table CDHDR and CDPOS.

Thank You and will appreciate your reply.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 10, 2018 at 05:39 PM

    Hi,

    Regardless of the underlying business logic, beware of querying CDHDR and CDPOS tables. These tables are usually very large and extraction runtimes may be heavily impacted.

    Good luck

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Rodolfo

      I only need few fields from CDHDR and CDPOS such as created on and changed on date along with object value.

      Will this make a huge difference in terms of performance issue ?

      Thanks

  • Oct 12, 2018 at 01:03 PM

    Most probably, mainly depending on the size of your database. But, in any case, expect long runtimes unless you find a way (that I'm unaware of) to select/query from these tables with a suitable table key or index.

    Add comment
    10|10000 characters needed characters exceeded