P_GRIRPURCHASINGDOCITEMDIGEST2

CDS View
29 Fields 1 CDS Views

GR/IR Purchasing Document Item Digest2

P_GRIRPURCHASINGDOCITEMDIGEST2 is a CDS View in S/4HANA. GR/IR Purchasing Document Item Digest2. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_GRIRPurgDocItemDigest view from CONSUMPTION GR/IR Purchasing Document Item Digest

Fields (29)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY PurchasingDocument PurchasingDocument 1
KEY PurchasingDocumentItem PurchasingDocumentItem 1
_CompanyCode _CompanyCode 1
_CompanyCodeCurrency _CompanyCodeCurrency 1
_GlobalCurrency _GlobalCurrency 1
_GRIRProcess _GRIRProcess 1
_PurchasingDocument _PurchasingDocument 1
_PurchasingDocumentItem _PurchasingDocumentItem 1
CompanyCodeCurrency CompanyCodeCurrency 1
CreatedByUser CreatedByUser 1
DocumentCurrency DocumentCurrency 1
GlobalCurrency GlobalCurrency 1
GRIRClearingProcessPriority GRIRClearingProcessPriority 1
GRIRClearingProcessRootCause GRIRClearingProcessRootCause 1
GRIRClrgProcessPrpsdRootCause GRIRClrgProcessPrpsdRootCause 1
GRIRClrgProcessPrpsdStatus GRIRClrgProcessPrpsdStatus 1
GRIRClrgProcPrpsdPriority GRIRClrgProcPrpsdPriority 1
LastChangeDate LastChangeDate 1
LastChangeDateTime LastChangeDateTime 1
MaterialGroup MaterialGroup 1
NumberOfPurchaseOrderItems NumberOfPurchaseOrderItems 1
Plant Plant 1
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
ResponsibleDepartment ResponsibleDepartment 1
ResponsiblePerson ResponsiblePerson 1
Supplier Supplier 1
SupplierName SupplierName 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 Purchasing Document Item Digest2
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPURCHASINGDOCITEMDIGEST2 (
    COMPANYCODE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _GLOBALCURRENCY,
    _GRIRPROCESS,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    COMPANYCODECURRENCY,
    CREATEDBYUSER,
    DOCUMENTCURRENCY,
    GLOBALCURRENCY,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLRGPROCESSPRPSDROOTCAUSE,
    GRIRCLRGPROCESSPRPSDSTATUS,
    GRIRCLRGPROCPRPSDPRIORITY,
    LASTCHANGEDATE,
    LASTCHANGEDATETIME,
    MATERIALGROUP,
    NUMBEROFPURCHASEORDERITEMS,
    PLANT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    SUPPLIER,
    SUPPLIERNAME,
    PRIMARY KEY (COMPANYCODE, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More