What is C_PrelimBillgDocObjPg in SAP S/4HANA?

C_PrelimBillgDocObjPg is a consumption CDS view in SAP S/4HANA. Prebilling Object Page It contains 49 fields.

Which tables does C_PrelimBillgDocObjPg read from?

C_PrelimBillgDocObjPg reads data from: I_PrelimBillingDocument.

What VDM layer is C_PrelimBillgDocObjPg?

C_PrelimBillgDocObjPg is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PrelimBillgDocObjPg

DDL: C_PRELIMBILLGDOCOBJPG SQL: CPREBILLDOCOP Type: view CONSUMPTION

49 Fields 1 Data Sources 5 Associations

Prebilling Object Page

C_PrelimBillgDocObjPg is a Consumption CDS View that provides data about "Prebilling Object Page" in SAP S/4HANA. It reads from 1 data source (I_PrelimBillingDocument) and exposes 49 fields with key field PrelimBillingDocument. It has 5 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_PrelimBillingDocument	PrelimBillDoc	from

Associations (5)

Cardinality	Target	Alias	Condition
[0..*]	C_PrelimBillgDocItemObjPg	_Item	`$projection.PrelimBillingDocument = _Item.PrelimBillingDocument`
[0..*]	C_SDDocumentPartnerCard	_SDDocumentPartnerCard	`$projection.PrelimBillingDocument = _SDDocumentPartnerCard.SDDocument and _SDDocumentPartnerCard.SDDocumentItem = '000000'`
[0..1]	I_PrelimBillingDocPartner	_BillToDocPartner	`$projection.PrelimBillingDocument = _BillToDocPartner.PrelimBillingDocument and _BillToDocPartner.PartnerFunction = 'RE'`
[0..1]	I_Customer	_BillToParty	`$projection.BillToParty = _BillToParty.Customer`
[0..1]	E_BillingDocument	_Extension	`$projection.PrelimBillingDocument = _Extension.BillingDocument`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	CPREBILLDOCOP	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ClientHandling.type	#CLIENT_DEPENDENT	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Prebilling Object Page	view
VDM.viewType	#CONSUMPTION	view
Metadata.allowExtensions	true	view
ObjectModel.representativeKey	PrelimBillingDocument	view
ObjectModel.compositionRoot	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.usageType.dataClass	#MIXED	view

Fields (49)

Key	Field	Source Table	Source Field	Description
KEY	PrelimBillingDocument	I_PrelimBillingDocument	PrelimBillingDocument
	PayerParty	I_PrelimBillingDocument	PayerParty	Payer
	PrelimBillingDocumentStatus	I_PrelimBillingDocument	PrelimBillingDocumentStatus
	BillgProcDocApprovalStatus	I_PrelimBillingDocument	BillgProcDocApprovalStatus
	UICT_PrelimBillgDocApprovalRsn
	PrelimBillgDocApprovalReason	I_PrelimBillingDocument	PrelimBillgDocApprovalReason
	SDApprovalReasonName
	TotalGrossAmount
	BillToParty
	SoldToParty	I_PrelimBillingDocument	SoldToParty	Sold-to Party
	CompanyCode	I_PrelimBillingDocument	CompanyCode	Receiver Company Code
	SalesOrganization	I_PrelimBillingDocument	SalesOrganization	Sales Organization
	DistributionChannel	I_PrelimBillingDocument	DistributionChannel	RefDistCh-Cust/Mat.
	DistributionChannelName
	Division	I_PrelimBillingDocument	Division	Internal Division ID
	DivisionName
	BillingDocumentType	I_PrelimBillingDocument	BillingDocumentType	Billing Type
	BillingDocumentDate	I_PrelimBillingDocument	BillingDocumentDate	Billing Date
	CustomerPaymentTerms	I_PrelimBillingDocument	CustomerPaymentTerms	Pyt Terms
	IncotermsClassification	I_PrelimBillingDocument	IncotermsClassification	Incoterms
	IncotermsLocation1	I_PrelimBillingDocument	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	I_PrelimBillingDocument	IncotermsLocation2	Inco. Location2
	BillingIssueType	I_PrelimBillingDocument	BillingIssueType
	DocumentReferenceID		DocumentReferenceID	Reference
	TaxAmount	I_PrelimBillingDocument	TotalTaxAmount	Tax Amount
	TotalNetAmount	I_PrelimBillingDocument	TotalNetAmount	Total Net Amount
	TransactionCurrency	I_PrelimBillingDocument	TransactionCurrency	Transaction Currency
	BillingDocumentTypeName
	CreatedByUser	I_PrelimBillingDocument	CreatedByUser	User Name
	CreatedByUserName	_CreatedByUser	UserDescription	Full Name
	CreationDate	I_PrelimBillingDocument	CreationDate	Time Stamp
	CreationTime	I_PrelimBillingDocument	CreationTime	Time of Change
	_PayerParty	I_PrelimBillingDocument	_PayerParty
	_PrelimBillingDocumentStatus	I_PrelimBillingDocument	_PrelimBillingDocumentStatus
	_BillgProcDocApprovalStatus	I_PrelimBillingDocument	_BillgProcDocApprovalStatus
	_PrelimBillgDocApprovalReason	I_PrelimBillingDocument	_PrelimBillgDocApprovalReason
	_CompanyCode	I_PrelimBillingDocument	_CompanyCode
	_SalesOrganization	I_PrelimBillingDocument	_SalesOrganization
	_DistributionChannel	I_PrelimBillingDocument	_DistributionChannel
	_Division	I_PrelimBillingDocument	_Division
	_BillingDocumentType	I_PrelimBillingDocument	_BillingDocumentType
	_SoldToParty	I_PrelimBillingDocument	_SoldToParty
	_CustomerPaymentTerms	I_PrelimBillingDocument	_CustomerPaymentTerms
	_IncotermsClassification	I_PrelimBillingDocument	_IncotermsClassification
	_BillingIssueType	I_PrelimBillingDocument	_BillingIssueType
	_Item		_Item
	_SDDocumentPartnerCard		_SDDocumentPartnerCard
	_BillToParty		_BillToParty
	_BillToDocPartner		_BillToDocPartner

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_PrelimBillgDocObjPg.
-- 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: CPREBILLDOCOP

