R_SettlmtDocItem

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_SettlmtDocItem.
-- 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_SettlmtDocItem AS
SELECT
  cast( SettlmtMgmtDoc as wbeln_zr preserving type ) AS SettlmtDoc,
  SettlmtMgmtDocItem AS SettlmtDocItem,
  SettlmtDocCurrency,
  cast( SupplierPricingDocument as wlf_knumv_k preserving type ) AS SupplierPricingDocument,
  cast( CustomerPricingDocument as wlf_knumv_d preserving type ) AS CustomerPricingDocument,
  Product,
  ProductGroup,
  Plant,
  InventoryValuationType,
  cast( SupplierTaxCode as wlf_mwskz_k preserving type ) AS SupplierTaxCode,
  cast( CustomerTaxCode as wlf_mwskz_d preserving type ) AS CustomerTaxCode,
  TaxCountry,
  IntercompanyTaxCountry,
  SuplrSettlmtTxRateValdFrmDate,
  CustSettlmtTxRateValdFrmDate,
  TaxJurisdiction,
  IntercompanyTaxJurisdiction,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  ProductPurchasePointsQtyUnit,
  ProductPurchasePointsQty,
  cast( SupplierItemGrossAmount as wlf_brtwr_lfp preserving type ) AS SupplierItemGrossAmount,
  cast( SupplierItemNetAmount as wlf_netwr_lfp preserving type ) AS SupplierItemNetAmount,
  SupplierItemTaxAmount,
  SupplierSubtotal1Amount,
  SupplierSubtotal2Amount,
  SupplierSubtotal3Amount,
  SupplierSubtotal4Amount,
  SupplierSubtotal5Amount,
  SupplierSubtotal6Amount,
  SupplierRebateBasisAmount,
  cast( SupplierEffectiveItemAmount as wlf_effwr_k preserving type ) AS SupplierEffectiveItemAmount,
  SuplrItmEligibleAmtForCshDisc,
  cast( CustomerItemGrossAmount as wlf_brtwrd_lfp preserving type ) AS CustomerItemGrossAmount,
  cast( CustomerItemNetAmount as wlf_netwrd_lfp preserving type ) AS CustomerItemNetAmount,
  CustomerItemTaxAmount,
  CustomerSubtotal1Amount,
  CustomerSubtotal2Amount,
  CustomerSubtotal3Amount,
  CustomerSubtotal4Amount,
  CustomerSubtotal5Amount,
  CustomerSubtotal6Amount,
  CustomerRebateBasisAmount,
  cast( CustomerEffectiveItemAmount as wlf_effwr_d preserving type ) AS CustomerEffectiveItemAmount,
  CustItmEligibleAmtForCshDisc,
  NonDeductibleInputTaxAmount,
  SettlmtItmStatisticalPrpty,
  CashDiscountIsDeductible,
  CreatedByUser,
  CreationDate,
  CreationTime,
  SettlmtRefDocReltdFiscalYear,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtSourceDocFiscalYear,
  SettlmtItemActivityReason,
  SettlmtMgmtDocItemText AS SettlmtDocItemText,
  SupplierProductID,
  BusinessPlace,
  IntercompanyBusinessPlace,
  PriorSupplier,
  SuplrSettlmtBusinessArea,
  SuplrSettlmtControllingArea,
  SuplrSettlmtCostCenter,
  SuplrSettlmtProfitCenter,
  SuplrSettlmtWBSElmntInternalID,
  CustSettlmtBusinessArea,
  CustSettlmtControllingArea,
  CustSettlmtCostCenter,
  CustSettlmtProfitCenter,
  CustSettlmtWBSElmntInternalID,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  Batch,
  SupplierPrcDetnIsIncmplt,
  CustomerPrcDetnIsIncmplt,
  SettlmtPrecdgDoc,
  SettlmtPrecdgDocItem,
  SettlmtPrecdgDocCat,
  SettlmtPrecdgDocFiscalYear,
  SettlmtMgmtDocItemCat AS SettlmtDocItemCat,
  SettlmtItemReltdRefDocCat,
  SettlmtItemReltdRefDoc,
  SettlmtItemReltdRefDocItem,
  SettlmtItemReltdCndnContr,
  SettlmtItemReltdTrdgContr,
  SettlmtItemReltdTrdgContrItem,
  SettlmtItemReltdPurgDoc,
  SettlmtItemReltdPurgDocItem,
  SettlmtItemReltdBillgDoc,
  SettlmtItemReltdBillgDocItem,
  SettlmtMgmtDocItemStatus AS SettlmtDocItemStatus,
  SettlmtMgmtDocItemCancld AS SettlmtDocItemCancld,
  SupplierSettlementOrder,
  CustomerSettlementOrder,
  SupplierItemSettlmtStatus,
  CustomerItemSettlmtStatus,
  SupplierItemSettlmtBlkgReason,
  CustomerItemSettlmtBlkgReason,
  ItemSettlmtRelevance,
  ServicesRenderedDate,
  CompanyCode AS SuplrSettlmtCompanyCode,
  GLAccount,
  SettlementFiscalYear,
  HigherLevelItem,
  LowerLevelItemExists,
  ItemDistributionStatus,
  SettlmtRefDocType,
  SettlmtRefDoc,
  SettlmtRefDocFiscalYear,
  SettlmtRefDocLogicalSyst,
  SettlmtRefDocCompanyCode,
  SettlmtRefDocItem,
  SettlmtRefDocCat,
  CndnContrType,
  CndnContrProcVar,
  SettlmtDateCat,
  SettlmtDate,
  SettlmtDateSequentialID,
  ActualSettlmtDate,
  SettlmtPeriodStartDate,
  RefSettlmtDate,
  ItemIntrastatRelevance,
  SettlmtMgmtDocItemCollSts AS SettlmtDocItemCollSts,
  CollSettlmtItemBlkgReason,
  ItmSettlmtDocCollRelevance,
  SettlmtAddlRefDocType,
  SettlmtAddlRefDoc,
  SettlmtAddlRefDocItem,
  SettlmtAddlRefDocFiscalYear,
  SettlmtAddlRefDocLogicalSyst,
  SettlmtAddlRefDocCat,
  CustomerSettlmtRecipient,
  SupplierSubrange,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  cast( SettlmtItemSalesOrganization as wlf_bvdoc_sales_org preserving type ) AS BusVolDocSalesOrganization,
  cast( SettlmtItemDistributionChannel as wlf_bvdoc_distr_chnl preserving type ) AS BusVolDocDistributionChannel,
  cast( SettlmtItemDivision as wlf_bvdoc_division preserving type ) AS BusVolDocDivision,
  ProductCommissionGroup,
  PriceSpecificationProductGroup,
  SalesVolumeRebateGroup,
  BusTransDocReferenceID,
  BusTransDocReferenceItemID,
  SettlmtMgmtDocItemChangeState AS SettlmtDocItemChangeState
