C_PurchaseOrderTP

Purchase Order | view: CPURORDTP | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: EKKO, EKPO, EKET, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, EKKO, T163B, T161T, LFA1, USR21, T161M
Column Name Description
PurchaseOrder Purchase Order Number
Column Name Description
💲 Currency Key (DocumentCurrency):
PurchaseOrderNetAmount Total Net Order Value in Document Currency
Column Name Description
Column Name Description
ScheduleLineDeliveryDate null
CreationDate Creation Date of Purchasing Document
PurchaseOrderDate Purchase Order Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
IsAdvancedPurchaseOrder Purchase Order is Advanced Show values
IsIntrastatReportingRelevant Relevant for Intrastat Reporting Show values
IsIntrastatReportingExcluded Exclude from Intrastat Reporting Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
PurchaseOrderHasCommitmentItem Indicator that Purchase Order has Commitment 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
PurgProdCmplncTotDngrsGoodsSts Dangerous Goods Status (All Items) Show values
ProductComplianceIsActive Boolean Variable (X = True, - = False, Space = Unknown) Show values
PurchaseOrderSubtype Control indicator for purchasing document type Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
PurchasingDocumentDeletionCode Purchase Order Deletion Code Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingProcessingStatus Purchasing document processing state Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
Column Name Description Domain name
PurchaseOrderTypeName Short Description of Purchasing Document Type TEXT20
NumberOfOverduePurOrders null
NumberOfOverduePurOrdItm_H null
NumberOfOverduePurOrdItm null
PurchaseOrderStatus null
PurchaseOrderStatusName Purchase Order Status CHAR40
PurchaseOrderStatus_H null
PurchasingDocumentStatus null
WeightedRelevance Weighted Relevance
ManufacturerMaterial null
Plant null
PurOrdOutputCtrlType null
PurchaseOrderOutputStatus null
PurchaseOrderOutputStatusName null
PurchaseOrderOutputDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ApproverName Approver Name TEXT40
CreatedByUser User of person who created a purchasing document USNAM
CreatedByUserFullName User Description SUIDTECHDESC
ApprovalStatusName Approval Status of PO TEXT40
ApproverUser Approver ID CHAR12
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash discount days 1
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Days Cash discount days 2
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
NetPaymentDays Net Payment Terms Period ZBDXT
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
ExchangeRateForEdit null
ExchangeRateIsFixed Indicator for Fixed Exchange Rate
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
CorrespncExternalReference Your Reference TEXT12
CorrespncInternalReference Our Reference TEXT12
PurgTotProdCmplncSuplrStsName Description Prod. Compl. Supplier Check Status (All Items) TEXT60
UICT_PurgAggrgdCmplncSuplrSts null
PurgTotMarketabilityStsName Description of Product Marketability Status (All Items) TEXT60
UICT_PurgAggrgMarketabilitySts null
PurgAggrgdSftyDataSheetStsName Description of Safety Data Sheet Status (All Items) TEXT60
UICT_PurgAggrgSftyDataSheetSts null
PurgTotDangerousGoodsStsName Description of Dangerous Goods Status (All Items) TEXT60
UICT_PurgCmplncTotDngrsGdsSts null
ManualSupplierAddressID Address Number AD_ADDRNUM
SupplierAddressID Address Number AD_ADDRNUM
PurchasingDocumentCondition Number of the Document Condition KNUMV
IncotermsTransferLocation Incoterms (Part 2) INCO2
LastChangeDateTime Change Time Stamp TZNTSTMPL
SupplierName Name of Supplier TEXT80
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PURCHASEORDERTP.COMPANYCODE == T001.BUKRS
  • C_PURCHASEORDERTP.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • C_PURCHASEORDERTP.MANDT == TCURC.MANDT
  • C_PURCHASEORDERTP.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_PURCHASEORDERTP.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_PURCHASEORDERTP.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_PURCHASEORDERTP.INCOTERMSVERSION == TINCV.INCOV
  • C_PURCHASEORDERTP.MANDT == TINCV.MANDT
Different Invoicing Party
  • Different Invoicing Party
  • Client
  • C_PURCHASEORDERTP.INVOICINGPARTY == LFA1.LIFNR
  • C_PURCHASEORDERTP.MANDT == LFA1.MANDT
Language Key C_PURCHASEORDERTP.LANGUAGE == T002.SPRAS
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • ?
  • Client
  • C_PURCHASEORDERTP.PRICINGPROCEDURE == T683.KALSM
  • C_PURCHASEORDERTP.[column in domain "KAPPL"] == T683.KAPPL
  • C_PURCHASEORDERTP.[column in domain "KVEWE"] == T683.KVEWE
  • C_PURCHASEORDERTP.MANDT == T683.MANDT
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • C_PURCHASEORDERTP.PURCHASEORDERTYPE == T161.BSART
  • C_PURCHASEORDERTP.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURCHASEORDERTP.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURCHASEORDERTP.PURCHASINGGROUP == T024.EKGRP
  • C_PURCHASEORDERTP.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_PURCHASEORDERTP.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURCHASEORDERTP.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PURCHASEORDERTP.SUPPLIER == LFA1.LIFNR
  • C_PURCHASEORDERTP.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Supplying (issuing) plant in case of stock transport order
  • Client
  • C_PURCHASEORDERTP.SUPPLYINGPLANT == T001W.WERKS
  • C_PURCHASEORDERTP.MANDT == T001W.MANDT
Goods Supplier
  • Goods Supplier
  • Client
  • C_PURCHASEORDERTP.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • C_PURCHASEORDERTP.MANDT == LFA1.MANDT