I_PurchaseOrderAPI01

Purchase Order | view: IMMPURORDAPI01 | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO
Column Name Description
PurchaseOrder Purchase Order Number
Column Name Description
💲 Currency Key (DocumentCurrency):
DownPaymentAmount Down Payment Amount in Document Currency
PurgReleaseTimeTotalAmount Total value at time of release
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
PurchaseOrderDate Purchase Order Date
DownPaymentDueDate Due Date for Down Payment
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
PurchaseOrderSubtype Control indicator for purchasing document type 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
PurchasingProcessingStatus Purchasing document processing state Show values
IsIntrastatReportingRelevant Relevant for Intrastat Reporting Show values
IsIntrastatReportingExcluded Exclude from Intrastat Reporting Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
CorrespncExternalReference Your Reference TEXT12
CorrespncInternalReference Our Reference TEXT12
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
PurgReleaseSequenceStatus Release State FRGZU
ManualSupplierAddressID Address Number AD_ADDRNUM
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
SupplierQuotationExternalID Quotation Number ANGNR
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
DownPaymentType Down Payment Indicator ME_DPTYPE_DOMAIN
DownPaymentPercentageOfTotAmt Down Payment Percentage PRZ32
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
PricingDocument Number of the Document Condition KNUMV
ExchangeRate Exchange Rate KURSP
LastChangeDateTime Change Time Stamp TZNTSTMPL
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • I_PURCHASEORDERAPI01.COMPANYCODE == T001.BUKRS
  • I_PURCHASEORDERAPI01.MANDT == T001.MANDT
Customer Number
  • Customer Number
  • Client
  • I_PURCHASEORDERAPI01.CUSTOMER == KNA1.KUNNR
  • I_PURCHASEORDERAPI01.MANDT == KNA1.MANDT
Currency Key
  • Currency Key
  • Client
  • I_PURCHASEORDERAPI01.DOCUMENTCURRENCY == TCURC.WAERS
  • I_PURCHASEORDERAPI01.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_PURCHASEORDERAPI01.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_PURCHASEORDERAPI01.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_PURCHASEORDERAPI01.INCOTERMSVERSION == TINCV.INCOV
  • I_PURCHASEORDERAPI01.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • I_PURCHASEORDERAPI01.INVOICINGPARTY == LFA1.LIFNR
  • I_PURCHASEORDERAPI01.MANDT == LFA1.MANDT
Language Key I_PURCHASEORDERAPI01.LANGUAGE == T002.SPRAS
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • I_PURCHASEORDERAPI01.PRICINGPROCEDURE == T683.KALSM
  • I_PURCHASEORDERAPI01.[column in domain "KAPPL"] == T683.KAPPL
  • I_PURCHASEORDERAPI01.[column in domain "KVEWE"] == T683.KVEWE
  • I_PURCHASEORDERAPI01.MANDT == T683.MANDT
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • I_PURCHASEORDERAPI01.PURCHASEORDERTYPE == T161.BSART
  • I_PURCHASEORDERAPI01.[column in domain "BSTYP"] == T161.BSTYP
  • I_PURCHASEORDERAPI01.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_PURCHASEORDERAPI01.PURCHASINGGROUP == T024.EKGRP
  • I_PURCHASEORDERAPI01.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_PURCHASEORDERAPI01.PURCHASINGORGANIZATION == T024E.EKORG
  • I_PURCHASEORDERAPI01.MANDT == T024E.MANDT
Reason for Cancellation
  • Reason for Cancellation
  • Client
  • I_PURCHASEORDERAPI01.PURGREASONFORDOCCANCELLATION == T165R.ABSGR
  • I_PURCHASEORDERAPI01.MANDT == T165R.MANDT
Release Indicator: Purchasing Document
  • Release Indicator: Purchasing Document
  • Client
  • I_PURCHASEORDERAPI01.RELEASECODE == T16FB.FRGKE
  • I_PURCHASEORDERAPI01.MANDT == T16FB.MANDT
Supplier
  • Supplier
  • Client
  • I_PURCHASEORDERAPI01.SUPPLIER == LFA1.LIFNR
  • I_PURCHASEORDERAPI01.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • I_PURCHASEORDERAPI01.SUPPLYINGPLANT == T001W.WERKS
  • I_PURCHASEORDERAPI01.MANDT == T001W.MANDT
Goods Supplier
  • Goods Supplier
  • Client
  • I_PURCHASEORDERAPI01.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • I_PURCHASEORDERAPI01.MANDT == LFA1.MANDT
Country/Region for Tax Report
  • Country/Region for Tax Report
  • Client
  • I_PURCHASEORDERAPI01.TAXRETURNCOUNTRY == T005.LAND1
  • I_PURCHASEORDERAPI01.MANDT == T005.MANDT