C_SuplrSettlmtItemOutputForm

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_SuplrSettlmtItemOutputForm.
-- 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_SuplrSettlmtItemOutputForm AS
SELECT
  SuplrSettlmt,
  SuplrSettlmtItem,
  SuplrSettlmtCurrency,
  PricingDocument AS SupplierPricingDocument,
  Product,
  ProductGroup,
  Plant,
  InventoryValuationType,
  PricingDate,
  TaxCode AS SupplierTaxCode,
  TaxCountry,
  TaxJurisdiction,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ProductPurchasePointsQtyUnit,
  ProductPurchasePointsQty,
  SuplrSettlmtItemGrossAmount AS SupplierItemGrossAmount,
  SuplrSettlmtItemNetAmount AS SupplierItemNetAmount,
  SuplrSettlmtItemTaxAmount AS SupplierItemTaxAmount,
  SuplrSettlmtSubtotal1Amount AS SupplierSubtotal1Amount,
  SuplrSettlmtSubtotal2Amount AS SupplierSubtotal2Amount,
  SuplrSettlmtSubtotal3Amount AS SupplierSubtotal3Amount,
  SuplrSettlmtSubtotal4Amount AS SupplierSubtotal4Amount,
  SuplrSettlmtSubtotal5Amount AS SupplierSubtotal5Amount,
  SuplrSettlmtSubtotal6Amount AS SupplierSubtotal6Amount,
  SuplrSettlmtRebateBasisAmount AS SupplierRebateBasisAmount,
  SuplrSettlmtEffctvItemAmount AS SupplierEffectiveItemAmount,
  SuplrItmEligibleAmtForCshDisc,
  NonDeductibleInputTaxAmount,
  SuplrSettlmtItmStstclPrpty AS SettlmtItmStatisticalPrpty,
  CashDiscountIsDeductible,
  CreatedByUser,
  CreationDate,
  CreationTime,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtSourceDocFiscalYear,
  SuplrSettlmtItmActivityReason AS SettlmtItemActivityReason,
  SuplrSettlmtItemText,
  SupplierProductID,
  PriorSupplier,
  BusinessArea AS SuplrSettlmtBusinessArea,
  ControllingArea AS SuplrSettlmtControllingArea,
  CostCenter AS SuplrSettlmtCostCenter,
  ProfitCenter AS SuplrSettlmtProfitCenter,
  WBSElementInternalID AS SuplrSettlmtWBSElmntInternalID,
  SupplierSettlementOrder AS SettlmtMgmtOrder,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  Batch,
  PrcDetnIsIncmplt,
  SettlmtPrecdgDoc,
  SettlmtPrecdgDocItem,
  SettlmtPrecdgDocCat,
  SettlmtPrecdgDocFiscalYear,
  SuplrSettlmtItmCat,
  SettlmtItemReltdCndnContr,
  SuplrSettlmtItemStatus,
  SuplrSettlmtItemReversed AS SuplrSettlmtItmCancld,
  ServicesRenderedDate,
  CompanyCode AS SuplrSettlmtCompanyCode,
  GLAccount,
  SettlementFiscalYear,
  HigherLevelItem,
  LowerLevelItemExists,
  ItemDistributionStatus,
  SettlmtRefDocType,
  SettlmtRefDoc,
  SettlmtRefDocFiscalYear,
  SettlmtRefDocLogicalSyst,
  SettlmtRefDocItem,
  SettlmtRefDocCat,
  ItemIntrastatRelevance,
  SettlmtAddlRefDocType,
  SettlmtAddlRefDoc,
  SettlmtAddlRefDocFiscalYear,
  SettlmtAddlRefDocLogicalSyst,
  SettlmtAddlRefDocItem,
  SettlmtAddlRefDocCat,
  CustomerSettlmtRecipient,
  SupplierSubrange,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5
