C_BillgDocReqWorklist

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_BillgDocReqWorklist.
-- 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: CSDBDRWL

CREATE VIEW C_BillgDocReqWorklist AS
SELECT
  I_BillingDocumentRequest.BillingDocumentRequest AS BillingDocumentRequest,
  I_BillingDocumentRequest.BillingDocumentRequest AS ReferenceSDDocument,
  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,
  _SoldToParty.OrganizationBPName1 AS SoldToPartyName,
  _SoldToParty.OrganizationBPName2 AS SoldToPartyAdditionalName,
  I_BillingDocumentRequest.PricingDocument AS SalesDocumentCondition,
  I_BillingDocumentRequest.OverallBillingDocReqStatus AS OverallBillingDocReqStatus,
  I_BillingDocumentRequest.PayerParty AS PayerParty,
  _PayerParty.OrganizationBPName1 AS PayerPartyName,
  _PayerParty.OrganizationBPName2 AS PayerPartyAdditionalName,
  I_BillingDocumentRequest.CompanyCode AS CompanyCode,
  I_BillingDocumentRequest.SalesOrganization AS SalesOrganization,
  I_BillingDocumentRequest.BillingDocumentDate AS BillingDocumentDate,
  I_BillingDocumentRequest.CreationDate AS CreationDate,
  I_BillingDocumentRequest.CreatedByUser AS CreatedByUser,
  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 BillgDocReqRefSDDocCategory,
  ProposedBillingDocumentType,
  I_BillingDocumentRequest.TotalTaxAmount AS TotalTaxAmount,
  (I_BillingDocumentRequest.TotalNetAmount + I_BillingDocumentRequest.TotalTaxAmount) AS TotalGrossAmount,
  I_BillingDocumentRequest.TotalNetAmount AS TotalNetAmount,
  I_BillingDocumentRequest.TransactionCurrency AS TransactionCurrency,
  _CustomerProjectItem.CustomerProject AS CustomerProject,
  SDDocumentCategory,
  I_BillingDocumentRequest.CustomerPaymentTerms AS CustomerPaymentTerms,
  I_BillingDocumentRequest.IncotermsVersion AS IncotermsVersion,
  I_BillingDocumentRequest.IncotermsClassification AS IncotermsClassification,
  I_BillingDocumentRequest.IncotermsLocation1 AS IncotermsLocation1,
  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._BillingIssueType AS _BillingIssueType,
  I_BillingDocumentRequest._OvrlBillingDocReqStatus AS _OvrlBillingDocReqStatus,
  I_BillingDocumentRequest._ProposedBillingDocumentType AS _ProposedBillingDocumentType,
  I_BillingDocumentRequest._TransactionCurrency AS _TransactionCurrency
FROM I_BillingDocumentRequest
LEFT OUTER JOIN I_CustomerProjectItem AS _CustomerProjectItem ON _CustomerProjectItem.CustomerProjectItemType = '0SOH' AND _CustomerProjectItem.CustomerProjectItem = PBDRSO.SalesOrder  -- association [0..1]
LEFT OUTER JOIN C_CustomerProjectVH AS _CustomerProject ON customerproject = _CustomerProject.CustomerProject  -- association [0..1]
LEFT OUTER JOIN C_BillingDocReqItemObjPg AS _Item ON BillingDocumentRequest = _Item.BillingDocumentRequest  -- association [0..*]
LEFT OUTER JOIN C_SoldToValueHelp AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_SoldToValueHelp AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [0..1]
LEFT OUTER JOIN C_BillingDocumentUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON BillingDocumentRequest = _Extension.BillingDocument  -- association [0..1]
;