C_ClrdInvcPurgDocWthoutGds

DDL: C_CLRDINVCPURGDOCWTHOUTGDS SQL: CGRCCLINVPDWTHTG Type: view CONSUMPTION
28 Fields 1 Data Sources

PO with cleared invoices without a GR

C_ClrdInvcPurgDocWthoutGds is a Consumption CDS View that provides data about "PO with cleared invoices without a GR" in SAP S/4HANA. It reads from 1 data source (P_ClrdInvcPurgDocWthoutGds) and exposes 28 fields with key fields CompanyCode, PurchasingDocument, PurchasingDocumentItem, SupplierInvoice, SupplierInvoiceItem.

Data Sources (1)

SourceAliasJoin Type
P_ClrdInvcPurgDocWthoutGds P_ClrdInvcPurgDocWthoutGds from

Parameters (1)

NameTypeDefault
P_ComparisonDurationInDays grcfc_duration_days

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGRCCLINVPDWTHTG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label PO with cleared invoices without a GR view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode Receiver Company Code
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
KEY SupplierInvoice SupplierInvoice
KEY SupplierInvoiceItem SupplierInvoiceItem
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingOrganization PurchasingOrganization Purchasing Organization
CreationDate CreationDate Time Stamp
InvoiceCreatedByUser InvoiceCreatedByUser
GrossAmount GrossAmount Gross value
CreatedByUser CreatedByUser User Name
PurchasingDocumentCreationDate PurchasingDocumentCreationDate Time Stamp
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingDocumentOrigin PurchasingDocumentOrigin Status
DocumentCurrency DocumentCurrency Document Currency
NumberOfGoodsReceipts NumberOfGoodsReceipts Number of Goods Receipts
NumberOfInvoiceReceipts NumberOfInvoiceReceipts Number of Invoice Receipts
Material Material Vehicle Model
Plant Plant Valuation Area
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
InvoiceRcptAmtInCoCodeCrcy InvoiceRcptAmtInCoCodeCrcy
CompanyCodeCurrency CompanyCodeCurrency Local Currency
LastChangedByUser LastChangedByUser User Name
GRIRClearingProcessStatus GRIRClearingProcessStatus Status
AuthorizationGroup AuthorizationGroup AuthorizGroup
SupplierInvoiceStatus SupplierInvoiceStatus Inv. status

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_ClrdInvcPurgDocWthoutGds.
-- 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.
-- SQL view name: CGRCCLINVPDWTHTG
-- Parameters: P_ComparisonDurationInDays : grcfc_duration_days

CREATE VIEW C_ClrdInvcPurgDocWthoutGds AS
SELECT
  CompanyCode,
  PurchasingDocument,
  PurchasingDocumentItem,
  SupplierInvoice,
  SupplierInvoiceItem,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingOrganization,
  CreationDate,
  InvoiceCreatedByUser,
  GrossAmount,
  CreatedByUser,
  PurchasingDocumentCreationDate,
  PurchasingGroup,
  PurchasingDocumentOrigin,
  DocumentCurrency,
  NumberOfGoodsReceipts,
  NumberOfInvoiceReceipts,
  Material,
  Plant,
  Supplier,
  SupplierName,
  InvoiceRcptAmtInCoCodeCrcy,
  CompanyCodeCurrency,
  LastChangedByUser,
  GRIRClearingProcessStatus,
  AuthorizationGroup,
  SupplierInvoiceStatus
FROM P_ClrdInvcPurgDocWthoutGds
;

Learn More