C_InApprovalPurchaseOrderItem

In Approval Purchase Order Items | view: CINAPPO | TRAN | Extraction: Not supported | Component: Reporting
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
💲 Display Currency (DisplayCurrency):
NetAmount null
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Column Name Description
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
PurchasingCategory Purchasing Category ID /SRMSMC/OBJECT_ID
MaterialName Material Description TEXT40
SupplierName Name of Supplier TEXT80
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_INAPPROVALPURCHASEORDERITEM.MANDT == T001.MANDT
  • C_INAPPROVALPURCHASEORDERITEM.COMPANYCODE == T001.BUKRS
Material Number
  • Client
  • Material Number
  • C_INAPPROVALPURCHASEORDERITEM.MANDT == MARA.MANDT
  • C_INAPPROVALPURCHASEORDERITEM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_INAPPROVALPURCHASEORDERITEM.MANDT == T023.MANDT
  • C_INAPPROVALPURCHASEORDERITEM.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_INAPPROVALPURCHASEORDERITEM.MANDT == T001W.MANDT
  • C_INAPPROVALPURCHASEORDERITEM.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_INAPPROVALPURCHASEORDERITEM.MANDT == T006.MANDT
  • C_INAPPROVALPURCHASEORDERITEM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Group
  • Client
  • Purchasing Group
  • C_INAPPROVALPURCHASEORDERITEM.MANDT == T024.MANDT
  • C_INAPPROVALPURCHASEORDERITEM.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_INAPPROVALPURCHASEORDERITEM.PURCHASINGORGANIZATION == T024E.EKORG
  • C_INAPPROVALPURCHASEORDERITEM.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_INAPPROVALPURCHASEORDERITEM.SUPPLIER == LFA1.LIFNR
  • C_INAPPROVALPURCHASEORDERITEM.MANDT == LFA1.MANDT