R_SetldSuplrInvcItmAnlyts

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_SetldSuplrInvcItmAnlyts.
-- 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_SetldSuplrInvcItmAnlyts AS
SELECT
  ConditionContract,
  SettlmtDoc,
  SettlmtDocItem,
  SettledSuplrInvc,
  SettledSuplrInvcFiscalYear,
  SettledSuplrInvcItem,
  SettledSuplrInvcUUID,
  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,
  PayeeParty,
  PayerParty,
  AlternativeInvoicingParty,
  SettlmtCompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  SalesOrganization,
  DistributionChannel,
  Division,
  SettlmtDocType,
  DocumentDate,
  PostingDate,
  SettlmtDocCurrency,
  SettlmtDate,
  SettlmtMgmtAcctgTransfSts,
  SettlmtProcessType,
  PostingPartnerCat,
  SettlmtProduct,
  SettlmtDocItemText,
  SettlmtControllingArea,
  SettlmtCreationDate,
  SettlmtCostCenter,
  SettlmtProfitCenter,
  BusVolDocCurrency,
  BusVolDocExchangeRateDate,
  BusVolDocItmProduct,
  cast( BusVolDocItmText as wlf_bv_doc_itm_text preserving type ) AS BusVolDocItmText,
  BusVolDocItmProductGroup,
  BusVolDocItmPlant,
  BusVolDocItmQuantityUnit,
  BaseUnit,
  QuantityNumerator AS BusVolDocItmToBsQtyNmrtr,
  cast( QuantityDenominator as umwfz preserving type ) AS BusVolDocItmToBsQtyDnmntr,
  _SettlmtDoc.CndnContrProcessCategory AS CndnContrProcessCategory,
  PersonWorkAgreement,
  CndnContrCompanyCode,
  CndnContrWorkerCostCenter,
  CustSettlmtCompanyCode,
  SettlmtDocAuthznCat
FROM R_SettledSuplrInvcItemBasic
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_SupplierInvoice AS _SettledSuplrInvc ON SettledSuplrInvc = _SettledSuplrInvc.SupplierInvoice AND SettledSuplrInvcFiscalYear = _SettledSuplrInvc.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_SupplierInvoiceItemPurOrdRef AS _SettledSuplrInvcItem ON SettledSuplrInvc = _SettledSuplrInvcItem.SupplierInvoice AND SettledSuplrInvcFiscalYear = _SettledSuplrInvcItem.FiscalYear AND SettledSuplrInvcItem = _SettledSuplrInvcItem.SupplierInvoiceItem  -- 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_Supplier AS _PayeeParty ON PayeeParty = _PayeeParty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _BillToParty ON BillToParty = _BillToParty.Customer  -- 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]
;