C_GRItm

Goods Receipt Document Items | view: CGRITM | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: VBAPMATDOCEKKOEKBEEKPOEKBEHVBAKVBAPVBKDVEDAEKKOEKPOT003T003TBUT000T001TKA02T156T156HTT148T148TT158VT158WMARAT023T023TMAKTT134T134TT157DT157ET001WT161T161TT024T001LLFA1ADCPADR2ADR3ADR6ADRPUSR21
Column Name Description
MaterialDocument Number of Material Document
MaterialDocumentItem Item in Material Document
MaterialDocumentYear Material Document Year
Column Name Description
Column Name Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
Quantity Quantity
OrderQuantity Purchase Order Quantity
Column Name Description
DocumentDate Document Date in Document
PostingDate Posting Date in the Document
DeliveryDate Delivery Date
Column Name Description
InventoryStockType Stock Type of Goods Movement (Stock Identifier) Show values
ObjectType Num1 Show values
Column Name Description Domain name
FormattedPurDoc null
MaterialName Material Description TEXT40
PlantName Plant Name TEXT30
FormattedPurchasingDocItem Purchase Order Item
GoodsMovementTypeName Movement Type Text (Inventory Management) BTEXT
ReferenceDocument Document No. of a Reference Document
DebitCreditCode Debit/Credit Indicator
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
MaterialGroupName Product Group Description TEXT20
SupplierName Name of Supplier TEXT80
PurchasingGroupName Purchasing Group Name TEXT18
StorageLocationName Storage Location Name TEXT16
ServicePerformer Service Performer BU_PARTNER
ServicePerformerName null
MaterialDocumentItemText Item Text
MaterialTypeName Description of Material Type TEXT25
ReasonForPhysInvtryDiffText Text: Reason for Goods Movement TEXT20
GoodsMovementReasonCode Reason for Movement MB_GRBEW
IsCancelled Item has been Cancelled
InventoryStockTypeName Stock Type Name DDTEXT
InventorySpecialStockType Special Stock Type
InventorySpecialStockTypeName Description of special stock TEXT20
InventoryTransactionType Transaction/Event Type
InventoryTransactionTypeText Long Text TEXT40
Batch Batch Number CHARG
BillOfLading Number of Bill of Lading at Time of Goods Receipt XBLNR1
GoodsReceiptIsNonValuated Goods Receipt, Non-Valuated
HasMultipleAccountAssignment Multiple Account Assignment CHAR1
MultipleAccountAssignmentCode Multiple Account Assignment
CreatedByUser Name of Person Responsible for Creating the Object USNAM
DeliveryDocumentItem Delivery Document Item
MaterialDocumentHeaderText Document Header Text
ManufacturingOrder Manufacturing Order AUFNR
IssuingOrReceivingPlant Transfer Plant
IssuingOrReceivingPlantName Plant Name TEXT30
SalesOrderItemText Short text for sales order item TEXT40
WorkItem Work Item ID
AccountingDocumentType Document Type BLART
AccountingDocumentTypeName Document Type Name TEXT20
DeliveryDocument Delivery VBELN
Status null
StatusName Short Description DDTEXT
FullName Full Name of Person
PurchasingDocument Number of Material Document
SupplyingPlant null
PurchasingDocumentItemCategory null
AccountAssignmentCategory null
CostCenter null
SalesOrder null
WBSElementExternalID null
Master Data Relations Join Conditions
Movement type (inventory management)
  • Client
  • Movement type (inventory management)
  • C_GRITM.MANDT == T156.MANDT
  • C_GRITM.GOODSMOVEMENTTYPE == T156.BWART
Material Number
  • Client
  • Material Number
  • C_GRITM.MANDT == MARA.MANDT
  • C_GRITM.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • C_GRITM.MATERIALGROUP == T023.MATKL
  • C_GRITM.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • C_GRITM.MATERIALTYPE == T134.MTART
  • C_GRITM.MANDT == T134.MANDT
Plant
  • Client
  • Plant
  • C_GRITM.MANDT == T001W.MANDT
  • C_GRITM.PLANT == T001W.WERKS
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_GRITM.MANDT == T006.MANDT
  • C_GRITM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Document Type
  • ?
  • Client
  • Purchasing Document Type
  • Purchasing Document Type
  • C_GRITM.[column in domain "BSTYP"] == T161.BSTYP
  • C_GRITM.MANDT == T161.MANDT
  • C_GRITM.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_GRITM.PURCHASEORDERTYPE == T161.BSART
Purchasing Document Type
  • ?
  • Client
  • Purchasing Document Type
  • Purchasing Document Type
  • C_GRITM.[column in domain "BSTYP"] == T161.BSTYP
  • C_GRITM.MANDT == T161.MANDT
  • C_GRITM.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_GRITM.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Purchasing Group
  • Client
  • C_GRITM.PURCHASINGGROUP == T024.EKGRP
  • C_GRITM.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_GRITM.PURCHASINGORGANIZATION == T024E.EKORG
  • C_GRITM.MANDT == T024E.MANDT
Storage Location
  • Storage Location
  • Client
  • Plant
  • C_GRITM.STORAGELOCATION == T001L.LGORT
  • C_GRITM.MANDT == T001L.MANDT
  • C_GRITM.PLANT == T001L.WERKS
Supplier
  • Supplier
  • Client
  • C_GRITM.SUPPLIER == LFA1.LIFNR
  • C_GRITM.MANDT == LFA1.MANDT