P_GRIRPURGDOCITEMSTATUS1

CDS View
26 Fields 1 CDS Views

GR/IR Purchasing Document Item Status

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

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_GRIRPurgDocItemStatus2 view from CONSUMPTION GR/IR Purchasing Document Item Status

Fields (26)

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
_GRIRProcessStatus _GRIRProcessStatus 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
GRIRClearingProcessStatus GRIRClearingProcessStatus 1
IsCleared IsCleared 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 Status
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_GRIRPURGDOCITEMSTATUS1 (
    COMPANYCODE,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    _COMPANYCODE,
    _COMPANYCODECURRENCY,
    _GLOBALCURRENCY,
    _GRIRPROCESSSTATUS,
    _PURCHASINGDOCUMENT,
    _PURCHASINGDOCUMENTITEM,
    COMPANYCODECURRENCY,
    CREATEDBYUSER,
    DOCUMENTCURRENCY,
    GLOBALCURRENCY,
    GRIRCLEARINGPROCESSPRIORITY,
    GRIRCLEARINGPROCESSROOTCAUSE,
    GRIRCLEARINGPROCESSSTATUS,
    ISCLEARED,
    MATERIALGROUP,
    NUMBEROFPURCHASEORDERITEMS,
    PLANT,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    RESPONSIBLEDEPARTMENT,
    RESPONSIBLEPERSON,
    SUPPLIER,
    SUPPLIERNAME,
    PRIMARY KEY (COMPANYCODE, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM)
);

Learn More