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

2LIS_06_INV Extractor Taking data from DRSEG

http://help.sap.com/saphelp_nw70/helpdata/en/57/dad06449114814919000e27dfb255e/content.htm?frameset=/en/9a/3070f709f04bbe90b3445f85e2388c/frameset.htm&current_toc=/en/74/457053bbe77c1ee10000000a174cb4/plain.htm&node_id=67

Hi All,

I am trying to extract data using the logistic extractor 2LIS_06_INV and according to the above document I see it is pulling data from DRSEG. But I can't find any database table named the same but a structure. Any thoughts on where the extractor is pulling these data??

Thanks

Regards,

Methma

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2015 at 09:10 AM

    Hi Methma,

    These values are populated from a structure EK08G and sub structure EK08BN (Delivery Costs for Invoice Verification (New)). These structure populates values during run time.


    Thanks,

    Shakthi Raj Natarajan.

    Fields in the Extract StructureDescription of the Field in the Extract StructureTable of OriginField in the Table of OriginBELNRAccounting document numberRBKPBELNRBUZEIItem in invoice documentRSEGBUZEIGJAHRFiscal yearRBKPGJAHRCOBL_NRFour-character running number for account assignment blockRBCOCOBL_NRARKUEMWVAT portion of automatic invoice reduction amountRBKPARKUEMWARKUENAutomatic invoice reduction amount (net)RBKPARKUENBEZNKUnplanned delivery costsRBKPBEZNKBKTXTDocument header textRBKPBKTXTBLDATDocument date in documentRBKPBLDATBUDATPosting date in documentRBKPBUDATBUKRSCompany codeRBKPBUKRSDIFFMWVAT portion of invoice verification differenceRBEXDIFFMWDIFFNDocument balanceRBEXDIFFNIVTYPOrigin of a Logistics Invoice Verification documentRBKPIVTYPLIEFFMWVAT portion of vendor errorRBKPLIEFFMWLIEFFNVendor error excluding VATRBKPLIEFFNLIFNRDifferent invoicing partyRBKPLIFNRLOGSYSLogical systemRBKPLOGSYSMAKZMWManually accepted VAT amountRBKPMAKZMWMAKZNManually accepted difference amount netRBKPMAKZNMRM_ZLSPRLogistics payment blockRBKPVMRM_ZLSPRMWSKZ_BNKTax codeRBKPMWSKZ_BNKRBSTATInvoice document statusRBKPRBSTATRMWWRGross invoice amount in document currencyRSEGRMWWRSTBLGNumber of reversal documentRBKPSTBLGSTJAHFiscal year of reversal documentRBKPSTJAHWAERSCurrency keyDRSEGWAERSWMWST1Tax amount in document with sign 