FROM R_SuplrSettlmtItem
LEFT OUTER JOIN C_SuplrSettlmtOutputForm AS _SuplrSettlmt ON SuplrSettlmt = _SuplrSettlmt.SuplrSettlmt  -- association [1..1]
LEFT OUTER JOIN I_SuplrSettlmtItmPlainLongText AS _SuplrSettlmtItmPlainLongText ON SuplrSettlmt = _SuplrSettlmtItmPlainLongText.SuplrSettlmt AND SuplrSettlmtItem = _SuplrSettlmtItmPlainLongText.SuplrSettlmtItem  -- association [0..*]
LEFT OUTER JOIN I_SuplrSettlmtItemPartner AS _SuplrSettlmtItemPartner ON SuplrSettlmt = _SuplrSettlmtItemPartner.SuplrSettlmt AND SuplrSettlmtItem = _SuplrSettlmtItemPartner.SuplrSettlmtItem  -- association [0..*]
LEFT OUTER JOIN I_SettlmtItmStatisticalPrpty AS _SettlmtItmStatisticalPrpty ON SettlmtItmStatisticalPrpty = _SettlmtItmStatisticalPrpty.SettlmtItmStatisticalPrpty  -- association [0..1]
LEFT OUTER JOIN I_SettlmtActivityReasonCode AS _SettlmtItemActivityReason ON SettlmtItemActivityReason = _SettlmtItemActivityReason.SettlmtActivityReason  -- association [0..1]
LEFT OUTER JOIN I_SuplrSettlmtItmPrcgElmnt AS _SuplrSettlmtItmPrcgElmnt ON SuplrSettlmt = _SuplrSettlmtItmPrcgElmnt.SuplrSettlmt AND SuplrSettlmtItem = _SuplrSettlmtItmPrcgElmnt.SuplrSettlmtItem  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtDocItemCancld AS _SuplrSettlmtItmCancld ON SuplrSettlmtItmCancld = _SuplrSettlmtItmCancld.SettlmtMgmtDocItemCancld  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _SuplrSettlmtCompanyCode ON SuplrSettlmtCompanyCode = _SuplrSettlmtCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN C_SuplrSettlmtItemOutputForm AS _HigherLevelItem ON SuplrSettlmt = _HigherLevelItem.SuplrSettlmt AND HigherLevelItem = _HigherLevelItem.SuplrSettlmtItem  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _SuplrSettlmtBusinessArea ON SuplrSettlmtBusinessArea = _SuplrSettlmtBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _SuplrSettlmtControllingArea ON SuplrSettlmtControllingArea = _SuplrSettlmtControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _SuplrSettlmtCostCenter ON SuplrSettlmtCostCenter = _SuplrSettlmtCostCenter.CostCenter AND SuplrSettlmtControllingArea = _SuplrSettlmtCostCenter.ControllingArea AND _SuplrSettlmtCostCenter.ValidityEndDate >= CreationDate AND _SuplrSettlmtCostCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _SuplrSettlmtProfitCenter ON SuplrSettlmtProfitCenter = _SuplrSettlmtProfitCenter.ProfitCenter AND SuplrSettlmtControllingArea = _SuplrSettlmtProfitCenter.ControllingArea AND _SuplrSettlmtProfitCenter.ValidityEndDate >= CreationDate AND _SuplrSettlmtProfitCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _SuplrSettlmtWBSElmntBasicData ON SuplrSettlmtWBSElmntInternalID = _SuplrSettlmtWBSElmntBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_InternalOrder AS _SettlmtMgmtOrder ON SettlmtMgmtOrder = _SettlmtMgmtOrder.InternalOrder  -- association [0..1]
LEFT OUTER JOIN I_ConditionContract AS _SettlmtItemReltdCndnContr ON SettlmtItemReltdCndnContr = _SettlmtItemReltdCndnContr.ConditionContract  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDocItem AS _Extension ON SuplrSettlmt = _Extension.SettlmtMgmtDoc AND SuplrSettlmtItem = _Extension.SettlmtMgmtDocItem  -- association [1..1]
;