C_InvcBfrPurgDocument

DDL: C_INVCBFRPURGDOCUMENT SQL: CGRCINVBFRPURGDC Type: view CONSUMPTION
30 Fields 1 Data Sources 9 Associations

Invoices created before PO

C_InvcBfrPurgDocument is a Consumption CDS View that provides data about "Invoices created before PO" in SAP S/4HANA. It reads from 1 data source (I_SupplierInvoiceItemPurOrdRef) and exposes 30 fields with key fields SupplierInvoice, FiscalYear, SupplierInvoiceItem. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SupplierInvoiceItemPurOrdRef I_SupplierInvoiceItemPurOrdRef from

Associations (9)

CardinalityTargetAliasCondition
[1..1] I_SupplierInvoice _SupplierInvoice $projection.SupplierInvoice = _SupplierInvoice.SupplierInvoice and $projection.FiscalYear = _SupplierInvoice.FiscalYear
[1..1] I_PurchasingDocument _PurchasingDocument $projection.PurchaseOrder = _PurchasingDocument.PurchasingDocument
[1..1] I_PurchasingDocumentCategory _PurchasingDocumentCategory $projection.purchasingdocumentcategory = _PurchasingDocumentCategory.PurchasingDocumentCategory
[0..1] I_PurchasingDocumentType _PurchasingDocumentType $projection.purchasingdocumentcategory = _PurchasingDocumentType.PurchasingDocumentCategory and $projection.purchasingdocumenttype = _PurchasingDocumentType.PurchasingDocumentType
[0..1] I_PurchasingOrganization _PurchasingOrganization $projection.purchasingorganization = _PurchasingOrganization.PurchasingOrganization
[0..1] I_Currency _DocumentCurrency $projection.documentcurrency = _DocumentCurrency.Currency
[0..1] I_PurchasingGroup _PurchasingGroup $projection.purchasinggroup = _PurchasingGroup.PurchasingGroup
[0..1] I_PurchasingDocumentOrigin _PurchasingDocumentOrigin $projection.purchasingdocumentorigin = _PurchasingDocumentOrigin.PurchasingDocumentOrigin
[0..1] I_CompanyCode _CompanyCode $projection.companycode = _CompanyCode.CompanyCode

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CGRCINVBFRPURGDC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Invoices created before PO 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 #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY SupplierInvoice SupplierInvoice
KEY FiscalYear FiscalYear G/L Fiscal Year
KEY SupplierInvoiceItem SupplierInvoiceItem
InvoiceCreationDate _SupplierInvoice CreationDate Time Stamp
SupplierInvoiceItemAmount SupplierInvoiceItemAmount Amount
PurchaseOrder PurchaseOrder Purchasing Document
PurchasingDocumentCategory _PurchasingDocument PurchasingDocumentCategory Doc. Category
PurchasingDocumentType _PurchasingDocument PurchasingDocumentType RFQ Type
PurchasingDocumentCreationDate _PurchasingDocument CreationDate Time Stamp
PurchasingOrganization _PurchasingDocument PurchasingOrganization Purchasing Organization
CreatedByUser _PurchasingDocument CreatedByUser User Name
DocumentCurrency _PurchasingDocument DocumentCurrency Document Currency
PurchasingGroup _PurchasingDocument PurchasingGroup Purchasing Group
PurchasingDocumentOrigin _PurchasingDocument PurchasingDocumentOrigin Status
GrossAmount
CompanyCode _PurchasingDocument CompanyCode Receiver Company Code
Supplier _PurchasingDocument Supplier Supplier
SupplierFullName
SupplierInvoiceItemText SupplierInvoiceItemText Text
_SupplierInvoice _SupplierInvoice
_PurchasingDocument _PurchasingDocument
_FiscalYear _FiscalYear
_CompanyCode _CompanyCode
_PurchasingDocumentCategory _PurchasingDocumentCategory
_PurchasingDocumentType _PurchasingDocumentType
_PurchasingDocumentOrigin _PurchasingDocumentOrigin
_PurchasingGroup _PurchasingGroup
_DocumentCurrency _DocumentCurrency
_PurchasingOrganization _PurchasingOrganization
_Supplier _PurchasingDocument _Supplier

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_InvcBfrPurgDocument.
-- 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: CGRCINVBFRPURGDC

CREATE VIEW C_InvcBfrPurgDocument AS
SELECT
  SupplierInvoice,
  FiscalYear,
  SupplierInvoiceItem,
  _SupplierInvoice.CreationDate AS InvoiceCreationDate,
  SupplierInvoiceItemAmount,
  PurchaseOrder,
  _PurchasingDocument.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  _PurchasingDocument.CreationDate AS PurchasingDocumentCreationDate,
  _PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingDocument.CreatedByUser AS CreatedByUser,
  _PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  _PurchasingDocument.PurchasingDocumentOrigin AS PurchasingDocumentOrigin,
  sum (_PurchasingDocument._PurchasingDocumentItem.GrossAmount) AS GrossAmount,
  _PurchasingDocument.CompanyCode AS CompanyCode,
  _PurchasingDocument.Supplier AS Supplier,
  _PurchasingDocument._Supplier.SupplierFullName AS SupplierFullName,
  SupplierInvoiceItemText,
  _PurchasingDocument._Supplier AS _Supplier
FROM I_SupplierInvoiceItemPurOrdRef
LEFT OUTER JOIN I_SupplierInvoice AS _SupplierInvoice ON SupplierInvoice = _SupplierInvoice.SupplierInvoice AND FiscalYear = _SupplierInvoice.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON PurchaseOrder = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON purchasingdocumentcategory = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON purchasingdocumentcategory = _PurchasingDocumentType.PurchasingDocumentCategory AND purchasingdocumenttype = _PurchasingDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON purchasingorganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON documentcurrency = _DocumentCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON purchasinggroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentOrigin AS _PurchasingDocumentOrigin ON purchasingdocumentorigin = _PurchasingDocumentOrigin.PurchasingDocumentOrigin  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON companycode = _CompanyCode.CompanyCode  -- association [0..1]
;

Learn More