Skip to Content
author's profile photo Former Member
Former Member

Generic extractor on table MKPF

Hello,

We have created a generic datasource in R/3 on table MKPF. We have made it as delta enabled on AEDAT (Changed on) field. But in our production system, this field is always blank. So delta will not work.

There are two other calendar day fields which are BUDAT (Posting Date in the Document) & BLDAT (Document Date in Document).

Could you please let us know which field should be taken so that our deltas work fine?

Thanks in advance.

Nitin.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2010 at 11:43 AM

    you can use the field "CPUDT".

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 09, 2010 at 07:07 PM

    Hi Nitin,

    yes you can use BUDAT rather. But keep in mind, that BUDAT will not refelct changes. But talk to someone from MM and clarify how changes (cancellations to material movements) are handled. When the AEDAT is always blank, I assume that changes to material movements mean cancellation of previous documet and creation of new documment (at the end you create two documnets: one for zeroing out the intial document and a second one which reflects change).

    Aban

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2010 at 02:41 PM

    Hi,

    You can use either of the 2 dates, BLDAT, CPUDT. I would not suggest using BUDAT(posting date) as this date may be a future date as well, which would mean that you would not get these records in BI till the day that this date has arrived.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.