C_BillgDocToBePostedSituation

DDL: C_BILLGDOCTOBEPOSTEDSITUATION Type: view_entity CONSUMPTION
22 Fields 1 Data Sources 5 Associations

Billing Doc To Be Posted for Situation

C_BillgDocToBePostedSituation is a Consumption CDS View that provides data about "Billing Doc To Be Posted for Situation" in SAP S/4HANA. It reads from 1 data source (I_BillingDocument) and exposes 22 fields with key field BillingDocument. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocument BillingDocument from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_BillingDocumentPartner _BillingDocumentPartner $projection.BillingDocument = _BillingDocumentPartner.BillingDocument and _BillingDocumentPartner.PartnerFunction = 'RE'
[0..1] I_BillingIssueTypeText _BillingIssueTypeText $projection.BillingIssueType = _BillingIssueTypeText.BillingIssueType and _BillingIssueTypeText.Language = $session.system_language
[0..1] I_BillingDocumentTypeText _BillingDocumentTypeText $projection.BillingDocumentType = _BillingDocumentTypeText.BillingDocumentType and _BillingDocumentTypeText.Language = $session.system_language
[0..1] I_SDDocumentCategoryText _SDDocumentCategoryText $projection.SDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory and _SDDocumentCategoryText.Language = $session.system_language
[0..1] I_SalesOrganizationText _SalesOrganizationText $projection.SalesOrganization = _SalesOrganizationText.SalesOrganization and _SalesOrganizationText.Language = $session.system_language

Annotations (9)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Billing Doc To Be Posted for Situation view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocument BillingDocument SD Document
BillingDocumentType I_BillingDocument BillingDocumentType Billing Type
BillingDocumentTypeName _BillingDocumentTypeText BillingDocumentTypeName
SDDocumentCategory I_BillingDocument SDDocumentCategory Document Cat.
SDDocumentCategoryName _SDDocumentCategoryText SDDocumentCategoryName
PayerParty I_BillingDocument PayerParty Payer
SoldToParty I_BillingDocument SoldToParty Sold-to Party
BillToParty _BillingDocumentPartner Customer Sold-to Party
TotalNetAmount I_BillingDocument TotalNetAmount Total Net Amount
TransactionCurrency I_BillingDocument TransactionCurrency Transaction Currency
SalesOrganization I_BillingDocument SalesOrganization Sales Organization
SalesOrganizationName _SalesOrganizationText SalesOrganizationName Sales Organization Description
BillingDocumentDate I_BillingDocument BillingDocumentDate Billing Date
BillingIssueType I_BillingDocument BillingIssueType
BillingIssueTypeName _BillingIssueTypeText BillingIssueTypeName
CompanyCode I_BillingDocument CompanyCode Receiver Company Code
CreatedByUser I_BillingDocument CreatedByUser User Name
_TransactionCurrency I_BillingDocument _TransactionCurrency
_BillingDocumentPartner _BillingDocumentPartner
_BillingIssueTypeText _BillingIssueTypeText
_BillingDocumentTypeText _BillingDocumentTypeText
_SDDocumentCategoryText _SDDocumentCategoryText

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_BillgDocToBePostedSituation.
-- 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_BillgDocToBePostedSituation AS
SELECT
  BillingDocument.BillingDocument AS BillingDocument,
  BillingDocument.BillingDocumentType AS BillingDocumentType,
  _BillingDocumentTypeText.BillingDocumentTypeName AS BillingDocumentTypeName,
  BillingDocument.SDDocumentCategory AS SDDocumentCategory,
  _SDDocumentCategoryText.SDDocumentCategoryName AS SDDocumentCategoryName,
  BillingDocument.PayerParty AS PayerParty,
  BillingDocument.SoldToParty AS SoldToParty,
  _BillingDocumentPartner.Customer AS BillToParty,
  BillingDocument.TotalNetAmount AS TotalNetAmount,
  BillingDocument.TransactionCurrency AS TransactionCurrency,
  BillingDocument.SalesOrganization AS SalesOrganization,
  _SalesOrganizationText.SalesOrganizationName AS SalesOrganizationName,
  BillingDocument.BillingDocumentDate AS BillingDocumentDate,
  BillingDocument.BillingIssueType AS BillingIssueType,
  _BillingIssueTypeText.BillingIssueTypeName AS BillingIssueTypeName,
  BillingDocument.CompanyCode AS CompanyCode,
  BillingDocument.CreatedByUser AS CreatedByUser,
  BillingDocument._TransactionCurrency AS _TransactionCurrency
FROM I_BillingDocument AS BillingDocument
LEFT OUTER JOIN I_BillingDocumentPartner AS _BillingDocumentPartner ON BillingDocument = _BillingDocumentPartner.BillingDocument AND _BillingDocumentPartner.PartnerFunction = 'RE'  -- association [0..1]
LEFT OUTER JOIN I_BillingIssueTypeText AS _BillingIssueTypeText ON BillingIssueType = _BillingIssueTypeText.BillingIssueType AND _BillingIssueTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentTypeText AS _BillingDocumentTypeText ON BillingDocumentType = _BillingDocumentTypeText.BillingDocumentType AND _BillingDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategoryText AS _SDDocumentCategoryText ON SDDocumentCategory = _SDDocumentCategoryText.SDDocumentCategory AND _SDDocumentCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrganizationText ON SalesOrganization = _SalesOrganizationText.SalesOrganization AND _SalesOrganizationText.Language = $session.system_language  -- association [0..1]
;

Learn More