CREATE VIEW C_PrelimBillgDocObjPg AS
SELECT
  PrelimBillDoc.PrelimBillingDocument AS PrelimBillingDocument,
  PrelimBillDoc.PayerParty AS PayerParty,
  PrelimBillDoc.PrelimBillingDocumentStatus AS PrelimBillingDocumentStatus,
  PrelimBillDoc.BillgProcDocApprovalStatus AS BillgProcDocApprovalStatus,
  cast('' as boole_d preserving type ) AS UICT_PrelimBillgDocApprovalRsn,
  PrelimBillDoc.PrelimBillgDocApprovalReason AS PrelimBillgDocApprovalReason,
  _PrelimBillgDocApprovalReason._SDApprovalReasonT[1: Language = $session.system_language ].SDApprovalReasonName AS SDApprovalReasonName,
  PrelimBillDoc._EnhancedFields.TotalGrossAmount AS TotalGrossAmount,
  cast( _BillToDocPartner.Customer as kunre preserving type ) AS BillToParty,
  PrelimBillDoc.SoldToParty AS SoldToParty,
  PrelimBillDoc.CompanyCode AS CompanyCode,
  PrelimBillDoc.SalesOrganization AS SalesOrganization,
  PrelimBillDoc.DistributionChannel AS DistributionChannel,
  _DistributionChannel._Text[1: Language = $session.system_language ].DistributionChannelName AS DistributionChannelName,
  PrelimBillDoc.Division AS Division,
  _Division._Text[1: Language = $session.system_language ].DivisionName AS DivisionName,
  PrelimBillDoc.BillingDocumentType AS BillingDocumentType,
  PrelimBillDoc.BillingDocumentDate AS BillingDocumentDate,
  PrelimBillDoc.CustomerPaymentTerms AS CustomerPaymentTerms,
  PrelimBillDoc.IncotermsClassification AS IncotermsClassification,
  PrelimBillDoc.IncotermsLocation1 AS IncotermsLocation1,
  PrelimBillDoc.IncotermsLocation2 AS IncotermsLocation2,
  PrelimBillDoc.BillingIssueType AS BillingIssueType,
  DocumentReferenceID,
  PrelimBillDoc.TotalTaxAmount AS TaxAmount,
  PrelimBillDoc.TotalNetAmount AS TotalNetAmount,
  PrelimBillDoc.TransactionCurrency AS TransactionCurrency,
  PrelimBillDoc._BillingDocumentType._Text[1: Language = $session.system_language ].BillingDocumentTypeName AS BillingDocumentTypeName,
  PrelimBillDoc.CreatedByUser AS CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  PrelimBillDoc.CreationDate AS CreationDate,
  PrelimBillDoc.CreationTime AS CreationTime,
  PrelimBillDoc._PayerParty AS _PayerParty,
  PrelimBillDoc._PrelimBillingDocumentStatus AS _PrelimBillingDocumentStatus,
  PrelimBillDoc._BillgProcDocApprovalStatus AS _BillgProcDocApprovalStatus,
  PrelimBillDoc._PrelimBillgDocApprovalReason AS _PrelimBillgDocApprovalReason,
  PrelimBillDoc._CompanyCode AS _CompanyCode,
  PrelimBillDoc._SalesOrganization AS _SalesOrganization,
  PrelimBillDoc._DistributionChannel AS _DistributionChannel,
  PrelimBillDoc._Division AS _Division,
  PrelimBillDoc._BillingDocumentType AS _BillingDocumentType,
  PrelimBillDoc._SoldToParty AS _SoldToParty,
  PrelimBillDoc._CustomerPaymentTerms AS _CustomerPaymentTerms,
  PrelimBillDoc._IncotermsClassification AS _IncotermsClassification,
  PrelimBillDoc._BillingIssueType AS _BillingIssueType
FROM I_PrelimBillingDocument AS PrelimBillDoc
LEFT OUTER JOIN C_PrelimBillgDocItemObjPg AS _Item ON PrelimBillingDocument = _Item.PrelimBillingDocument  -- association [0..*]
LEFT OUTER JOIN C_SDDocumentPartnerCard AS _SDDocumentPartnerCard ON PrelimBillingDocument = _SDDocumentPartnerCard.SDDocument AND _SDDocumentPartnerCard.SDDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN I_PrelimBillingDocPartner AS _BillToDocPartner ON PrelimBillingDocument = _BillToDocPartner.PrelimBillingDocument AND _BillToDocPartner.PartnerFunction = 'RE'  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON PrelimBillingDocument = _Extension.BillingDocument  -- association [0..1]
;

Depth:

C_PrelimBillgDocObjPg view

I_PrelimBillingDocument view