Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

C_Openbillingrequest

DDL: C_OPENBILLINGREQUEST SQL: COPENBILLINGREQ Type: view CONSUMPTION
22 Fields 2 Data Sources 3 Associations

Open Billing Request

C_Openbillingrequest is a Consumption CDS View that provides data about "Open Billing Request" in SAP S/4HANA. It reads from 2 data sources (I_BillingDueListItem, I_SalesDocument) and exposes 22 fields with key fields BillingDocumentCategory, BillingDocumentType, BillingDocumentDate, SalesOrganization, SoldToParty. It has 3 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_BillingDueListItem BillingDocument from
I_SalesDocument SalesDocument inner

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_EngagementProjectItem _Item $projection.SalesDocument = _Item.EngagementProjectItem and _Item.EngagementProjectItemType = '0SOH'
[0..1] I_Customer_VH _Customer $projection.SoldToParty = _Customer.Customer
[0..1] I_BillingDocumentType _BillingDocumentType $projection.BillingDocumentType = _BillingDocumentType.BillingDocumentType

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName COPENBILLINGREQ view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Open Billing Request view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #REQUIRED view
VDM.lifecycle.status #DEPRECATED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY BillingDocumentCategory I_BillingDueListItem BillingDocumentCategory BillingCategory
KEY BillingDocumentType I_BillingDueListItem BillingDocumentType Billing Type
KEY BillingDocumentDate I_BillingDueListItem BillingDocumentDate Billing Date
KEY SalesOrganization I_BillingDueListItem SalesOrganization Sales Organization
KEY SoldToParty I_BillingDueListItem Customer Customer
KEY DestinationCountry I_BillingDueListItem DestinationCountry Dest. Ctry/Reg
KEY ReferenceSDDocument I_BillingDueListItem ReferenceSDDocument Document Number
SalesDocument I_SalesDocument ReferenceSDDocument Reference Doc.
ReferenceSDDocumentCategory I_BillingDueListItem ReferenceSDDocumentCategory Prec.Doc.Categ.
NetAmount I_BillingDueListItem NetAmount Net Amount
TransactionCurrency I_BillingDueListItem TransactionCurrency Transaction Currency
CustomerName Customer Name
SalesDocumentType I_SalesDocument SalesDocumentType Sales Doc. Type
OrganizationDivision I_SalesDocument OrganizationDivision Org. Division
DistributionChannel I_SalesDocument DistributionChannel RefDistCh-Cust/Mat.
EngagementProjectUUID _Item EngagementProjectUUID Engmnt Project UUID
EngagementProject Project ID
EngagementProjectName Project Name
_Customer _Customer
_BillingDocumentType _BillingDocumentType
_Item _Item
_ReferenceSDDocumentCategory I_BillingDueListItem _ReferenceSDDocumentCategory

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_Openbillingrequest.
-- 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: COPENBILLINGREQ

CREATE VIEW C_Openbillingrequest AS
SELECT
  BillingDocument.BillingDocumentCategory AS BillingDocumentCategory,
  BillingDocument.BillingDocumentType AS BillingDocumentType,
  BillingDocument.BillingDocumentDate AS BillingDocumentDate,
  BillingDocument.SalesOrganization AS SalesOrganization,
  BillingDocument.Customer AS SoldToParty,
  BillingDocument.DestinationCountry AS DestinationCountry,
  BillingDocument.ReferenceSDDocument AS ReferenceSDDocument,
  SalesDocument.ReferenceSDDocument AS SalesDocument,
  BillingDocument.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  BillingDocument.NetAmount AS NetAmount,
  BillingDocument.TransactionCurrency AS TransactionCurrency,
  BillingDocument._Customer.CustomerName AS CustomerName,
  SalesDocument.SalesDocumentType AS SalesDocumentType,
  SalesDocument.OrganizationDivision AS OrganizationDivision,
  SalesDocument.DistributionChannel AS DistributionChannel,
  _Item.EngagementProjectUUID AS EngagementProjectUUID,
  _Item._EngagementProject.EngagementProject AS EngagementProject,
  _Item._EngagementProject.EngagementProjectName AS EngagementProjectName,
  BillingDocument._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory
FROM I_BillingDueListItem AS BillingDocument
INNER JOIN I_SalesDocument AS SalesDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EngagementProjectItem AS _Item ON SalesDocument = _Item.EngagementProjectItem AND _Item.EngagementProjectItemType = '0SOH'  -- association [0..*]
LEFT OUTER JOIN I_Customer_VH AS _Customer ON SoldToParty = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
;

Learn More