R_SetldBillgDocItmAnlyts

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 R_SetldBillgDocItmAnlyts.
-- 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 R_SetldBillgDocItmAnlyts AS
SELECT
  ConditionContract,
  SettlmtDoc,
  SettlmtDocItem,
  SettledBillgDoc,
  SettledBillgDocItem,
  BusVolDocCat,
  BusVolSelDteForSettlmt,
  SettledBusVolQty,
  SettledBusVolQtyUnit,
  SettledBusVolAmount1,
  SettledBusVolAmount2,
  SettledBusVolAmount3,
  SettledBusVolAmount4,
  SettledBusVolGrossWeight,
  SettledBusVolNetWeight,
  SettledBusVolWeightUnit,
  SettledBusVolVolume,
  SettledBusVolVolumeUnit,
  SettledBusVolPointsQty,
  SettledBusVolPointsQtyUnit,
  CndnContrType,
  CndnContrSupplier,
  CndnContrCustomer,
  CndnContrPurgOrg,
  CndnContrPurgGroup,
  CndnContrSlsOrg,
  CndnContrDistrChnl,
  CndnContrDivn,
  CndnContrClassfctnType,
  CndnContrProcVar,
  CndnContrSettlmtType,
  InvoicingParty,
  BillToParty,
  SettlmtCompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SettlmtDocType,
  DocumentDate,
  PostingDate,
  SettlmtDocCurrency,
  SettlmtDate,
  SettlmtMgmtAcctgTransfSts,
  SettlmtProcessType,
  PostingPartnerCat,
  SettlmtProduct,
  SettlmtDocItemText,
  SettlmtControllingArea,
  SettlmtCreationDate,
  SettlmtCostCenter,
  SettlmtProfitCenter,
  BusVolDocCurrency,
  BusVolDocExchangeRateDate,
  BusVolDocItmProduct,
  BusVolDocItmText,
  BusVolDocItmProductGroup,
  BusVolDocItmPlant,
  BusVolDocItmQuantityUnit,
  BaseUnit,
  PayeeParty,
  PayerParty,
  AlternativeInvoicingParty,
  _SettlmtDoc.CndnContrProcessCategory AS CndnContrProcessCategory,
  PersonWorkAgreement,
  CndnContrCompanyCode,
  CndnContrWorkerCostCenter,
  CustSettlmtCompanyCode,
  SettlmtDocAuthznCat