(+/-)RBKPWMWST1XBLNRReference document numberRBKPXBLNRXRECHIndicator: Post invoiceRBKPXRECHZLSPRKey for payment blockRBKPZLSPRAFNAMName of requesterDRSEGAFNAMAREWRClearing value on GR/IR account in local currencyDRSEGAREWRBASMEBOM base unit of measureRSEGMEINSBEWAEPurchase order currencyDRSEGBEWAEBPMNGQuantity in purchase order price unitRSEGBPMNGBPRBMInvoice quantity according to vendor invoice in PO price unitRSEGBPRBMBPREMInvoice receipt quantity in PO price unitDRSEGBPREMBPRMEPurchase order price unitRSEGBPRMEBPUMNDenominator for conversion of OPUn into OUnDRSEGBPUMNBPUMZNumerator for conversion of OPUn into OUnDRSEGBPUMZBPWEMGoods receipt quantity in purchase order price unitDRSEGBPWEMBSMNGOrdered quantity of purchase requisitionDRSEGBSMNGBSTMEPurchase order unitRSEGBSTMEEBELNPurchasing document numberRSEGEBELNEBELPPurchasing document item numberRSEGEBELPEKGRPPurchasing groupDRSEGEKGRPEKORGPurchasing organizationEKKOEKORGEREKZFinal invoice indicatorRSEGEREKZHWAERCurrency keyDRSEGHWAERKNTTPAccount assignment categoryRSEGKNTTPKONNRNumber of principal agreementEKPOKONNRKTPNRItem number of principal agreementEKPOKTPNRLFBNRDocument number of a reference documentRSEGLFBNRLFGJAFiscal year of the current periodRSEGLFGJALFPOSItem in a reference documentRSEGLFPOSLIFNR2Vendor account numberEKKOLIFNRMATKLMaterial/service groupDRSEGMATKLMATNRMaterial numberRSEGMATNRMEINSBase unit of measureDRSEGMEINSMENGEQuantityRSEGMENGENETPRNet price in purchasing document in document currencyDRSEGNETPRNETWRNet value in document currencyDRSEGNETWRNOQUANTITYNo quantity logic (document item without quantity)DRSEGNOQUANTITYPEINHPrice unitDRSEGPEINHPSTYPItem category in purchasing documentRSEGPSTYPRBMNGInvoice quantity according to vendor invoice in purchase order unitRSEGRBMNGRBWWRInvoice amount in document currency according to vendor invoiceRSEGRBWWRREFWREntered invoice value in foreign currencyDRSEGREFWRREMNGInvoice receipt quantityDRSEGREMNGRETPOReturns itemDRSEGRETPOREWWRInvoice amount in foreign currencyDRSEGREWWRSHKZGDebit/credit indicatorRSEGSHKZGSPGRCBlocking reason 'quality'RSEGSPGRCSPGRGBlocking reason 'purchase order price quantity'RSEGSPGRGSPGRMBlocking reason 'quantity'RSEGSPGRMSPGRPBlocking reason 'price'RSEGSPGRPSPGRQBlocking reason 'manual'RSEGSPGRQSPGRSBlocking reason 'amount'RSEGSPGRSSPGRTBlocking reason 'date/time'RSEGSPGRTSPGRVBlocking reason 'project budget'RSEGSPGRVTBTKZIndicator: Subsequent debitRSEGTBTKZTXZ01Short textDRSEGTXZ01UMRENDenominator for conversion into base units of measureDRSEGUMRENUMREZNumerator for conversion into base units of measureDRSEGUMREZWEMNGGoods receipt quantityDRSEGWEMNGWENWRAccepted service value net in foreign currencyRSEGWENWRWEPOSGoods receipt indicatorDRSEGWEPOSWERKSPlantRSEGWERKSWEUNBGoods receipt non-valuatedDRSEGWEUNBWEWWRGoods receipt value in foreign currencyDRSEGWEWWRWRBTRAmount in document currencyRSEGWRBTRANLN1Main asset numberRBCOANLN1ANLN2Asset subnumberRBCOANLN2AREWWClearing value on GR/IR account in transaction currencyDRSEGAREWWAUFNROrder numberRBCOAUFNRFIKRSFM areaRBCOFIKRSFIPOSCommitment itemRBCOFIPOSFISTLFunds centerRBCOFISTLFKBERFunctional areaRBCOFKBERGEBERFundRBCOGEBERGSBERBusiness areaRBCOGSBERKOARTAccount typeDRSEGKOARTKOKRSControlling areaRBCOKOKRSKOSTLCost centerRBCOKOSTLKTOPLChart of accountsRBCOKTOPLLSTARActivity typeRBCOLSTARNPLNRNetwork number for account assignmentRBCONPLNRPAOBJNRNumber for profitability segments (CO-PA)RBCOPAOBJNRPRCTRProfit centerRBCOPRCTRPS_PSP_PNRWork breakdown schedule (WBS) elementRBCOPS_PSP_PNRSAKNRG/L account numberRBCOSAKNRVORNRTransaction/event numberRBCOVORNRROCANCELRecord type at time of extraction of Invoice Verification data (table/field of origin determined by extraction.)-—PRDIFFPrice Difference in Local CurrencyBSEG
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 12, 2015 at 01:53 PM

    Hi MEthma,

    Check the table RBCO & RBDRSEG.

    RBCO Document Item, Incoming Invoice, Account Assignment

    RBDRSEG Batch IV: Invoice Document Items

    Thanks,

    Shakthi Raj Natarajan

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Shakthi,

      Thanks for your response. It was indeed helpful. But still some fields still cannot be found in RBDRSEG or RBCO. For example AFNAM, AREWR, BEWAE, MATKL, UMREN etc. But still they get extracted by the datasource. Any thoughts ?

      Regards,

      Methma

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.