P_GRIRPROCESSDIGEST

CDS View

GR/IR Reconcilation Monitor Digest

P_GRIRPROCESSDIGEST is a CDS View in S/4HANA. GR/IR Reconcilation Monitor Digest. It contains 63 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_GRIRProcessDigest view_entity from CONSUMPTION GR/IR Reconcilation Monitor Digest

Fields (63)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 1
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 1
KEY LedgerGLLineItem LedgerGLLineItem 1
_CalendarMonth _CalendarMonth 1
_ChartOfAccounts _ChartOfAccounts 1
_CompanyCode _CompanyCode 1
_CompanyCodeCurrency _CompanyCodeCurrency 1
_ControllingArea _ControllingArea 1
_FiscalYear _FiscalYear 1
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts 1
_GlobalCurrency _GlobalCurrency 1
_GRIRProcess _GRIRProcess 1
_JournalEntry _JournalEntry 1
_MaterialGroup _MaterialGroup 1
_Plant _Plant 1
_ProfitCenter _ProfitCenter 1
_PurchasingDocumentItem _PurchasingDocumentItem 1
_PurchasingGroup _PurchasingGroup 1
_PurchasingOrganization _PurchasingOrganization 1
_Supplier _Supplier 1
AccountAssignmentCategory AccountAssignmentCategory 1
AccountingDocumentItem AccountingDocumentItem 1
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 1
AmountInGlobalCurrency AmountInGlobalCurrency 1
BalanceAbsoluteAmtInCoCodeCrcy BalanceAbsoluteAmtInCoCodeCrcy 1
CalendarMonth CalendarMonth 1
CalendarYear CalendarYear 1
ChartOfAccounts ChartOfAccounts 1
CompanyCodeCurrency CompanyCodeCurrency 1
CompanyCodeName CompanyCodeName 1
ControllingArea ControllingArea 1
CreatedByUser CreatedByUser 1
CreditAmountInCoCodeCrcy CreditAmountInCoCodeCrcy 1
CreditAmountInGlobalCrcy CreditAmountInGlobalCrcy 1
DebitAmountInCoCodeCrcy DebitAmountInCoCodeCrcy 1
DebitAmountInGlobalCrcy DebitAmountInGlobalCrcy 1
DebitCreditCode DebitCreditCode 1
DocumentDate DocumentDate 1
DueDays DueDays 1
FiscalPeriod FiscalPeriod 1
GLAccount GLAccount 1
GlobalCurrency GlobalCurrency 1
GRIRClearingProcessPriority GRIRClearingProcessPriority 1
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 1
GRIRClearingProcessStatus GRIRClearingProcessStatus 1
MaterialGroup MaterialGroup 1
Plant Plant 1
PlantName PlantName 1
PostingDate PostingDate 1
PostingKey PostingKey 1
ProfitCenter ProfitCenter 1
PurchasingDocument PurchasingDocument 1
PurchasingDocumentItem PurchasingDocumentItem 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
ReferenceDocumentType ReferenceDocumentType 1
ResponsibleDepartment ResponsibleDepartment 1
ResponsiblePerson ResponsiblePerson 1
Supplier Supplier 1
SupplierName SupplierName 1
TransactionTypeDetermination TransactionTypeDetermination 1
YearMonth YearMonth 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- GR/IR Reconcilation Monitor Digest
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPROCESSDIGEST (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGERGLLINEITEM,
    _CALENDARMONTH,
    _CHARTOFACCOUNTS,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _CONTROLLINGAREA,
    _FISCALYEAR,
    _GLACCOUNTINCHARTOFACCOUNTS,
    _GLOBALCURRENCY,
    _GRIRPROCESS,
    _JOURNALENTRY,
    _MATERIALGROUP,
    _PLANT,
    _PROFITCENTER,
    _PURCHASINGDOCUMENTITEM,
    _PURCHASINGGROUP,
    _PURCHASINGORGANIZATION,
    _SUPPLIER,
    ACCOUNTASSIGNMENTCATEGORY,
    ACCOUNTINGDOCUMENTITEM,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    BALANCEABSOLUTEAMTINCOCODECRCY,
    CALENDARMONTH,
    CALENDARYEAR,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    COMPANYCODENAME,
    CONTROLLINGAREA,
    CREATEDBYUSER,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINGLOBALCRCY,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINGLOBALCRCY,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    DUEDAYS,
    FISCALPERIOD,
    GLACCOUNT,
    GLOBALCURRENCY,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLEARINGPROCESSSTATUS,
    MATERIALGROUP,
    PLANT,
    PLANTNAME,
    POSTINGDATE,
    POSTINGKEY,
    PROFITCENTER,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    REFERENCEDOCUMENTTYPE,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    SUPPLIER,
    SUPPLIERNAME,
    TRANSACTIONTYPEDETERMINATION,
    YEARMONTH,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGERGLLINEITEM)
);