C_PurchaseOrderGR

View for GR and Purchase Order | view: CDOCLPOGR | Extraction: Not supported | Component: Purchasing
Tables used: EKKO, EKPO, EKET, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, KNA1, T001W, LFA1, T163B, LFA1, T161M
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Currency Key (Currency):
PurchaseOrderItemNetAmount Net Order Value in PO Currency
Column Name Description
PurchaseOrderQty Purchase Order Quantity
Column Name Description
Column Name Description
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
PurchaseOrderItemText Short Text TEXT40
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PURCHASEORDERGR.COMPANYCODE == T001.BUKRS
  • C_PURCHASEORDERGR.MANDT == T001.MANDT
Currency Key
  • Currency Key
  • Client
  • C_PURCHASEORDERGR.CURRENCY == TCURC.WAERS
  • C_PURCHASEORDERGR.MANDT == TCURC.MANDT
Material number
  • Material number
  • Client
  • C_PURCHASEORDERGR.MANUFACTURERMATERIAL == MARA.MATNR
  • C_PURCHASEORDERGR.MANDT == MARA.MANDT
Material Number
  • Client
  • Material Number
  • C_PURCHASEORDERGR.MANDT == MARA.MANDT
  • C_PURCHASEORDERGR.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_PURCHASEORDERGR.MATERIALGROUP == T023.MATKL
  • C_PURCHASEORDERGR.MANDT == T023.MANDT
Plant
  • Client
  • Plant
  • C_PURCHASEORDERGR.MANDT == T001W.MANDT
  • C_PURCHASEORDERGR.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PURCHASEORDERGR.MANDT == T006.MANDT
  • C_PURCHASEORDERGR.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • C_PURCHASEORDERGR.PURCHASEORDERTYPE == T161.BSART
  • C_PURCHASEORDERGR.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURCHASEORDERGR.MANDT == T161.MANDT
Item category in purchasing document
  • Item category in purchasing document
  • Client
  • C_PURCHASEORDERGR.PURCHASINGDOCUMENTCATEGORY == T163.PSTYP
  • C_PURCHASEORDERGR.MANDT == T163.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURCHASEORDERGR.PURCHASINGGROUP == T024.EKGRP
  • C_PURCHASEORDERGR.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURCHASEORDERGR.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURCHASEORDERGR.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PURCHASEORDERGR.SUPPLIER == LFA1.LIFNR
  • C_PURCHASEORDERGR.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • C_PURCHASEORDERGR.MANDT == T001W.MANDT
  • C_PURCHASEORDERGR.SUPPLYINGPLANT == T001W.WERKS