FROM R_SettledBillgDocItemBasic
LEFT OUTER JOIN I_ConditionContract AS _ConditionContract ON ConditionContract = _ConditionContract.ConditionContract  -- association [1..1]
LEFT OUTER JOIN I_SettlmtDoc AS _SettlmtDoc ON SettlmtDoc = _SettlmtDoc.SettlmtDoc  -- association [1..1]
LEFT OUTER JOIN I_SettlmtDocItem AS _SettlmtDocItem ON SettlmtDoc = _SettlmtDocItem.SettlmtDoc AND SettlmtDocItem = _SettlmtDocItem.SettlmtDocItem  -- association [1..1]
LEFT OUTER JOIN I_BillingDocument AS _SettledBillgDoc ON SettledBillgDoc = _SettledBillgDoc.BillingDocument  -- association [1..1]
LEFT OUTER JOIN I_BillingDocumentItem AS _SettledBillgDocItem ON SettledBillgDoc = _SettledBillgDocItem.BillingDocument AND SettledBillgDocItem = _SettledBillgDocItem.BillingDocumentItem  -- association [1..1]
LEFT OUTER JOIN I_BusVolDocCat AS _BusVolDocCat ON BusVolDocCat = _BusVolDocCat.BusVolDocCat  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SettledBusVolQtyUnit ON SettledBusVolQtyUnit = _SettledBusVolQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SettledBusVolWeightUnit ON SettledBusVolWeightUnit = _SettledBusVolWeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SettledBusVolVolumeUnit ON SettledBusVolVolumeUnit = _SettledBusVolVolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _SettledBusVolPointsQtyUnit ON SettledBusVolPointsQtyUnit = _SettledBusVolPointsQtyUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _BusVolDocCurrency ON BusVolDocCurrency = _BusVolDocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CndnContrType AS _CndnContrType ON CndnContrType = _CndnContrType.CndnContrType  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _CndnContrSupplier ON CndnContrSupplier = _CndnContrSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _CndnContrCustomer ON CndnContrCustomer = _CndnContrCustomer.Customer  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _CndnContrPurgOrg ON CndnContrPurgOrg = _CndnContrPurgOrg.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _CndnContrPurgGroup ON CndnContrPurgGroup = _CndnContrPurgGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _CndnContrSlsOrg ON CndnContrSlsOrg = _CndnContrSlsOrg.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _CndnContrDistrChnl ON CndnContrDistrChnl = _CndnContrDistrChnl.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _CndnContrDivn ON CndnContrDivn = _CndnContrDivn.Division  -- association [0..1]
LEFT OUTER JOIN I_CndnContrClassfctnType AS _CndnContrClassfctnType ON CndnContrClassfctnType = _CndnContrClassfctnType.CndnContrClassfctnType  -- association [0..1]
LEFT OUTER JOIN I_CndnContrProcVar AS _CndnContrProcVar ON CndnContrProcVar = _CndnContrProcVar.CndnContrProcVar  -- association [0..1]
LEFT OUTER JOIN I_CndnContrSettlmtType AS _CndnContrSettlmtType ON CndnContrSettlmtType = _CndnContrSettlmtType.CndnContrSettlmtType  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _InvoicingParty ON InvoicingParty = _InvoicingParty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PayeeParty ON PayeeParty = _PayeeParty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _PayerParty ON PayerParty = _PayerParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _AlternativeInvoicingParty ON AlternativeInvoicingParty = _AlternativeInvoicingParty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _PersonWorkAgreement ON PersonWorkAgreement = _PersonWorkAgreement.PersonWorkAgreement  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _SettlmtCompanyCode ON SettlmtCompanyCode = _SettlmtCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON SalesOrganization = _SalesOrganization.SalesOrganization  -- 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_SettlmtDocType AS _SettlmtDocType ON SettlmtDocType = _SettlmtDocType.SettlmtDocType  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SettlmtDocCurrency ON SettlmtDocCurrency = _SettlmtDocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtAcctgTransfSts AS _SettlmtMgmtAcctgTransfSts ON SettlmtMgmtAcctgTransfSts = _SettlmtMgmtAcctgTransfSts.SettlmtMgmtAcctgTransfSts  -- association [0..1]
LEFT OUTER JOIN I_SettlmtProcessType AS _SettlmtProcessType ON SettlmtProcessType = _SettlmtProcessType.SettlmtProcessType  -- association [0..1]
LEFT OUTER JOIN I_PostingPartnerCat AS _PostingPartnerCat ON PostingPartnerCat = _PostingPartnerCat.PostingPartnerCat  -- association [0..1]
LEFT OUTER JOIN I_Product AS _SettlmtProduct ON SettlmtProduct = _SettlmtProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _BusVolDocItmProduct ON BusVolDocItmProduct = _BusVolDocItmProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _BusVolDocItmPlant ON BusVolDocItmPlant = _BusVolDocItmPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BusVolDocItmQuantityUnit ON BusVolDocItmQuantityUnit = _BusVolDocItmQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _SettlmtControllingArea ON SettlmtControllingArea = _SettlmtControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _SettlmtCostCenter ON SettlmtCostCenter = _SettlmtCostCenter.CostCenter AND SettlmtControllingArea = _SettlmtCostCenter.ControllingArea AND _SettlmtCostCenter.ValidityEndDate >= SettlmtCreationDate AND _SettlmtCostCenter.ValidityStartDate <= SettlmtCreationDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _SettlmtProfitCenter ON SettlmtProfitCenter = _SettlmtProfitCenter.ProfitCenter AND SettlmtControllingArea = _SettlmtProfitCenter.ControllingArea AND _SettlmtProfitCenter.ValidityEndDate >= SettlmtCreationDate AND _SettlmtProfitCenter.ValidityStartDate <= SettlmtCreationDate  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _InvoicingPartyCompany ON InvoicingParty = _InvoicingPartyCompany.Supplier AND SettlmtCompanyCode = _InvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _PayeePartyCompany ON PayeeParty = _PayeePartyCompany.Supplier AND SettlmtCompanyCode = _PayeePartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_SupplierCompany AS _AltvInvoicingPartyCompany ON AlternativeInvoicingParty = _AltvInvoicingPartyCompany.Supplier AND SettlmtCompanyCode = _AltvInvoicingPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _BillToPartyCompany ON BillToParty = _BillToPartyCompany.Customer AND SettlmtCompanyCode = _BillToPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CustomerCompany AS _PayerPartyCompany ON PayerParty = _PayerPartyCompany.Customer AND SettlmtCompanyCode = _PayerPartyCompany.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CndnContrProcessCategory AS _CndnContrProcessCategory ON cndncontrprocesscategory = _CndnContrProcessCategory.CndnContrProcessCategory  -- association [0..1]
;