I_CustSettlmtItem

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_CustSettlmtItem.
-- 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_CustSettlmtItem AS
SELECT
  CustSettlmt,
  CustSettlmtItem,
  CustSettlmtCurrency,
  PricingDocument AS CustomerPricingDocument,
  Product,
  ProductGroup,
  Plant,
  InventoryValuationType,
  PricingDate,
  TaxCode AS CustomerTaxCode,
  TaxCountry,
  TaxJurisdiction,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ProductPurchasePointsQtyUnit,
  ProductPurchasePointsQty,
  CustSettlmtItemGrossAmount AS CustomerItemGrossAmount,
  CustSettlmtItemNetAmount AS CustomerItemNetAmount,
  CustSettlmtItemTaxAmount AS CustomerItemTaxAmount,
  CustSettlmtSubtotal1Amount AS CustomerSubtotal1Amount,
  CustSettlmtSubtotal2Amount AS CustomerSubtotal2Amount,
  CustSettlmtSubtotal3Amount AS CustomerSubtotal3Amount,
  CustSettlmtSubtotal4Amount AS CustomerSubtotal4Amount,
  CustSettlmtSubtotal5Amount AS CustomerSubtotal5Amount,
  CustSettlmtSubtotal6Amount AS CustomerSubtotal6Amount,
  CustSettlmtRebateBasisAmount AS CustomerRebateBasisAmount,
  CustSettlmtEffectiveItemAmount AS CustomerEffectiveItemAmount,
  CustItmEligibleAmtForCshDisc,
  NonDeductibleInputTaxAmount,
  CustSettlmtItmStstclPrpty AS SettlmtItmStatisticalPrpty,
  cast( CashDiscountIsDeductible as wlf_sktof preserving type ) AS CashDiscountIsDeductible,
  CreatedByUser,
  CreationDate,
  CreationTime,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtSourceDocFiscalYear,
  CustSettlmtItmActivityReason AS SettlmtItemActivityReason,
  CustSettlmtItemText,
  BusinessArea AS CustSettlmtBusinessArea,
  ControllingArea AS CustSettlmtControllingArea,
  CostCenter AS CustSettlmtCostCenter,
  ProfitCenter AS CustSettlmtProfitCenter,
  WBSElementInternalID AS CustSettlmtWBSElmntInternalID,
  CustomerSettlementOrder AS SettlmtMgmtOrder,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  Batch,
  PrcDetnIsIncmplt,
  SettlmtPrecdgDoc,
  SettlmtPrecdgDocItem,
  SettlmtPrecdgDocCat,
  SettlmtPrecdgDocFiscalYear,
  CustSettlmtItmCat,
  SettlmtItemReltdCndnContr,
  CustSettlmtItemStatus,
  CustSettlmtItemReversed AS CustSettlmtItmCancld,
  ServicesRenderedDate,
  SettlementFiscalYear,
  HigherLevelItem,
  LowerLevelItemExists,
  ItemDistributionStatus,
  SettlmtRefDoc,
  SettlmtRefDocFiscalYear,
  SettlmtRefDocLogicalSyst,
  SettlmtRefDocItem,
  SettlmtRefDocCat,
  ItemIntrastatRelevance,
  SettlmtAddlRefDoc,
  SettlmtAddlRefDocFiscalYear,
  SettlmtAddlRefDocLogicalSyst,
  SettlmtAddlRefDocItem,
  SettlmtAddlRefDocCat,
  CustomerSettlmtRecipient,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5
FROM R_CustSettlmtItem
LEFT OUTER JOIN I_CustSettlmt AS _CustSettlmt ON CustSettlmt = _CustSettlmt.CustSettlmt  -- association [1..1]
LEFT OUTER JOIN I_CustSettlmtItemPlainLongText AS _CustSettlmtItemPlainLongText ON CustSettlmt = _CustSettlmtItemPlainLongText.CustSettlmt AND CustSettlmtItem = _CustSettlmtItemPlainLongText.CustSettlmtItem  -- association [0..*]
LEFT OUTER JOIN I_CustSettlmtItemPartner AS _Partner ON CustSettlmt = _Partner.CustSettlmt AND CustSettlmtItem = _Partner.CustSettlmtItem  -- 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_CustSettlmtItmPrcgElmnt AS _CustomerPricingElement ON CustSettlmt = _CustomerPricingElement.CustSettlmt AND CustSettlmtItem = _CustomerPricingElement.CustSettlmtItem  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtDocItemCancld AS _CustSettlmtItmCancld ON CustSettlmtItmCancld = _CustSettlmtItmCancld.SettlmtMgmtDocItemCancld  -- association [0..1]
LEFT OUTER JOIN I_CustSettlmtItem AS _HigherLevelItem ON CustSettlmt = _HigherLevelItem.CustSettlmt AND HigherLevelItem = _HigherLevelItem.CustSettlmtItem  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _CustSettlmtBusinessArea ON CustSettlmtBusinessArea = _CustSettlmtBusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _CustSettlmtControllingArea ON CustSettlmtControllingArea = _CustSettlmtControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CustSettlmtCostCenter ON CustSettlmtCostCenter = _CustSettlmtCostCenter.CostCenter AND CustSettlmtControllingArea = _CustSettlmtCostCenter.ControllingArea AND _CustSettlmtCostCenter.ValidityEndDate >= CreationDate AND _CustSettlmtCostCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _CustSettlmtProfitCenter ON CustSettlmtProfitCenter = _CustSettlmtProfitCenter.ProfitCenter AND CustSettlmtControllingArea = _CustSettlmtProfitCenter.ControllingArea AND _CustSettlmtProfitCenter.ValidityEndDate >= CreationDate AND _CustSettlmtProfitCenter.ValidityStartDate <= CreationDate  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _CustSettlmtWBSElmntBasicData ON CustSettlmtWBSElmntInternalID = _CustSettlmtWBSElmntBasicData.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 I_SettlmtPrecdgDocCat AS _SettlmtRefDocCat ON SettlmtRefDocCat = _SettlmtRefDocCat.SettlmtPrecdgDocCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtPrecdgDocCat AS _SettlmtAddlRefDocCat ON SettlmtAddlRefDocCat = _SettlmtAddlRefDocCat.SettlmtPrecdgDocCat  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDocItem AS _Extension ON CustSettlmt = _Extension.SettlmtMgmtDoc AND CustSettlmtItem = _Extension.SettlmtMgmtDocItem  -- association [1..1]
;