C_PrelimBillgDocItemObjPg

DDL: C_PRELIMBILLGDOCITEMOBJPG SQL: CPREBILLDOCITOP Type: view CONSUMPTION
23 Fields 1 Data Sources 2 Associations

Prebilling Item Object Page

C_PrelimBillgDocItemObjPg is a Consumption CDS View that provides data about "Prebilling Item Object Page" in SAP S/4HANA. It reads from 1 data source (I_PrelimBillingDocumentItem) and exposes 23 fields with key fields PrelimBillingDocument, PrelimBillingDocumentItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PrelimBillingDocumentItem Item from

Associations (2)

CardinalityTargetAliasCondition
[1] C_PrelimBillgDocObjPg _PrelimBillingDocument $projection.PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument
[1] E_BillingDocumentItem _Extension $projection.PrelimBillingDocument = _Extension.BillingDocument and $projection.PrelimBillingDocumentItem = _Extension.BillingDocumentItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPREBILLDOCITOP view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Prebilling Item Object Page view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.compositionRoot false view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PrelimBillingDocument I_PrelimBillingDocumentItem PrelimBillingDocument
KEY PrelimBillingDocumentItem I_PrelimBillingDocumentItem PrelimBillingDocumentItem
Material
BillingQuantity I_PrelimBillingDocumentItem BillingQuantity Invoiced Qty
BillingQuantityUnit I_PrelimBillingDocumentItem BillingQuantityUnit Sales Unit
NetAmount I_PrelimBillingDocumentItem NetAmount Stated Amount
TaxAmount I_PrelimBillingDocumentItem TaxAmount Tax Amt in Rptg Crcy
GrossAmount I_PrelimBillingDocumentItem GrossAmount Gross value
TransactionCurrency I_PrelimBillingDocumentItem TransactionCurrency Transaction Currency
BillingDocumentItemText I_PrelimBillingDocumentItem BillingDocumentItemText Item Descr.
ServiceDocumentType I_PrelimBillingDocumentItem ServiceDocumentType Transaction Type
ServiceDocument I_PrelimBillingDocumentItem ServiceDocument Transaction ID
ServiceDocumentItem I_PrelimBillingDocumentItem ServiceDocumentItem Service Document
BusinessSolutionOrder I_PrelimBillingDocumentItem BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem I_PrelimBillingDocumentItem BusinessSolutionOrderItem Solution Order Item
ProviderContract I_PrelimBillingDocumentItem ProviderContract Contract
ProviderContractItem I_PrelimBillingDocumentItem ProviderContractItem Contract Item
SalesOrganization I_PrelimBillingDocumentItem SalesOrganization Sales Organization
BillingDocumentType I_PrelimBillingDocumentItem BillingDocumentType Billing Type
_PrelimBillingDocument _PrelimBillingDocument
_ProviderContract _ProviderContract
_ProviderContractItem _ProviderContractItem
_MaterialText _MaterialText

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_PrelimBillgDocItemObjPg.
-- 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: CPREBILLDOCITOP

CREATE VIEW C_PrelimBillgDocItemObjPg AS
SELECT
  Item.PrelimBillingDocument AS PrelimBillingDocument,
  Item.PrelimBillingDocumentItem AS PrelimBillingDocumentItem,
  cast (Item.Material as productnumber preserving type) AS Material,
  Item.BillingQuantity AS BillingQuantity,
  Item.BillingQuantityUnit AS BillingQuantityUnit,
  Item.NetAmount AS NetAmount,
  Item.TaxAmount AS TaxAmount,
  Item.GrossAmount AS GrossAmount,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.BillingDocumentItemText AS BillingDocumentItemText,
  Item.ServiceDocumentType AS ServiceDocumentType,
  Item.ServiceDocument AS ServiceDocument,
  Item.ServiceDocumentItem AS ServiceDocumentItem,
  Item.BusinessSolutionOrder AS BusinessSolutionOrder,
  Item.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  Item.ProviderContract AS ProviderContract,
  Item.ProviderContractItem AS ProviderContractItem,
  Item.SalesOrganization AS SalesOrganization,
  Item.BillingDocumentType AS BillingDocumentType
FROM I_PrelimBillingDocumentItem AS Item
LEFT OUTER JOIN C_PrelimBillgDocObjPg AS _PrelimBillingDocument ON PrelimBillingDocument = _PrelimBillingDocument.PrelimBillingDocument  -- association [1]
LEFT OUTER JOIN E_BillingDocumentItem AS _Extension ON PrelimBillingDocument = _Extension.BillingDocument AND PrelimBillingDocumentItem = _Extension.BillingDocumentItem  -- association [1]
;

Learn More