R_PurchasingDocument

Purchasing Document | view: RMMPURCHASINGDOC | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO
Column Name Description
PurchasingDocument Purchasing Document Number
Column Name Description
💲 Currency Key (DocumentCurrency):
TargetAmount Target Value for Header Area per Distribution
PurgReleaseTimeTotalAmount Total value at time of release
DownPaymentAmount Down Payment Amount in Document Currency
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
PurchasingDocumentOrderDate Purchasing Document Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
QuotationLatestSubmissionDate Deadline for Submission of Bid/Quotation
BindingPeriodValidityEndDate Binding Period for Quotation
QuotationSubmissionDate Quotation Submission Date
DownPaymentDueDate Due Date for Down Payment
QuotationEarliestSubmsnDate The date as of which Quotations can be submitted
LatestRegistrationDate Closing Date for Applications
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentSubtype Control indicator for purchasing document type Show values
PurchasingDocumentIsAged Document is aged Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
PurgDocumentDistributionType Distribution Type for Purchasing Document Show values
ScheduleAgreementHasReleaseDoc Indicator for scheduling agreement release documentation Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
PurchasingProcessingStatus Purchasing document processing state Show values
FollowOnDocumentCategory Follow-On Purchasing Document Category Show values
IsIntrastatReportingRelevant Relevant for Intrastat Reporting Show values
IsIntrastatReportingExcluded Exclude from Intrastat Reporting Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
PurgDocChangeRequestStatus Change Request Status Show values
PurgProdCmplncTotDngrsGoodsSts Dangerous Goods Status (All Items) Show values
PurgAggrgdProdCmplncSuplrSts Product Compliance Supplier Check Status (All Items) Show values
PurgAggrgdProdMarketabilitySts Product Marketability Status (All Items) Show values
PurgAggrgdSftyDataSheetStatus Safety Data Sheet Status (All Items) Show values
Column Name Description Domain name
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
ItemNumberInterval Item Number Interval PINCR
ItemNumberIntervalForSubItems Item Number Interval for Subitems PINCR
PurgReleaseSequenceStatus Release State FRGZU
LastChangeDateTime Change Time Stamp TZNTSTMPL
CreatedByUser User of person who created a purchasing document USNAM
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
SupplierAddressID Address Number AD_ADDRNUM
ManualSupplierAddressID Address Number AD_ADDRNUM
CorrespncExternalReference Your Reference TEXT12
CorrespncInternalReference Our Reference TEXT12
ExchangeRate Exchange Rate KURSP
IncotermsTransferLocation Incoterms (Part 2) INCO2
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Days Cash discount days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash discount percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
PricingDocument Number of the Document Condition KNUMV
SupplierQuotationExternalID Quotation Number ANGNR
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
DownPaymentType Down Payment Indicator ME_DPTYPE_DOMAIN
DownPaymentPercentageOfTotAmt Down Payment Percentage PRZ32
PurchasingDocumentName Name of Purchasing Document TEXT40
FollowOnDocumentType Follow-On Purchasing Document Type BSART
VATRegistration VAT Registration Number STCEG
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
ActivePurchasingDocument Active Purchasing Document EBELN
PurchasingDocumentVersion Version number in Purchasing REVNO
PurchasingParentDocument ID of the Parent Document EBELN
ProcmtHubCompanyCodeGroupingID Grouping ID for Company Codes MMPUR_D_CC_GROUPING_ID
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • R_PURCHASINGDOCUMENT.MANDT == T001.MANDT
  • R_PURCHASINGDOCUMENT.COMPANYCODE == T001.BUKRS
Customer Number
  • Customer Number
  • Client
  • R_PURCHASINGDOCUMENT.CUSTOMER == KNA1.KUNNR
  • R_PURCHASINGDOCUMENT.MANDT == KNA1.MANDT
Currency Key
  • Client
  • Currency Key
  • R_PURCHASINGDOCUMENT.MANDT == TCURC.MANDT
  • R_PURCHASINGDOCUMENT.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • R_PURCHASINGDOCUMENT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • R_PURCHASINGDOCUMENT.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • R_PURCHASINGDOCUMENT.INCOTERMSVERSION == TINCV.INCOV
  • R_PURCHASINGDOCUMENT.MANDT == TINCV.MANDT
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • R_PURCHASINGDOCUMENT.MANDT == LFA1.MANDT
  • R_PURCHASINGDOCUMENT.INVOICINGPARTY == LFA1.LIFNR
Language Key R_PURCHASINGDOCUMENT.LANGUAGE == T002.SPRAS
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • Client
  • ?
  • R_PURCHASINGDOCUMENT.PRICINGPROCEDURE == T683.KALSM
  • R_PURCHASINGDOCUMENT.[column in domain "KVEWE"] == T683.KVEWE
  • R_PURCHASINGDOCUMENT.MANDT == T683.MANDT
  • R_PURCHASINGDOCUMENT.[column in domain "KAPPL"] == T683.KAPPL
Purchasing Document Type
  • Client
  • Purchasing Document Type
  • Purchasing Document Category
  • R_PURCHASINGDOCUMENT.MANDT == T161.MANDT
  • R_PURCHASINGDOCUMENT.PURCHASINGDOCUMENTTYPE == T161.BSART
  • R_PURCHASINGDOCUMENT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • R_PURCHASINGDOCUMENT.PURCHASINGGROUP == T024.EKGRP
  • R_PURCHASINGDOCUMENT.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • R_PURCHASINGDOCUMENT.PURCHASINGORGANIZATION == T024E.EKORG
  • R_PURCHASINGDOCUMENT.MANDT == T024E.MANDT
Release Strategy
  • Release Strategy
  • ?
  • Client
  • R_PURCHASINGDOCUMENT.PURCHASINGRELEASESTRATEGY == T16FS.FRGSX
  • R_PURCHASINGDOCUMENT.[column in domain "FRGGR"] == T16FS.FRGGR
  • R_PURCHASINGDOCUMENT.MANDT == T16FS.MANDT
Reason for Cancellation
  • Reason for Cancellation
  • Client
  • R_PURCHASINGDOCUMENT.PURGREASONFORDOCCANCELLATION == T165R.ABSGR
  • R_PURCHASINGDOCUMENT.MANDT == T165R.MANDT
Release Indicator: Purchasing Document
  • Client
  • Release Indicator: Purchasing Document
  • R_PURCHASINGDOCUMENT.MANDT == T16FB.MANDT
  • R_PURCHASINGDOCUMENT.RELEASECODE == T16FB.FRGKE
Supplier
  • Client
  • Supplier
  • R_PURCHASINGDOCUMENT.MANDT == LFA1.MANDT
  • R_PURCHASINGDOCUMENT.SUPPLIER == LFA1.LIFNR
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • R_PURCHASINGDOCUMENT.MANDT == T001W.MANDT
  • R_PURCHASINGDOCUMENT.SUPPLYINGPLANT == T001W.WERKS
Goods Supplier
  • Client
  • Goods Supplier
  • R_PURCHASINGDOCUMENT.MANDT == LFA1.MANDT
  • R_PURCHASINGDOCUMENT.SUPPLYINGSUPPLIER == LFA1.LIFNR
Country/Region for Tax Report
  • Country/Region for Tax Report
  • Client
  • R_PURCHASINGDOCUMENT.TAXRETURNCOUNTRY == T005.LAND1
  • R_PURCHASINGDOCUMENT.MANDT == T005.MANDT