I_BillingDueListItem

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 I_BillingDueListItem.
-- 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 I_BillingDueListItem AS
SELECT
  fktyp AS BillingDocumentCategory,
  fkart AS BillingDocumentType,
  fkdat AS BillingDocumentDate,
  vkorg AS SalesOrganization,
  cast(kunnr as kunnr preserving type) AS Customer,
  lland AS DestinationCountry,
  vbeln AS ReferenceSDDocument,
  vbtyp AS ReferenceSDDocumentCategory,
  vbart AS ReferenceSDDocumentType,
  cast(adrnr as adrnr preserving type) AS AddressID,
  adrnp AS AddressPersonID,
  addr_type AS AddressObjectType,
  faksk AS HeaderBillingBlockReason,
  sortkri AS SortCriterion,
  vtweg AS DistributionChannel,
  spart AS Division,
  vstel AS ShippingPoint,
  pdstk AS OverallProofOfDeliveryStatus,
  netwr AS NetAmount,
  waerk AS TransactionCurrency,
  bdr_ref_logsys AS BillgDocReqRefLgclSyst,
  bdr_ref AS BillingDocRequestReference,
  solution_order_id AS BusinessSolutionOrder,
  ernam AS CreatedByUser,
  erdat AS CreationDate,
  erzet AS CreationTime
FROM vkdfs
LEFT OUTER JOIN I_BillingDocumentCategory AS _BillingDocumentCategory ON BillingDocumentCategory = _BillingDocumentCategory.BillingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_BillingDocumentType AS _BillingDocumentType ON BillingDocumentType = _BillingDocumentType.BillingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentCategory AS _ReferenceSDDocumentCategory ON ReferenceSDDocumentCategory = _ReferenceSDDocumentCategory.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SDDocumentType AS _ReferenceSDDocumentType ON ReferenceSDDocumentType = _ReferenceSDDocumentType.SDDocumentType AND ReferenceSDDocumentCategory = _ReferenceSDDocumentType.SDDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _DfltAddrRprstn ON AddressID = _DfltAddrRprstn.AddressID AND AddressPersonID = _DfltAddrRprstn.AddressPersonID AND _DfltAddrRprstn.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_Country AS _DestinationCountry ON DestinationCountry = _DestinationCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_BillingBlockReason AS _HeaderBillingBlockReason ON HeaderBillingBlockReason = _HeaderBillingBlockReason.BillingBlockReason  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistributionChannel ON DistributionChannel = _DistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Division ON Division = _Division.Division  -- association [0..1]
LEFT OUTER JOIN I_ShippingPoint AS _ShippingPoint ON ShippingPoint = _ShippingPoint.ShippingPoint  -- association [0..1]
LEFT OUTER JOIN I_OverallProofOfDelivStatus AS _OverallProofOfDelivStatus ON OverallProofOfDeliveryStatus = _OverallProofOfDelivStatus.OverallProofOfDeliveryStatus  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _TransactionCurrency ON TransactionCurrency = _TransactionCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentEnhcd AS _BusinessSolutionOrder ON BusinessSolutionOrder = _BusinessSolutionOrder.ServiceDocument AND _BusinessSolutionOrder.ServiceObjectType = 'BUS2000172'  -- association [0..1]
LEFT OUTER JOIN I_ShippingPointText AS _ShippingPointText ON ShippingPoint = _ShippingPointText.ShippingPoint  -- association [0..*]
;