A_PurchaseOrder

Purchase Order | view: APURCHASEORDER | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKOEKKOADCPADRCLFA1
Column Name Description
PurchaseOrder Purchase Order Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
PurchaseOrderDate Purchase Order Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
PurchasingDocumentDeletionCode Purchase Order Deletion Code Show values
PurchasingProcessingStatus Purchasing document processing state Show values
PurchaseOrderSubtype Control indicator for purchasing document type Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
ExchangeRateIsFixed Indicator for Fixed Exchange Rate Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
IsEndOfPurposeBlocked Business Purpose Completed 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
PurgProdCmplncTotDngrsGoodsSts Dangerous Goods Status (All Items) Show values
Column Name Description Domain name
CreatedByUser User of person who created a purchasing document USNAM
LastChangeDateTime Change Time Stamp TZNTSTMPL
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
ExchangeRate null
SupplierQuotationExternalID Quotation Number ANGNR
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
CorrespncExternalReference Your Reference TEXT12
CorrespncInternalReference Our Reference TEXT12
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
ManualSupplierAddressID Address Number AD_ADDRNUM
AddressCityName City TEXT40
AddressFaxNumber First Fax No.: Area Code + Number CHAR30
AddressHouseNumber House Number TEXT10
AddressName Name 1 TEXT40
AddressPostalCode City postal code CHAR10
AddressStreetName Street TEXT60
AddressPhoneNumber First telephone no.: dialling code+number CHAR30
Master Data Relations Join Conditions
Language key A_PURCHASEORDER.ADDRESSCORRESPONDENCELANGUAGE == T002.SPRAS
Country key
  • Client
  • Country/Region Key
  • A_PURCHASEORDER.MANDT == T005.MANDT
  • A_PURCHASEORDER.ADDRESSCOUNTRY == T005.LAND1
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • A_PURCHASEORDER.MANDT == T005S.MANDT
  • A_PURCHASEORDER.ADDRESSCOUNTRY == T005S.LAND1
  • A_PURCHASEORDER.ADDRESSREGION == T005S.BLAND
Company Code
  • Client
  • Company Code
  • A_PURCHASEORDER.MANDT == T001.MANDT
  • A_PURCHASEORDER.COMPANYCODE == T001.BUKRS
Currency Key
  • Currency Key
  • Client
  • A_PURCHASEORDER.DOCUMENTCURRENCY == TCURC.WAERS
  • A_PURCHASEORDER.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • A_PURCHASEORDER.MANDT == TINC.MANDT
  • A_PURCHASEORDER.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • A_PURCHASEORDER.MANDT == TINCV.MANDT
  • A_PURCHASEORDER.INCOTERMSVERSION == TINCV.INCOV
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • A_PURCHASEORDER.INVOICINGPARTY == LFA1.LIFNR
  • A_PURCHASEORDER.MANDT == LFA1.MANDT
Language Key A_PURCHASEORDER.LANGUAGE == T002.SPRAS
Purchasing Document Type
  • Client
  • ?
  • Purchasing Document Type
  • A_PURCHASEORDER.MANDT == T161.MANDT
  • A_PURCHASEORDER.[column in domain "BSTYP"] == T161.BSTYP
  • A_PURCHASEORDER.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • A_PURCHASEORDER.MANDT == T024.MANDT
  • A_PURCHASEORDER.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • A_PURCHASEORDER.PURCHASINGORGANIZATION == T024E.EKORG
  • A_PURCHASEORDER.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • A_PURCHASEORDER.SUPPLIER == LFA1.LIFNR
  • A_PURCHASEORDER.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • A_PURCHASEORDER.MANDT == T001W.MANDT
  • A_PURCHASEORDER.SUPPLYINGPLANT == T001W.WERKS
Goods Supplier
  • Client
  • Goods Supplier
  • A_PURCHASEORDER.MANDT == LFA1.MANDT
  • A_PURCHASEORDER.SUPPLYINGSUPPLIER == LFA1.LIFNR