P_GRIRANALYSIS

CDS View
37 Fields 4 CDS Views

Analyze GR/IR Account Reconciliation

P_GRIRANALYSIS is a CDS View in S/4HANA. Analyze GR/IR Account Reconciliation. It contains 37 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
P_GRIRProcessDigest view from CONSUMPTION GR/IR Reconcilation Monitor Digest
P_GRIRProcessDigest view union_all CONSUMPTION GR/IR Reconcilation Monitor Digest
P_GRIRPurchasingDocItemDigest1 view from CONSUMPTION GR/IR Purchasing Document Item Digest1
P_GRIRPurchasingDocItemDigest1 view union_all CONSUMPTION GR/IR Purchasing Document Item Digest1

Fields (37)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 2
KEY CompanyCode CompanyCode 2
KEY FiscalYear FiscalYear 2
KEY LedgerGLLineItem LedgerGLLineItem 2
_AccountingDocument _AccountingDocument 1
_CompanyCode _CompanyCode 1
_CompanyCodeCurrency _CompanyCodeCurrency 2
_FiscalYear _FiscalYear 1
_GlobalCurrency _GlobalCurrency 2
_GRIRProcess _GRIRProcess 1
_PurchasingDocument _PurchasingDocument 1
_PurchasingDocumentItem _PurchasingDocumentItem 1
AccountingDocumentItem AccountingDocumentItem 2
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency 3
AmountInGlobalCurrency AmountInGlobalCurrency 3
BalanceAbsoluteAmtInCoCodeCrcy BalanceAbsoluteAmtInCoCodeCrcy 3
BalanceAbsoluteQuantity BalanceAbsoluteQuantity 1
ChartOfAccounts ChartOfAccounts 1
CompanyCodeCurrency CompanyCodeCurrency 3
ControllingArea ControllingArea 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 3
PostingDate PostingDate 1
PostingKey PostingKey 1
PurchasingDocument PurchasingDocument 2
PurchasingDocumentItem PurchasingDocumentItem 2
PurgDocOrderQuantityUnit PurgDocOrderQuantityUnit 1
ReferenceDocumentType ReferenceDocumentType 1
TransactionTypeDetermination TransactionTypeDetermination 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.

-- Analyze GR/IR Account Reconciliation
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRANALYSIS (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGERGLLINEITEM,
    _ACCOUNTINGDOCUMENT,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _FISCALYEAR,
    _GLOBALCURRENCY,
    _GRIRPROCESS,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    ACCOUNTINGDOCUMENTITEM,
    AMOUNTINCOMPANYCODECURRENCY,
    AMOUNTINGLOBALCURRENCY,
    BALANCEABSOLUTEAMTINCOCODECRCY,
    BALANCEABSOLUTEQUANTITY,
    CHARTOFACCOUNTS,
    COMPANYCODECURRENCY,
    CONTROLLINGAREA,
    CREDITAMOUNTINCOCODECRCY,
    CREDITAMOUNTINGLOBALCRCY,
    DEBITAMOUNTINCOCODECRCY,
    DEBITAMOUNTINGLOBALCRCY,
    DEBITCREDITCODE,
    DOCUMENTDATE,
    DUEDAYS,
    FISCALPERIOD,
    GLACCOUNT,
    GLOBALCURRENCY,
    POSTINGDATE,
    POSTINGKEY,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    PURGDOCORDERQUANTITYUNIT,
    REFERENCEDOCUMENTTYPE,
    TRANSACTIONTYPEDETERMINATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGERGLLINEITEM)
);

Learn More