C_BillingDocRequestObjPg

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_BillingDocRequestObjPg.
-- 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: CSDBDRFS

CREATE VIEW C_BillingDocRequestObjPg AS
SELECT
  cast ( I_BillingDocumentRequest.BillingDocumentRequest as sdbil_odata_bdr preserving type ) AS BillingDocumentRequest,
  cast ( I_BillingDocumentRequest.BillingDocumentRequestType as sdbil_odata_bdr_type preserving type ) AS BillingDocumentRequestType,
  I_BillingDocumentRequest._BillingDocumentRequestType._Text[1: Language = $session.system_language ].BillingDocumentTypeName AS BillingDocumentTypeName,
  I_BillingDocumentRequest.SoldToParty AS SoldToParty,
  I_BillingDocumentRequest.PricingDocument AS SalesDocumentCondition,
  I_BillingDocumentRequest.OverallBillingDocReqStatus AS OverallBillingDocReqStatus,
  I_BillingDocumentRequest.CompanyCode AS CompanyCode,
  I_BillingDocumentRequest.SalesOrganization AS SalesOrganization,
  I_BillingDocumentRequest.BillingDocumentDate AS BillingDocumentDate,
  I_BillingDocumentRequest.BillingIssueType AS BillingIssueType,
  cast ( I_BillingDocumentRequest.ReferenceDocumentLogicalSystem as sdbil_odata_source_system preserving type ) AS BillgDocReqRefLgclSyst,
  cast ( I_BillingDocumentRequest.ReferenceDocument as sdbil_odata_source_document preserving type ) AS BillingDocRequestReference,
  cast ( I_BillingDocumentRequest.ReferenceDocSDDocCategory as sdbil_odata_src_doc_cat preserving type ) AS ReferenceDocSDDocCategory,
  ProposedBillingDocumentType,
  I_BillingDocumentRequest.TotalTaxAmount AS TotalTaxAmount,
  (I_BillingDocumentRequest.TotalNetAmount + I_BillingDocumentRequest.TotalTaxAmount) AS TotalGrossAmount,
  I_BillingDocumentRequest.TotalNetAmount AS TotalNetAmount,
  I_BillingDocumentRequest.TransactionCurrency AS TransactionCurrency,
  SDDocumentCategory,
  I_BillingDocumentRequest.CustomerPaymentTerms AS CustomerPaymentTerms,
  I_BillingDocumentRequest.IncotermsVersion AS IncotermsVersion,
  I_BillingDocumentRequest.IncotermsClassification AS IncotermsClassification,
  I_BillingDocumentRequest.IncotermsLocation1 AS IncotermsLocation1,
  I_BillingDocumentRequest.IncotermsLocation2 AS IncotermsLocation2,
  I_BillingDocumentRequest.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  I_BillingDocumentRequest.DunningArea AS DunningArea,
  I_BillingDocumentRequest.DunningBlockingReason AS DunningBlockingReason,
  I_BillingDocumentRequest.DunningKey AS DunningKey,
  I_BillingDocumentRequest.Country AS Country,
  I_BillingDocumentRequest.CustomerTaxClassification1 AS CustomerTaxClassification1,
  I_BillingDocumentRequest.VATRegistration AS VATRegistration,
  I_BillingDocumentRequest._CompanyCode AS _CompanyCode,
  I_BillingDocumentRequest._SalesOrganization AS _SalesOrganization,
  I_BillingDocumentRequest._SDDocumentCategory AS _SDDocumentCategory,
  I_BillingDocumentRequest._ReferenceDocSDDocCategory AS _ReferenceDocSDDocCategory,
  I_BillingDocumentRequest._CustomerPaymentTerms AS _CustomerPaymentTerms,
  I_BillingDocumentRequest._IncotermsClassification AS _IncotermsClassification,
  I_BillingDocumentRequest._IncotermsVersion AS _IncotermsVersion,
  I_BillingDocumentRequest._BillingDocumentRequestType AS _BillingDocumentRequestType,
  I_BillingDocumentRequest._SoldToParty AS _SoldToParty,
  I_BillingDocumentRequest._BillingIssueType AS _BillingIssueType,
  I_BillingDocumentRequest._OvrlBillingDocReqStatus AS _OvrlBillingDocReqStatus,
  I_BillingDocumentRequest._ProposedBillingDocumentType AS _ProposedBillingDocumentType,
  I_BillingDocumentRequest._TransactionCurrency AS _TransactionCurrency,
  I_BillingDocumentRequest._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup,
  I_BillingDocumentRequest._DunningBlockingReason AS _DunningBlockingReason,
  I_BillingDocumentRequest._DunningKey AS _DunningKey,
  I_BillingDocumentRequest._Country AS _Country
FROM I_BillingDocumentRequest
LEFT OUTER JOIN C_BillingDocReqItemObjPg AS _Item ON BillingDocumentRequest = _Item.BillingDocumentRequest  -- association [0..*]
LEFT OUTER JOIN C_PricingElement AS _PricingElement ON SalesDocumentCondition = _PricingElement.PricingDocument  -- association [0..*]
LEFT OUTER JOIN C_SDDocumentPartnerCard AS _Partner ON BillingDocumentRequest = _Partner.SDDocument AND _Partner.SDDocumentItem = '000000'  -- association [0..*]
LEFT OUTER JOIN I_DunningAreaText AS _DunningAreaText ON DunningArea = _DunningAreaText.DunningArea AND CompanyCode = _DunningAreaText.CompanyCode  -- association [0..*]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON BillingDocumentRequest = _Extension.BillingDocument  -- association [0..1]
;