P_GRIRSituationTrigger

GRIR Sitatuation Handling Trigger View | view: PFIGRIRSITNTRGGR | TRAN | Extraction: Not supported | Component: Information System
Tables used: EKKO, EKPO, ACDOCA, FINS_GRIRPROC, FINS_GRIRPROCHIS, FINSC_LEDGER, LFA1, FINSC_ACTVE_APPL, FINSC_LEDGER_REP
Column Name Description
CompanyCode Company Code
PurchasingDocument Purchasing Document
PurchasingDocumentItem Purchasing Document Item
LastChangeDateTime GR/IR Clearing Process Last Change Date Time
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
GoodsReceiptGoodsAmtInCCCrcy Goods Receipt Amount in Company Code Currency (Goods)
GdsRcptDelivCostAmtInCCCrcy Goods Receipt Amount in Company Code Currency (Delivery Cost
InvoiceRcptGoodsAmtInCCCrcy Invoice Receipt Amount in Company Code Currency (Goods)
InvcRcptDelivCostAmtInCCCrcy Invoice Receipt Amount in Company Code Crcy (Delivery Costs)
GoodsBalanceAmountInCCCrcy Balance Amount in Company Code Currency (Goods)
DeliveryCostBalAmtInCCCrcy Balance Amount in Company Code Currency (Delivery Costs)
GoodsReceiptAmountInCoCodeCrcy Goods Receipt Amount in Company Code Currency
InvoiceRcptAmtInCoCodeCrcy Invoice Receipt Amount in Company Code Currency
BalanceAbsoluteAmtInCoCodeCrcy Balance Absolute Amount In Company Code Currency
BalAmtInCompanyCodeCrcy Total Balance Amount in Company Code Currency
BalAmtInCoCodeCrcyIsChanged null
Column Name Description
GoodsReceiptGdsQtyInRefQtyUnit Goods Receipt Quantity (Goods) in Reference Quantity Unit
GRDelivCostQtyInRefQtyUnit Goods Receipt Quantity (Delivery Costs) in Reference Quantit
InvoiceRcptGdsQtyInRefQtyUnit Invoice Receipt Quantity (Goods) in Reference Quantity Unit
InvcRcptDelivQtyInRefQtyUnit Invoice Quantity (Delivery Costs) in Reference Quantity Unit
GdsBalanceQuantityInRefQtyUnit Balance Quantity (Goods) in Reference Quantity Unit
DelivCostBalQtyInRefQtyUnit Balance Quantity (Delivery Costs) in Reference Quantity Unit
BalanceQuantityIsChanged null
GoodsReceiptQtyIsChanged null
InvoiceReceiptQtyIsChanged null
Column Name Description
LatestOpenItemPostingDate Posting Date of Latest Open Item
OldestOpenItemPostingDate Posting Date of Oldest Open Item
Column Name Description
HasNoGoodsReceiptPosted There is no goods receipt posted. Show values
HasNoInvoiceReceiptPosted There is no invoice receipt posted. Show values
IsGoodsRcptGoodsAmtSurplus There is goods amount surplus in goods receipts. Show values
IsInvoiceGoodsAmountSurplus There is goods amount surplus in invoices. Show values
IsGdsRcptDelivCostAmtSurplus There is delivery cost amount surplus in goods receipts. Show values
IsInvoiceDelivCostAmtSurplus There is delivery cost amount surplus in invoices. Show values
IsGoodsRcptGoodsQtySurplus There is goods quantity surplus in goods receipts. Show values
IsInvoiceGoodsQtySurplus There is goods quantity surplus in invoices. Show values
IsGdsRcptDelivCostQtySurplus There is delivery cost quantity surplus in goods receipts. Show values
IsInvoiceDelivCostQtySurplus There is delivery cost quantity surplus in invoices. Show values
GRIRClrgProcPrpsdPriority Proposed Priority of GR/IR Clearing Process Show values
GRIRClrgProcStatusIsChanged GR/IR Clearing Process Status Has Changed Show values
GRIRClearingProcessPriority Priority of GR/IR Clearing Process Show values
PrevGRIRClrgProcPriority Priority of GR/IR Clearing Process Show values
GRIRClrgProcPriorityIsChanged GR/IR Clearing Process Priority Has Changed Show values
ResponsiblePersonIsChanged Processor of GR/IR Clearing Process Has Changed Show values
ResponsibleDeptIsChanged Processing Department of GR/IR Clearing Process Has Changed Show values
HasNote Notes Included in GR/IR Clearing Process Show values
IsFinallyInvoiced Final Invoice Indicator Show values
Column Name Description Domain name
PurchasingDocumentItemUniqueID Concatenation of EBELN and EBELP PURCHASINGDOCUMENTITEMUNIQUEID
RequisitionerName Name of requisitioner/requester AFNAM
SupplierName Name of Supplier TEXT80
NumberOfOpenItems Number of Open Items FIS_NR_OPEN_ITEM
PrpsdResponsibleDepartment Proposed Processing Department of GR/IR Clearing Process CHAR30
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
GRIRClearingProcessStatus GR/IR Clearing Process Status FIS_GRIR_CLEARING_STATUS
PrevGRIRClearingProcessStatus GR/IR Clearing Process Status FIS_GRIR_CLEARING_STATUS
ResponsiblePerson Processor of GR/IR Clearing Process XUBNAME
PrevResponsiblePerson Processor of GR/IR Clearing Process XUBNAME
ResponsibleDepartment Processing Department of GR/IR Clearing Process FIS_GRIR_RESPONSIBLE_DPMNT
PrevResponsibleDepartment Processing Department of GR/IR Clearing Process FIS_GRIR_RESPONSIBLE_DPMNT
LastChangeDays Days since last processing change INT4
NumberOfDaysSinceLastPosting Number Of Days Since Last Posting FIS_GRIR_DAYS_SINCE_LAST_POST
NumberOfGoodsRcptsIsChanged null
PrevNumberOfInvoiceReceipts Number of Invoice Receipts
LastChangedByUser User of Last Change in GR/IR Clearing Process XUBNAME
GRIRClearingProcessRootCause Root Cause for GR/IR Clearing Process FIS_GRIR_CLRG_ROOT_CAUSE
PrpsdRespDeptMaxClProbability Processing Department Proposal Confidence FIS_GRIR_P_CONF
PrpsdRespPersonMaxClassProblty Processor Proposal Confidence FIS_GRIR_P_CONF
GRIRProposedStatusMaxClProblty Status Proposal Confidence FIS_GRIR_P_CONF
GRIRProposedPrioMaxClProblty Priority Proposal Confidence FIS_GRIR_P_CONF
GRIRPrpsdRootCauseMaxClProblty Root Cause Proposal Confidence FIS_GRIR_P_CONF
PurchasingDocumentItemText Short Text TEXT40
ValuationArea Valuation area BWKEY
NumberOfPurchaseOrderItems Number of Purchasing Document Items
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • P_GRIRSITUATIONTRIGGER.MANDT == T163K.MANDT
  • P_GRIRSITUATIONTRIGGER.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Material Number
  • Client
  • Material Number
  • P_GRIRSITUATIONTRIGGER.MANDT == MARA.MANDT
  • P_GRIRSITUATIONTRIGGER.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_GRIRSITUATIONTRIGGER.MANDT == T023.MANDT
  • P_GRIRSITUATIONTRIGGER.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_GRIRSITUATIONTRIGGER.MANDT == T001W.MANDT
  • P_GRIRSITUATIONTRIGGER.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • P_GRIRSITUATIONTRIGGER.MANDT == T024.MANDT
  • P_GRIRSITUATIONTRIGGER.PURCHASINGGROUP == T024.EKGRP
Purchasing Organization
  • Client
  • Purchasing Organization
  • P_GRIRSITUATIONTRIGGER.MANDT == T024E.MANDT
  • P_GRIRSITUATIONTRIGGER.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • P_GRIRSITUATIONTRIGGER.SUPPLIER == LFA1.LIFNR
  • P_GRIRSITUATIONTRIGGER.MANDT == LFA1.MANDT
Valuation Type
  • Client
  • Valuation Type
  • P_GRIRSITUATIONTRIGGER.MANDT == T149D.MANDT
  • P_GRIRSITUATIONTRIGGER.VALUATIONTYPE == T149D.BWTAR