C_SettlmtDocItemOutputForm

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_SettlmtDocItemOutputForm.
-- 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_SettlmtDocItemOutputForm AS
SELECT
  SettlmtDoc,
  SettlmtDocItem,
  SettlmtDocCurrency,
  SupplierPricingDocument,
  CustomerPricingDocument,
  Product,
  ProductGroup,
  Plant,
  SupplierTaxCode,
  CustomerTaxCode,
  TaxCountry,
  IntercompanyTaxCountry,
  SuplrSettlmtTxRateValdFrmDate,
  CustSettlmtTxRateValdFrmDate,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  SupplierItemGrossAmount,
  SupplierItemNetAmount,
  SupplierSubtotal1Amount,
  SupplierSubtotal2Amount,
  SupplierSubtotal3Amount,
  SupplierSubtotal4Amount,
  SupplierSubtotal5Amount,
  SupplierSubtotal6Amount,
  SupplierRebateBasisAmount,
  SupplierEffectiveItemAmount,
  SuplrItmEligibleAmtForCshDisc,
  SupplierItemTaxAmount,
  CustomerItemGrossAmount,
  CustomerItemNetAmount,
  CustomerSubtotal1Amount,
  CustomerSubtotal2Amount,
  CustomerSubtotal3Amount,
  CustomerSubtotal4Amount,
  CustomerSubtotal5Amount,
  CustomerSubtotal6Amount,
  CustomerRebateBasisAmount,
  CustomerEffectiveItemAmount,
  CustItmEligibleAmtForCshDisc,
  CustomerItemTaxAmount,
  SettlmtItmStatisticalPrpty,
  CashDiscountIsDeductible,
  CreatedByUser,
  CreationDate,
  CreationTime,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtSourceDocFiscalYear,
  SettlmtItemActivityReason,
  SettlmtDocItemText,
  SupplierProductID,
  TaxJurisdiction,
  IntercompanyTaxJurisdiction,
  BusinessPlace,
  IntercompanyBusinessPlace,
  ProductPurchasePointsQtyUnit,
  ProductPurchasePointsQty,
  PriorSupplier,
  NonDeductibleInputTaxAmount,
  InventoryValuationType,
  SuplrSettlmtBusinessArea,
  CustSettlmtBusinessArea,
  SuplrSettlmtControllingArea,
  SuplrSettlmtCostCenter,
  SuplrSettlmtProfitCenter,
  IncotermsVersion,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  CustSettlmtControllingArea,
  CustSettlmtCostCenter,
  CustSettlmtProfitCenter,
  Batch,
  SupplierPrcDetnIsIncmplt,
  CustomerPrcDetnIsIncmplt,
  SettlmtPrecdgDoc,
  SettlmtPrecdgDocItem,
  SettlmtPrecdgDocCat,
  SettlmtPrecdgDocFiscalYear,
  SettlmtDocItemCat,
  SettlmtItemReltdCndnContr,
  SettlmtItemReltdTrdgContr,
  SettlmtItemReltdTrdgContrItem,
  SettlmtItemReltdPurgDoc,
  SettlmtItemReltdPurgDocItem,
  SettlmtItemReltdBillgDoc,
  SettlmtItemReltdBillgDocItem,
  SettlmtDocItemStatus,
  SettlmtDocItemCancld,
  SupplierSettlementOrder,
  SupplierItemSettlmtStatus,
  CustomerItemSettlmtStatus,
  SupplierItemSettlmtBlkgReason,
  CustomerItemSettlmtBlkgReason,
  ItemSettlmtRelevance,
  ServicesRenderedDate,
  SuplrSettlmtCompanyCode,
  GLAccount,
  SettlementFiscalYear,
  HigherLevelItem,
  LowerLevelItemExists,
  ItemDistributionStatus,
  SettlmtRefDocType,
  SettlmtRefDoc,
  CndnContrType,
  CndnContrProcVar,
  SettlmtDateCat,
  SettlmtDate,
  SettlmtDateSequentialID,
  ActualSettlmtDate,
  SettlmtPeriodStartDate,
  RefSettlmtDate,
  SettlmtRefDocFiscalYear,
  SettlmtRefDocLogicalSyst,
  SettlmtRefDocCompanyCode,
  SettlmtRefDocItem,
  SettlmtRefDocCat,
  ItemIntrastatRelevance,
  CustomerSettlementOrder,
  SuplrSettlmtWBSElmntInternalID,
  CustSettlmtWBSElmntInternalID,
  SettlmtDocItemCollSts,
  CollSettlmtItemBlkgReason,
  ItmSettlmtDocCollRelevance,
  SettlmtAddlRefDocType,
  SettlmtAddlRefDoc,
  SettlmtAddlRefDocFiscalYear,
  SettlmtAddlRefDocLogicalSyst,
  SettlmtAddlRefDocItem,
  SettlmtAddlRefDocCat,
  CustomerSettlmtRecipient,
  SupplierSubrange,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  BusVolDocSalesOrganization,
  BusVolDocDistributionChannel,
  BusVolDocDivision,
  ProductCommissionGroup,
  PriceSpecificationProductGroup,
  SalesVolumeRebateGroup,
  BusTransDocReferenceID,
  BusTransDocReferenceItemID,
  SettlmtDocItemChangeState
FROM R_SettlmtDocItem
LEFT OUTER JOIN C_SettlmtDocOutputForm AS _SettlmtDoc ON SettlmtDoc = _SettlmtDoc.SettlmtDoc  -- association [1..1]
LEFT OUTER JOIN I_SettlmtDocItemPartner AS _SettlmtDocItemPartner ON SettlmtDoc = _SettlmtDocItemPartner.SettlmtDoc AND SettlmtDocItem = _SettlmtDocItemPartner.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 C_SettlmtDocItemOutputForm 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_SettlmtDocItmSuplrPrcgElmnt AS _SettlmtDocItmSuplrPrcgElmnt ON SettlmtDoc = _SettlmtDocItmSuplrPrcgElmnt.SettlmtDoc AND SettlmtDocItem = _SettlmtDocItmSuplrPrcgElmnt.SettlmtDocItem  -- association [0..*]
LEFT OUTER JOIN I_SettlmtDocItmCustPrcgElmnt AS _SettlmtDocItmCustPrcgElmnt ON SettlmtDoc = _SettlmtDocItmCustPrcgElmnt.SettlmtDoc AND SettlmtDocItem = _SettlmtDocItmCustPrcgElmnt.SettlmtDocItem  -- association [0..*]
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_ProductText AS _ProductText ON Product = _ProductText.Product  -- 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 I_SettlmtDocItemPlainLongText AS _SettlmtDocItemPlainLongText ON SettlmtDoc = _SettlmtDocItemPlainLongText.SettlmtDoc AND SettlmtDocItem = _SettlmtDocItemPlainLongText.SettlmtDocItem  -- association [0..*]
LEFT OUTER JOIN I_CndnContrType AS _CndnContrType ON CndnContrType = _CndnContrType.CndnContrType  -- 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 SettlmtDoc = _Extension.SettlmtMgmtDoc AND SettlmtDocItem = _Extension.SettlmtMgmtDocItem  -- association [1..1]
;