C_Purchaseorders_Fs

Consumption Factsheet-Purchase Ord Facet | view: CPRCHORDERS | Extraction: Not supported | Component: Material Master
Tables used: EKKOEKPOT001TKA02T161TT024T024ET001WLFA1ADRPUSR21
Column Name Description
PurchasingDocument Purchasing Document Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
PurchasingDocumentOrderDate Purchasing Document Date
Column Name Description
Column Name Description Domain name
CompanyCodeName Name of Company Code or Company TEXT25
PurchasingDocumentDeletionCode null
IncotermsTransferLocation Incoterms (Part 2) INCO2
PaymentTerms Terms of Payment Key ZTERM
CreatedByUser User of person who created a purchasing document USNAM
PurchasingGroupName Purchasing Group Name TEXT18
PurchasingOrganizationName Purchasing Organization Name TEXT20
SupplierName null
PersonFullName Full Name of Person TEXT80
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PlantName Plant Name TEXT30
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_PURCHASEORDERS_FS.MANDT == T001.MANDT
  • C_PURCHASEORDERS_FS.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • C_PURCHASEORDERS_FS.MANDT == TCURC.MANDT
  • C_PURCHASEORDERS_FS.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_PURCHASEORDERS_FS.MANDT == TINC.MANDT
  • C_PURCHASEORDERS_FS.INCOTERMSCLASSIFICATION == TINC.INCO1
Material Number
  • Client
  • Material Number
  • C_PURCHASEORDERS_FS.MANDT == MARA.MANDT
  • C_PURCHASEORDERS_FS.MATERIAL == MARA.MATNR
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURCHASEORDERS_FS.MANDT == T024.MANDT
  • C_PURCHASEORDERS_FS.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURCHASEORDERS_FS.MANDT == T024E.MANDT
  • C_PURCHASEORDERS_FS.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • C_PURCHASEORDERS_FS.SUPPLIER == LFA1.LIFNR
  • C_PURCHASEORDERS_FS.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • C_PURCHASEORDERS_FS.MANDT == T001W.MANDT
  • C_PURCHASEORDERS_FS.SUPPLYINGPLANT == T001W.WERKS