P_GRIRPurchasingDocItemDigest1

GR/IR Purchasing Document Item Digest1 | view: PFIGRIRPDOCIDIG1 | Extraction: Not supported | Component: Fiori UI for General Ledger Accounting
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Column Name Description
💲 Global Currency (GlobalCurrency):
AmountInGlobalCurrency Amount in Global Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
BalanceAbsoluteAmtInCoCodeCrcy Balance Absolute Amount In Company Code Currency
💲 Currency Key (DocumentCurrency):
NetAmount Net Order Value in PO Currency
Column Name Description
📏 Purchase Order Unit of Measure (PurgDocOrderQuantityUnit):
BalanceAbsoluteQuantity Balance Absolute Quantity
Column Name Description
LastChangeDate Changed On
Column Name Description
GRIRClearingProcessPriority Priority of GR/IR Clearing Process Show values
GRIRClrgProcPrpsdPriority Proposed Priority of GR/IR Clearing Process Show values
IsCleared Indicator: Has the Item Been Cleared? Show values
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
ResponsibleDepartment Processing Department of GR/IR Clearing Process FIS_GRIR_RESPONSIBLE_DPMNT
ResponsiblePerson Processor of GR/IR Clearing Process XUBNAME
GRIRClearingProcessStatus GR/IR Clearing Process Status FIS_GRIR_CLEARING_STATUS
GRIRClearingProcessRootCause Root Cause for GR/IR Clearing Process FIS_GRIR_CLRG_ROOT_CAUSE
LastChangeDateTime GR/IR Clearing Process Last Change Date Time TZNTSTMPS
ProposedResponsiblePerson Proposed Processor of GR/IR Clearing Process XUBNAME
GRIRClrgProcessPrpsdStatus Proposed Status of GR/IR Clearing Process FIS_GRIR_CLEARING_STATUS
GRIRClrgProcessPrpsdRootCause Proposed Root Cause of GR/IR Clearing Process FIS_GRIR_CLRG_ROOT_CAUSE
SupplierName Name of Supplier TEXT80
NumberOfPurchaseOrderItems Number of Purchasing Document Items
CreatedByUser User of person who created a purchasing document USNAM
LastChangeDays Number of days until the last change
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_GRIRPURCHASINGDOCITEMDIGEST1.COMPANYCODE == T001.BUKRS
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MANDT == TCURC.MANDT
  • P_GRIRPURCHASINGDOCITEMDIGEST1.COMPANYCODECURRENCY == TCURC.WAERS
Currency Key
  • Currency Key
  • Client
  • P_GRIRPURCHASINGDOCITEMDIGEST1.DOCUMENTCURRENCY == TCURC.WAERS
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MANDT == TCURC.MANDT
Global Currency
  • Client
  • Global Currency
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MANDT == TCURC.MANDT
  • P_GRIRPURCHASINGDOCITEMDIGEST1.GLOBALCURRENCY == TCURC.WAERS
Material Group
  • Material Group
  • Client
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MATERIALGROUP == T023.MATKL
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MANDT == T023.MANDT
Plant
  • Plant
  • Client
  • P_GRIRPURCHASINGDOCITEMDIGEST1.PLANT == T001W.WERKS
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MANDT == T001W.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MANDT == T024.MANDT
  • P_GRIRPURCHASINGDOCITEMDIGEST1.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MANDT == T024E.MANDT
  • P_GRIRPURCHASINGDOCITEMDIGEST1.PURCHASINGORGANIZATION == T024E.EKORG
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MANDT == T006.MANDT
  • P_GRIRPURCHASINGDOCITEMDIGEST1.PURGDOCORDERQUANTITYUNIT == T006.MSEHI
Supplier
  • Client
  • Supplier
  • P_GRIRPURCHASINGDOCITEMDIGEST1.MANDT == LFA1.MANDT
  • P_GRIRPURCHASINGDOCITEMDIGEST1.SUPPLIER == LFA1.LIFNR