C_CntrlPurOrdFactSht

Column Name Description
ProcurementHubPO Purchasing Document Number
ExtSourceSystem Connected System ID
Column Name Description
💲 Currency Key (DocumentCurrency):
PurchaseOrderNetAmount Net Value in Document Currency
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
ProcurementHubSourceSystemName Connected System Name TEXT30
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
ProcmtHubSupplierName Name 1 NAME
ProcmtHubCompanyCodeName Name of Company Code or Company TEXT25
ProcmtHubPurgOrgName Connected Purchasing Organisation Name
PurchasingGroupName Description of purchasing group TEXT18
Plant null
CreatedByUser User of person who created a purchasing document USNAM
CreatedByUserFullName Full Name of Person TEXT80
PurchasingProcessingStatus Purchasing document processing state
PaymentTerms Terms of Payment Key
PaymentTermsName Description of terms of payment TEXT30
IncotermsClassificationName Description TEXT30
IncotermsLocation1 Incoterms Location 1 INCO_L
ProcmtHubCompanyCode Connected Company Code BUKRS
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_CNTRLPURORDFACTSHT.COMPANYCODE == T001.BUKRS
  • C_CNTRLPURORDFACTSHT.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_CNTRLPURORDFACTSHT.DOCUMENTCURRENCY == TCURC.WAERS
  • C_CNTRLPURORDFACTSHT.MANDT == TCURC.MANDT
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_CNTRLPURORDFACTSHT.MANDT == TINC.MANDT
  • C_CNTRLPURORDFACTSHT.INCOTERMSCLASSIFICATION == TINC.INCO1
Language Key C_CNTRLPURORDFACTSHT.LANGUAGE == T002.SPRAS
Purchasing Document Type
  • Purchasing Document Category
  • Purchasing Document Type
  • Client
  • C_CNTRLPURORDFACTSHT.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_CNTRLPURORDFACTSHT.PURCHASEORDERTYPE == T161.BSART
  • C_CNTRLPURORDFACTSHT.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_CNTRLPURORDFACTSHT.PURCHASINGGROUP == T024.EKGRP
  • C_CNTRLPURORDFACTSHT.MANDT == T024.MANDT
Purchasing Organization
  • Client
  • Purchasing Organization
  • C_CNTRLPURORDFACTSHT.MANDT == T024E.MANDT
  • C_CNTRLPURORDFACTSHT.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • C_CNTRLPURORDFACTSHT.SUPPLIER == LFA1.LIFNR
  • C_CNTRLPURORDFACTSHT.MANDT == LFA1.MANDT