C_GRIRPurgDocItemStatus

DDL: C_GRIRPURGDOCITEMSTATUS Type: view_entity CONSUMPTION Package: FINS_FIS_FICO_APPS
38 Fields 1 Data Sources 4 Associations 1 OData Services

GR/IR Purchasing Document Item Status

C_GRIRPurgDocItemStatus is a Consumption CDS View that provides data about "GR/IR Purchasing Document Item Status" in SAP S/4HANA. It reads from 1 data source (P_GRIRPurgDocItemStatus2) and exposes 38 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem. It has 4 associations to related views. It is exposed through 1 OData service (ASQL_F3303). Part of development package FINS_FIS_FICO_APPS.

Data Sources (1)

SourceAliasJoin Type
P_GRIRPurgDocItemStatus2 P_GRIRPurgDocItemStatus2 from

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_GRIRProcessStatusText _GRIRProcessStatusText $projection.GRIRClearingProcessStatus = _GRIRProcessStatusText.GRIRClearingProcessStatus
[0..*] I_GRIRProcessPriorityText _GRIRProcessPriorityText $projection.GRIRClearingProcessPriority = _GRIRProcessPriorityText.GRIRClearingProcessPriority
[0..*] I_GRIRProcessRootCauseText _GRIRProcessRootCauseText $projection.GRIRClearingProcessRootCause = _GRIRProcessRootCauseText.GRIRClearingProcessRootCause
[0..*] I_MaterialGroupText _MaterialGroupText $projection.MaterialGroup = _MaterialGroupText.MaterialGroup

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label GR/IR Purchasing Document Item Status view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey PurchasingDocumentItem view
Analytics.technicalName CFIGRIRPDOCISTS view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F3303 ASQL_F3303 C2 NOT_RELEASED

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_GRIRPurgDocItemStatus2 CompanyCode Receiver Company Code
KEY PurchasingDocument P_GRIRPurgDocItemStatus2 PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem P_GRIRPurgDocItemStatus2 PurchasingDocumentItem Purchasing Doc. Item
GlobalCurrency P_GRIRPurgDocItemStatus2 GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency
CompanyCodeCurrency P_GRIRPurgDocItemStatus2 CompanyCodeCurrency Local Currency
AmountInCompanyCodeCurrency
BalanceAbsoluteAmtInCoCodeCrcy
DocumentCurrency P_GRIRPurgDocItemStatus2 DocumentCurrency Document Currency
NetAmount
CreatedByUser P_GRIRPurgDocItemStatus2 CreatedByUser User Name
GRIRClearingProcessStatus P_GRIRPurgDocItemStatus2 GRIRClearingProcessStatus Status
GRIRClearingProcessPriority P_GRIRPurgDocItemStatus2 GRIRClearingProcessPriority Priority
GRIRClearingProcessRootCause P_GRIRPurgDocItemStatus2 GRIRClearingProcessRootCause Root Cause
IsCleared P_GRIRPurgDocItemStatus2 IsCleared Integer
LastChangeDays
NumberOfPurchaseOrderItems P_GRIRPurgDocItemStatus2 NumberOfPurchaseOrderItems Number of PO Items
Plant P_GRIRPurgDocItemStatus2 Plant Valuation Area
PlantName
PurchasingGroup P_GRIRPurgDocItemStatus2 PurchasingGroup Purchasing Group
PurchasingGroupName
PurchasingOrganization P_GRIRPurgDocItemStatus2 PurchasingOrganization Purchasing Organization
ResponsibleDepartment P_GRIRPurgDocItemStatus2 ResponsibleDepartment Processing Department
ResponsiblePerson P_GRIRPurgDocItemStatus2 ResponsiblePerson Processor
Supplier P_GRIRPurgDocItemStatus2 Supplier Supplier
SupplierName P_GRIRPurgDocItemStatus2 SupplierName Supplier Name
MaterialGroup P_GRIRPurgDocItemStatus2 MaterialGroup Product Group
AccountAssignmentCategory
_GlobalCurrency P_GRIRPurgDocItemStatus2 _GlobalCurrency
_CompanyCode P_GRIRPurgDocItemStatus2 _CompanyCode
_CompanyCodeCurrency P_GRIRPurgDocItemStatus2 _CompanyCodeCurrency
_GRIRProcessStatus P_GRIRPurgDocItemStatus2 _GRIRProcessStatus
_PurchasingDocument P_GRIRPurgDocItemStatus2 _PurchasingDocument
_PurchasingDocumentItem P_GRIRPurgDocItemStatus2 _PurchasingDocumentItem
_GRIRProcessStatusText _GRIRProcessStatusText
_GRIRProcessPriorityText _GRIRProcessPriorityText
_GRIRProcessRootCauseText _GRIRProcessRootCauseText
_MaterialGroupText _MaterialGroupText

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_GRIRPurgDocItemStatus.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_GRIRPurgDocItemStatus AS
SELECT
  P_GRIRPurgDocItemStatus2.CompanyCode AS CompanyCode,
  P_GRIRPurgDocItemStatus2.PurchasingDocument AS PurchasingDocument,
  P_GRIRPurgDocItemStatus2.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_GRIRPurgDocItemStatus2.GlobalCurrency AS GlobalCurrency,
  cast( P_GRIRPurgDocItemStatus2.AmountInGlobalCurrency as fis_ksl preserving type ) AS AmountInGlobalCurrency,
  P_GRIRPurgDocItemStatus2.CompanyCodeCurrency AS CompanyCodeCurrency,
  cast( P_GRIRPurgDocItemStatus2.AmountInCompanyCodeCurrency as fis_hsl preserving type) AS AmountInCompanyCodeCurrency,
  cast( P_GRIRPurgDocItemStatus2.BalanceAbsoluteAmtInCoCodeCrcy as fis_abs_bal_dmbtr preserving type) AS BalanceAbsoluteAmtInCoCodeCrcy,
  P_GRIRPurgDocItemStatus2.DocumentCurrency AS DocumentCurrency,
  cast( P_GRIRPurgDocItemStatus2.NetAmount as bwert preserving type) AS NetAmount,
  P_GRIRPurgDocItemStatus2.CreatedByUser AS CreatedByUser,
  P_GRIRPurgDocItemStatus2.GRIRClearingProcessStatus AS GRIRClearingProcessStatus,
  P_GRIRPurgDocItemStatus2.GRIRClearingProcessPriority AS GRIRClearingProcessPriority,
  P_GRIRPurgDocItemStatus2.GRIRClearingProcessRootCause AS GRIRClearingProcessRootCause,
  P_GRIRPurgDocItemStatus2.IsCleared AS IsCleared,
  cast(P_GRIRPurgDocItemStatus2.LastChangeDays as fis_last_change_days preserving type) AS LastChangeDays,
  P_GRIRPurgDocItemStatus2.NumberOfPurchaseOrderItems AS NumberOfPurchaseOrderItems,
  P_GRIRPurgDocItemStatus2.Plant AS Plant,
  P_GRIRPurgDocItemStatus2._PurchasingDocumentItem._Plant.PlantName AS PlantName,
  P_GRIRPurgDocItemStatus2.PurchasingGroup AS PurchasingGroup,
  P_GRIRPurgDocItemStatus2._PurchasingDocument._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  P_GRIRPurgDocItemStatus2.PurchasingOrganization AS PurchasingOrganization,
  P_GRIRPurgDocItemStatus2.ResponsibleDepartment AS ResponsibleDepartment,
  P_GRIRPurgDocItemStatus2.ResponsiblePerson AS ResponsiblePerson,
  P_GRIRPurgDocItemStatus2.Supplier AS Supplier,
  P_GRIRPurgDocItemStatus2.SupplierName AS SupplierName,
  P_GRIRPurgDocItemStatus2.MaterialGroup AS MaterialGroup,
  P_GRIRPurgDocItemStatus2._PurchasingDocumentItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  P_GRIRPurgDocItemStatus2._GlobalCurrency AS _GlobalCurrency,
  P_GRIRPurgDocItemStatus2._CompanyCode AS _CompanyCode,
  P_GRIRPurgDocItemStatus2._CompanyCodeCurrency AS _CompanyCodeCurrency,
  P_GRIRPurgDocItemStatus2._GRIRProcessStatus AS _GRIRProcessStatus,
  P_GRIRPurgDocItemStatus2._PurchasingDocument AS _PurchasingDocument,
  P_GRIRPurgDocItemStatus2._PurchasingDocumentItem AS _PurchasingDocumentItem
FROM P_GRIRPurgDocItemStatus2
LEFT OUTER JOIN I_GRIRProcessStatusText AS _GRIRProcessStatusText ON GRIRClearingProcessStatus = _GRIRProcessStatusText.GRIRClearingProcessStatus  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessPriorityText AS _GRIRProcessPriorityText ON GRIRClearingProcessPriority = _GRIRProcessPriorityText.GRIRClearingProcessPriority  -- association [0..*]
LEFT OUTER JOIN I_GRIRProcessRootCauseText AS _GRIRProcessRootCauseText ON GRIRClearingProcessRootCause = _GRIRProcessRootCauseText.GRIRClearingProcessRootCause  -- association [0..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
;

Learn More