C_PrelimBillgDocWorklist

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_PrelimBillgDocWorklist.
-- 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_PrelimBillgDocWorklist AS
SELECT
  Document.PrelimBillingDocument AS PrelimBillingDocument,
  Document.BillingDocumentType AS BillingDocumentType,
  Document.SoldToParty AS SoldToParty,
  Document.PrelimBillingDocumentStatus AS PrelimBillingDocumentStatus,
  Document.BillgProcDocApprovalStatus AS BillgProcDocApprovalStatus,
  Document.BillingDocumentDate AS BillingDocumentDate,
  Document.TotalNetAmount AS TotalNetAmount,
  Document.CreationDate AS CreationDate,
  Document.CreatedByUser AS CreatedByUser,
  Document.LastChangeDate AS LastChangeDate,
  Document.PayerParty AS PayerParty,
  Document.TotalTaxAmount AS TaxAmount,
  Document._EnhancedFields.TotalGrossAmount AS TotalGrossAmount,
  Document.TransactionCurrency AS TransactionCurrency,
  Document.CompanyCode AS CompanyCode,
  Document.SalesOrganization AS SalesOrganization,
  Document.DocumentReferenceID AS DocumentReferenceID,
  Document.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  _SoldToParty.OrganizationBPName1 AS SoldToPartyName,
  _SoldToParty.OrganizationBPName2 AS SoldToPartyAdditionalName,
  _PayerParty.OrganizationBPName1 AS PayerPartyName,
  _PayerParty.OrganizationBPName2 AS PayerPartyAdditionalName,
  Document._BillingDocumentType._Text[1: Language = $session.system_language ].BillingDocumentTypeName AS BillingDocumentTypeName,
  Document.BillingIssueType AS BillingIssueType,
  Document._BillingDocumentType AS _BillingDocumentType,
  Document._PrelimBillingDocumentStatus AS _PrelimBillingDocumentStatus,
  Document._BillgProcDocApprovalStatus AS _BillgProcDocApprovalStatus,
  Document._PayerParty AS _PayerParty,
  Document._TransactionCurrency AS _TransactionCurrency,
  Document._CompanyCode AS _CompanyCode,
  Document._SalesOrganization AS _SalesOrganization,
  Document._BillingIssueType AS _BillingIssueType
FROM I_PrelimBillingDocument AS Document
LEFT OUTER JOIN C_PrelimBillgDocItemObjPg AS _Item ON PrelimBillingDocument = _Item.PrelimBillingDocument  -- association [0..*]
LEFT OUTER JOIN C_BillingDocumentUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN C_SoldToValueHelp AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN E_BillingDocument AS _Extension ON PrelimBillingDocument = _Extension.BillingDocument  -- association [0..1]
;