C_GRIRPurchasingDocItem

GR/IR Purchasing Document Item | view: CFIGRIRPURDOCITM | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Column Name Description
PurchasingDocument FK Purchasing Document
PurchasingDocumentItem Purchasing Document Item
Column Name Description
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
OrderQuantity Purchase Order Quantity
Column Name Description
PurchasingDocumentOrderDate Purchasing Document Date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
IsFinallyInvoiced Final Invoice Indicator Show values
IsDeleted Purchasing info: General data flagged for deletion Show values
Column Name Description Domain name
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
FaxNumber Fax number of purchasing (buyer) group TEXT31
PurchasingGroupPhoneNumber Telephone number of purchasing group (buyer group) CHAR12
PurchasingDocumentItemText Short Text TEXT40
LastChangeDateTime Change Time Stamp TZNTSTMPL
CreatedByUser User of person who created a purchasing document USNAM
RequisitionerUser Name of Person Responsible for Creating the Object USNAM
NetPriceQuantity Price Unit DEC5
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_GRIRPURCHASINGDOCITEM.COMPANYCODE == T001.BUKRS
  • C_GRIRPURCHASINGDOCITEM.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • C_GRIRPURCHASINGDOCITEM.MANDT == TCURC.MANDT
  • C_GRIRPURCHASINGDOCITEM.DOCUMENTCURRENCY == TCURC.WAERS
Language Key C_GRIRPURCHASINGDOCITEM.LANGUAGE == T002.SPRAS
Material number
  • Client
  • Material number
  • C_GRIRPURCHASINGDOCITEM.MANDT == MARA.MANDT
  • C_GRIRPURCHASINGDOCITEM.MANUFACTURERMATERIAL == MARA.MATNR
Material Number
  • Client
  • Material Number
  • C_GRIRPURCHASINGDOCITEM.MANDT == MARA.MANDT
  • C_GRIRPURCHASINGDOCITEM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_GRIRPURCHASINGDOCITEM.MANDT == T023.MANDT
  • C_GRIRPURCHASINGDOCITEM.MATERIALGROUP == T023.MATKL
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_GRIRPURCHASINGDOCITEM.MANDT == T006.MANDT
  • C_GRIRPURCHASINGDOCITEM.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • C_GRIRPURCHASINGDOCITEM.MANDT == T001W.MANDT
  • C_GRIRPURCHASINGDOCITEM.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Category
  • Client
  • Purchasing Document Type
  • C_GRIRPURCHASINGDOCITEM.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_GRIRPURCHASINGDOCITEM.MANDT == T161.MANDT
  • C_GRIRPURCHASINGDOCITEM.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • C_GRIRPURCHASINGDOCITEM.MANDT == T024.MANDT
  • C_GRIRPURCHASINGDOCITEM.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Client
  • Purchasing Organization
  • C_GRIRPURCHASINGDOCITEM.MANDT == T024E.MANDT
  • C_GRIRPURCHASINGDOCITEM.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • C_GRIRPURCHASINGDOCITEM.MANDT == LFA1.MANDT
  • C_GRIRPURCHASINGDOCITEM.SUPPLIER == LFA1.LIFNR