C_PurchaseOrderFs

Purchase Order | view: CPURORDERFS | Extraction: Not supported | Component: Purchase Orders
Column Name Description
PurchaseOrder Purchase Order Number
Column Name Description
💲 Currency Key (DocumentCurrency):
PurchaseOrderNetAmount null
Column Name Description
Column Name Description
CreationDate Creation Date of Purchasing Document
PurchaseOrderDate Purchase Order Date
Column Name Description
PurchaseOrderSubtype Control indicator for purchasing document type Show values
PurchasingDocumentOrigin Status of Purchasing Document Show values
PurchasingDocumentCategory Purchasing Document Category Show values
ReleaseIsNotCompleted Release Not Yet Completely Effected Show values
PurchasingCompletenessStatus Purchase order not yet complete Show values
Column Name Description Domain name
PurchasingDocumentType Purchasing Document Type BSART
CreatedByUser User of person who created a purchasing document USNAM
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
CompanyCodeName Name of Company Code or Company TEXT25
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
SupplierName Name 1 NAME
ManualSupplierAddressID Address Number AD_ADDRNUM
SupplierAddressID Address Number AD_ADDRNUM
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
PaymentTermsDescription Payment Terms Description
IncotermsTransferLocation Incoterms (Part 2) INCO2
PurchasingDocumentStatus null
UserFullName User Description SUIDTECHDESC
PurchasingDocumentStatusName Status DDTEXT
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_PURCHASEORDERFS.MANDT == T001.MANDT
  • C_PURCHASEORDERFS.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • C_PURCHASEORDERFS.MANDT == TCURC.MANDT
  • C_PURCHASEORDERFS.DOCUMENTCURRENCY == TCURC.WAERS
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_PURCHASEORDERFS.MANDT == TINC.MANDT
  • C_PURCHASEORDERFS.INCOTERMSCLASSIFICATION == TINC.INCO1
Different Invoicing Party
  • Client
  • Different Invoicing Party
  • C_PURCHASEORDERFS.MANDT == LFA1.MANDT
  • C_PURCHASEORDERFS.INVOICINGPARTY == LFA1.LIFNR
Language Key C_PURCHASEORDERFS.LANGUAGE == T002.SPRAS
Purchase Order Type
  • Client
  • Purchasing Document Type
  • Purchase Order Type
  • Purchasing Document Category
  • C_PURCHASEORDERFS.MANDT == T161.MANDT
  • C_PURCHASEORDERFS.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_PURCHASEORDERFS.PURCHASEORDERTYPE == T161.BSART
  • C_PURCHASEORDERFS.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURCHASEORDERFS.MANDT == T024.MANDT
  • C_PURCHASEORDERFS.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURCHASEORDERFS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURCHASEORDERFS.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • C_PURCHASEORDERFS.MANDT == LFA1.MANDT
  • C_PURCHASEORDERFS.SUPPLIER == LFA1.LIFNR
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • C_PURCHASEORDERFS.MANDT == T001W.MANDT
  • C_PURCHASEORDERFS.SUPPLYINGPLANT == T001W.WERKS
Goods Supplier
  • Client
  • Goods Supplier
  • C_PURCHASEORDERFS.MANDT == LFA1.MANDT
  • C_PURCHASEORDERFS.SUPPLYINGSUPPLIER == LFA1.LIFNR