C_CentralPurchaseOrderTP

Column Name Description
ProcurementHubPO Purchasing Document Number
ExtSourceSystem Connected System ID
Column Name Description
💲 Currency Key (DocumentCurrency):
PurchaseOrderNetAmount_H Net Value in Document Currency
PurchaseOrderNetAmount Net Value in Document Currency
Column Name Description
Column Name Description
ScheduleLineDeliveryDate Item delivery date
CreationDate Creation Date of Purchasing Document
PurchaseOrderDate Purchase Order Date
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Purchasing Document Status Show values
PurchasingProcessingStatus Purchasing document processing state Show values
IsIntrastatReportingRelevant Relevant for Intrastat Reporting Show values
IsIntrastatReportingExcluded Exclude from Intrastat Reporting Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
PrmtHbIsUKMSEnabled Flag for UKMS enabled Show values
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
Column Name Description Domain name
ProcurementHubSourceSystemName Connected System Name TEXT30
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
ProcmtHubSupplierName Name 1
CompanyCodeCountry Country/Region Key LAND1
ProcmtHubCompanyCodeName Name of Company Code or Company TEXT25
ProcmtHubPurgOrgName Connected Purchasing Organisation Name
PurchasingGroupName Description of purchasing group TEXT18
NumberOfOverduePurOrders Number of Overdue Purchase Orders INT4
NumberOfOverduePurOrdItm Number of Overdue Purchase Orders Items
WeightedRelevance Weighted Relevance
Plant null
ProcmtHubProduct null
ProcmtHubProductGroup null
PurOrdOutputCtrlType Purchase Order Output Status Flag CHAR1
PurchaseOrderOutputDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ApproverName Approver Name TEXT40
CreatedByUser User of person who created a purchasing document USNAM
CreatedByUserFullName Full Name of Person TEXT80
PurchaseOrderOutputStatus Purchase Order Output Status Flag
PurchaseOrderOutputStatusName Purchase Order Output Status name CHAR60
PurchaseOrderStatus Purchasing Document Status
PurchaseOrderStatusName Purchase order status name CHAR260
ApprovalStatusName Approval Status of PO
ApproverUser Approver XUBNAME
PaymentTerms Terms of Payment Key
PaymentTermsName Description of terms of payment TEXT30
CashDiscount1Days Cash discount days 1
CashDiscount1Percent Cash discount percentage 1
CashDiscount2Days Cash discount days 2
CashDiscount2Percent Cash Discount Percentage 2
NetPaymentDays Net Payment Terms Period
IncotermsClassificationName Description TEXT30
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
IncotermsTransferLocation Incoterms (Part 2)
ExchangeRateForEdit null
ExchangeRateIsFixed Indicator for Fixed Exchange Rate
HasNote Boolean Variables (X=true, space=false)
HasAttachment Boolean Variables (X=true, space=false)
ProcmtHubLastExtractionTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
NoteTypeListText null
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
ManualSupplierAddressID Address Number AD_ADDRNUM
SupplierRespSalesPersonName Responsible Salesperson at Supplier's Office TEXT30
SupplierPhoneNumber Supplier's Telephone Number TEXT16
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
DeliveryDocumentCondition Number of the Document Condition KNUMV
LastChangeDateTime Change Time Stamp TZNTSTMPL
ProcmtHubCompanyCode Connected Company Code BUKRS
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_CENTRALPURCHASEORDERTP.COMPANYCODE == T001.BUKRS
  • C_CENTRALPURCHASEORDERTP.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • C_CENTRALPURCHASEORDERTP.MANDT == TCURC.MANDT
  • C_CENTRALPURCHASEORDERTP.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_CENTRALPURCHASEORDERTP.MANDT == TINC.MANDT
  • C_CENTRALPURCHASEORDERTP.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Client
  • Incoterms Version
  • C_CENTRALPURCHASEORDERTP.MANDT == TINCV.MANDT
  • C_CENTRALPURCHASEORDERTP.INCOTERMSVERSION == TINCV.INCOV
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • C_CENTRALPURCHASEORDERTP.MANDT == LFA1.MANDT
  • C_CENTRALPURCHASEORDERTP.INVOICINGPARTY == LFA1.LIFNR
Language Key C_CENTRALPURCHASEORDERTP.LANGUAGE == T002.SPRAS
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • ?
  • Client
  • ?
  • C_CENTRALPURCHASEORDERTP.PRICINGPROCEDURE == T683.KALSM
  • C_CENTRALPURCHASEORDERTP.[column in domain "KAPPL"] == T683.KAPPL
  • C_CENTRALPURCHASEORDERTP.MANDT == T683.MANDT
  • C_CENTRALPURCHASEORDERTP.[column in domain "KVEWE"] == T683.KVEWE
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • C_CENTRALPURCHASEORDERTP.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_CENTRALPURCHASEORDERTP.MANDT == T161.MANDT
  • C_CENTRALPURCHASEORDERTP.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • C_CENTRALPURCHASEORDERTP.PURCHASINGGROUP == T024.EKGRP
  • C_CENTRALPURCHASEORDERTP.MANDT == T024.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_CENTRALPURCHASEORDERTP.PURCHASINGORGANIZATION == T024E.EKORG
  • C_CENTRALPURCHASEORDERTP.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • C_CENTRALPURCHASEORDERTP.MANDT == LFA1.MANDT
  • C_CENTRALPURCHASEORDERTP.SUPPLIER == LFA1.LIFNR
Goods Supplier
  • Goods Supplier
  • Client
  • C_CENTRALPURCHASEORDERTP.SUPPLYINGSUPPLIER == LFA1.LIFNR
  • C_CENTRALPURCHASEORDERTP.MANDT == LFA1.MANDT