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

Purchase data from MSEG

Dear friends,

I am trying to extract purchase data from MSEG with the help of vendor selection, while taking init every thing is perfect but problem is with delta extraction. If I go for complete MSEG it is carring huge data so I do not wants to load complete data of the same.

The delta specific field is MBLNR (Material document). I am seeking your help to achieve the same.

With Best Regards,

Radharaman

09818669476

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Feb 25, 2009 at 08:15 AM

    Hi,

    First of all I am wondering that what sort of purchasing info your looking from MSEG table. Purchase order info is strored in the tables EKKO,EKPO (respective datasources are: 2LIS_02_HDR, 2LSI_02_ITM).

    If you want to pull tha records from MSEG table, then use the DS 2LIS_03_BF.

    Regards,

    Anil Kumar Sharma .P

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 25, 2009 at 08:17 AM

    Hi,

    Try with 2LIS_02_* and 2LIS_03_* DataSources which support deltas...

    You need to ask MM/SD consulants when MSEG field data will change or ask them how can I identify unique records on daily basis then use that field.

    Thanks

    Reddy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 25, 2009 at 08:41 AM

    Hi

    MSEG holds the Material Data and 2lis_03_BF is the Standard Extractor for this -- But for this DS also you have the delta type ABR1 not compitable for DSO until and unless you apply SAP Note 581778 .

    Hope it helps and clear

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 25, 2009 at 09:26 AM

    Hi friends,

    Thanks for prompt reply, actually I need DMBTR (Amount in LC) from MSEG with respect to purchase because I am not getting the same at other place. Other tabels of purchase are having basic amount only. Please let me know if other purchase table is having same amount field.

    With Regards,

    Radharaman

    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.