C_BillingDocReqItemObjPg

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_BillingDocReqItemObjPg.
-- 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: CSDBDRITEMFS

CREATE VIEW C_BillingDocReqItemObjPg AS
SELECT
  cast ( I_BillingDocumentRequestItem.BillingDocumentRequest as sdbil_odata_bdr preserving type ) AS BillingDocumentRequest,
  cast(ltrim(I_BillingDocumentRequestItem.BillingDocumentRequestItem, '0') as odata_item_number ) AS BillingDocumentRequestItem,
  BillingQuantity,
  BillingQuantityUnit,
  cast (Material as productnumber preserving type) AS Material,
  SalesDocumentItemCategory,
  NetAmount,
  I_BillingDocumentRequestItem.TaxAmount AS TaxAmount,
  GrossAmount,
  I_BillingDocumentRequestItem.TransactionCurrency AS TransactionCurrency,
  cast( I_BillingDocumentRequestItem.ReferenceLogicalSystem as sdbil_odata_source_system preserving type ) AS SenderLogicalSystem,
  cast( I_BillingDocumentRequestItem.ReferenceDocument as sdbil_odata_source_document preserving type ) AS ReferenceSDDocument,
  cast( I_BillingDocumentRequestItem.ReferenceDocumentItem as sdbil_odata_src_doc_item preserving type ) AS ReferenceSDDocumentItem,
  cast( I_BillingDocumentRequestItem.ReferenceDocSDDocCategory as sdbil_odata_src_doc_cat preserving type ) AS ReferenceDocSDDocCategory,
  I_BillingDocumentRequestItem.Plant AS Plant,
  I_BillingDocumentRequestItem.OrganizationDivision AS OrganizationDivision,
  I_BillingDocumentRequestItem.StorageLocation AS StorageLocation,
  I_BillingDocumentRequestItem.PricingDate AS PricingDate,
  I_BillingDocumentRequestItem.StatisticalValueControl AS StatisticalValueControl,
  cast (I_BillingDocumentRequestItem.MaterialGroup as productgroup preserving type) AS MaterialGroup,
  I_BillingDocumentRequestItem.ServicesRenderedDate AS ServicesRenderedDate,
  I_BillingDocumentRequestItem.DepartureCountry AS DepartureCountry,
  I_BillingDocumentRequestItem.TaxJurisdiction AS TaxJurisdiction,
  I_BillingDocumentRequestItem.ProductTaxClassification1 AS ProductTaxClassification1,
  I_BillingDocumentRequestItem.BusinessArea AS BusinessArea,
  cast( I_BillingDocumentRequestItem.BillgDocReqBillgSts as bdr_status preserving type ) AS OrderRelatedBillingStatus,
  I_BillingDocumentRequestItem.BillgDocRequestItemInPartSgmt AS BillgDocRequestItemInPartSgmt,
  I_BillingDocumentRequestItem.BillingDocumentRequestItemText AS BillingDocumentRequestItemText,
  I_BillingDocumentRequestItem.ServiceDocumentType AS ServiceDocumentType,
  I_BillingDocumentRequestItem.ServiceDocument AS ServiceDocument,
  I_BillingDocumentRequestItem.ServiceDocumentItem AS ServiceDocumentItem,
  I_BillingDocumentRequestItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  I_BillingDocumentRequestItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  I_BillingDocumentRequestItem.ProviderContract AS ProviderContract,
  I_BillingDocumentRequestItem.ProviderContractItem AS ProviderContractItem,
  I_BillingDocumentRequestItem._BillingQuantityUnit AS _BillingQuantityUnit,
  I_BillingDocumentRequestItem._SalesDocumentItemCategory AS _SalesDocumentItemCategory,
  I_BillingDocumentRequestItem._TransactionCurrency AS _TransactionCurrency,
  I_BillingDocumentRequestItem._ReferenceDocSDDocCategory AS _ReferenceDocSDDocCategory,
  I_BillingDocumentRequestItem._Plant AS _Plant,
  I_BillingDocumentRequestItem._OrganizationDivision AS _OrganizationDivision,
  I_BillingDocumentRequestItem._StorageLocation AS _StorageLocation,
  I_BillingDocumentRequestItem._StatisticalValueControl AS _StatisticalValueControl,
  I_BillingDocumentRequestItem._DepartureCountry AS _DepartureCountry,
  I_BillingDocumentRequestItem._ServiceDocumentType AS _ServiceDocumentType,
  I_BillingDocumentRequestItem._MaterialGroup AS _MaterialGroup,
  I_BillingDocumentRequestItem._ProviderContract AS _ProviderContract,
  I_BillingDocumentRequestItem._ProviderContractItem AS _ProviderContractItem,
  _BillingDocumentRequest.SalesDocumentCondition AS SalesDocumentCondition
FROM I_BillingDocumentRequestItem
LEFT OUTER JOIN C_BillingDocRequestObjPg AS _BillingDocumentRequest ON BillingDocumentRequest = _BillingDocumentRequest.BillingDocumentRequest  -- association [1..1]
LEFT OUTER JOIN C_PricingElement AS _PricingElement ON salesdocumentcondition = _PricingElement.PricingDocument AND BillingDocumentRequestItem = _PricingElement.PricingDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_SDDocumentPartnerCard AS _SDDocumentPartnerCard ON BillingDocumentRequest = _SDDocumentPartnerCard.SDDocument AND BillgDocRequestItemInPartSgmt = _SDDocumentPartnerCard.SDDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_BillgDocReqBillgSts AS _OrderRelatedBillingStatus ON OrderRelatedBillingStatus = _OrderRelatedBillingStatus.BillgDocReqBillgSts  -- association [0..1]
LEFT OUTER JOIN E_BillingDocumentItem AS _Extension ON BillingDocumentRequest = _Extension.BillingDocument AND I_BillingDocumentRequestItem.BillingDocumentRequestItem = _Extension.BillingDocumentItem  -- association [1]
;