R_SetldExpnSettlmtItmAnlyts

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_SetldExpnSettlmtItmAnlyts.
-- 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_SetldExpnSettlmtItmAnlyts AS
SELECT
  ConditionContract,
  SettlmtDoc,
  SettlmtDocItem,
  SettledExpnSettlmt,
  SettledExpnSettlmtItem,
  BusVolDocCat,
  BusVolSelDteForSettlmt,
  SettledBusVolQty,
  SettledBusVolQtyUnit,
  SettledBusVolAmount1,
  SettledBusVolAmount2,
  SettledBusVolAmount3,
  SettledBusVolAmount4,
  SettledBusVolGrossWeight,
  SettledBusVolNetWeight,
  SettledBusVolWeightUnit,
  SettledBusVolVolume,
  SettledBusVolVolumeUnit,
  SettledBusVolPointsQty,
  SettledBusVolPointsQtyUnit,
  CndnContrType,
  CndnContrSupplier,
  CndnContrCustomer,
  cast( CndnContrPurgOrg as wlf_cndn_contr_purg_org preserving type ) AS CndnContrPurgOrg,
  cast( CndnContrPurgGroup as wlf_cndn_contr_purg_group preserving type ) AS CndnContrPurgGroup,
  cast( CndnContrSlsOrg as wlf_cndn_contr_sls_org preserving type ) AS CndnContrSlsOrg,
  cast( CndnContrDistrChnl as wlf_cndn_contr_distr_chnl preserving type ) AS CndnContrDistrChnl,
  cast( CndnContrDivn as wlf_cndn_contr_divn preserving type ) AS CndnContrDivn,
  CndnContrClassfctnType,
  CndnContrProcVar,
  CndnContrSettlmtType,
  InvoicingParty,
  BillToParty,
  SettlmtCompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SettlmtDocType,
  DocumentDate,
  PostingDate,
  SettlmtDocCurrency,
  SettlmtDate,
  SettlmtMgmtAcctgTransfSts,
  SettlmtProcessType,
  PostingPartnerCat,
  cast( SettlmtProduct as wb2_settlement_product preserving type ) AS SettlmtProduct,
  SettlmtDocItemText,
  SettlmtControllingArea,
  SettlmtCreationDate,
  SettlmtCostCenter,
  SettlmtProfitCenter,
  BusVolDocCurrency,
  BusVolDocExchangeRateDate,
  BusVolDocItmProduct,
  cast( BusVolDocItmText as wlf_bv_doc_itm_text ) AS BusVolDocItmText,
  BusVolDocItmProductGroup,
  BusVolDocItmPlant,
  BusVolDocItmQuantityUnit,
  BaseUnit,
  SettlmtToBaseQuantityNmrtr AS BusVolDocItmToBsQtyNmrtr,
  SettlmtToBaseQuantityDnmntr AS BusVolDocItmToBsQtyDnmntr,
  PayeeParty,
  PayerParty,
  AlternativeInvoicingParty,
  _SettlmtDoc.CndnContrProcessCategory AS CndnContrProcessCategory,
  PersonWorkAgreement,
  CndnContrCompanyCode,
  CndnContrWorkerCostCenter,
  CustSettlmtCompanyCode,
  SettlmtDocAuthznCat
FROM R_SettledExpnSettlmtItmBasic
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_ExpnSettlmt AS _SettledExpnSettlmt ON SettledExpnSettlmt = _SettledExpnSettlmt.ExpnSettlmt  -- association [1..1]
LEFT OUTER JOIN I_ExpnSettlmtItem AS _SettledExpnSettlmtItem ON SettledExpnSettlmt = _SettledExpnSettlmtItem.ExpnSettlmt AND SettledExpnSettlmtItem = _SettledExpnSettlmtItem.ExpnSettlmtItem  -- 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_PersonWorkAgreement_1 AS _PersonWorkAgreement ON PersonWorkAgreement = _PersonWorkAgreement.PersonWorkAgreement  -- 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_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]
;