FROM R_SettlmtMgmtDocItem
LEFT OUTER JOIN R_SettlmtDoc AS _SettlmtDoc ON SettlmtDoc = _SettlmtDoc.SettlmtDoc  -- association [1..1]
LEFT OUTER JOIN I_SettlmtDocItemPlainLongText AS _SettlmtDocItemPlainLongText ON SettlmtDoc = _SettlmtDocItemPlainLongText.SettlmtDoc AND SettlmtDocItem = _SettlmtDocItemPlainLongText.SettlmtDocItem  -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocItemPartner AS _Partner ON SettlmtDoc = _Partner.SettlmtDoc AND SettlmtDocItem = _Partner.SettlmtDocItem  -- association [0..*]
LEFT OUTER JOIN I_ProductText AS _ProductText ON Product = _ProductText.Product  -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocItmSuplrPrcgElmnt AS _SupplierPricingElement ON SettlmtDoc = _SupplierPricingElement.SettlmtDoc AND SettlmtDocItem = _SupplierPricingElement.SettlmtDocItem  -- association [0..*]
LEFT OUTER JOIN R_SettlmtDocItmCustPrcgElmnt AS _CustomerPricingElement ON SettlmtDoc = _CustomerPricingElement.SettlmtDoc AND SettlmtDocItem = _CustomerPricingElement.SettlmtDocItem  -- association [0..*]
LEFT OUTER JOIN I_SettlmtMgmtDocItemCat AS _SettlmtDocItemCat ON SettlmtDocItemCat = _SettlmtDocItemCat.SettlmtMgmtDocItemCat  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocItemStatus AS _SettlmtDocItemStatus ON SettlmtDocItemStatus = _SettlmtDocItemStatus.SettlmtMgmtDocItemStatus  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocItemCancld AS _SettlmtDocItemCancld ON SettlmtDocItemCancld = _SettlmtDocItemCancld.SettlmtMgmtDocItemCancld  -- association [0..1]
LEFT OUTER JOIN R_SettlmtDocItem AS _HigherLevelItem ON SettlmtDoc = _HigherLevelItem.SettlmtDoc AND HigherLevelItem = _HigherLevelItem.SettlmtDocItem  -- association [0..1]
LEFT OUTER JOIN I_SettlmtMgmtDocItemCollSts AS _SettlmtDocItemCollSts ON SettlmtDocItemCollSts = _SettlmtDocItemCollSts.SettlmtMgmtDocItemCollSts  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _SuplrSettlmtCompanyCode ON SuplrSettlmtCompanyCode = _SuplrSettlmtCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON GLAccount = _GLAccountInCompanyCode.GLAccount AND SuplrSettlmtCompanyCode = _GLAccountInCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _SuplrSettlmtBusinessAreaText ON SuplrSettlmtBusinessArea = _SuplrSettlmtBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_BusinessAreaText AS _CustSettlmtBusinessAreaText ON CustSettlmtBusinessArea = _CustSettlmtBusinessAreaText.BusinessArea  -- association [0..*]
LEFT OUTER JOIN I_SalesOrganization AS _BusVolDocSalesOrganization ON BusVolDocSalesOrganization = _BusVolDocSalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _BusVolDocDistributionChannel ON BusVolDocDistributionChannel = _BusVolDocDistributionChannel.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _BusVolDocDivision ON BusVolDocDivision = _BusVolDocDivision.Division  -- association [0..1]
LEFT OUTER JOIN E_SettlmtMgmtDocItem AS _Extension ON SettlmtDoc = _Extension.SettlmtMgmtDoc AND SettlmtDocItem = _Extension.SettlmtMgmtDocItem  -- association [1..1]
;