A_SettlmtDocItem

DDL: A_SETTLMTDOCITEM Type: view_entity CONSUMPTION Package: WLF_API_A2A_SDOC_SRV
77 Fields 1 Data Sources 1 OData Services

Settlement Document Item

A_SettlmtDocItem is a Consumption CDS View that provides data about "Settlement Document Item" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocItemTP) and exposes 77 fields with key fields SettlmtDoc, SettlmtDocItem. It is exposed through 1 OData service (API_SETTLMT_DOC). Part of development package WLF_API_A2A_SDOC_SRV.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocItemTP R_SettlmtDocItemTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Settlement Document Item view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view

OData Services (1)

ServiceBindingVersionContractRelease
API_SETTLMT_DOC API_SETTLMT_DOC V4 C2 C1

Fields (77)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtDoc Settlement Doc.
KEY SettlmtDocItem SettlmtDocItem Item
SettlmtDocCurrency SettlmtDocCurrency Doc. Currency
Product Product Product Sold
ProductGroup ProductGroup Product Sold Group
Plant Plant Valuation Area
SupplierTaxCode SupplierTaxCode Supplier Tax Code
CustomerTaxCode CustomerTaxCode Customer Tax Code
PricingDate PricingDate Pricing Date
SettlmtQuantity SettlmtQuantity SettlmtQuantity
SettlmtQuantityUnit SettlmtQuantityUnit Settlement Unit
SettlmtQuantityUnitISOCode
SettlmtQuantityUnitSAPCode
NetPriceAmount NetPriceAmount Net Price
NetPriceQuantity NetPriceQuantity Price Unit
NetPriceQuantityUnit NetPriceQuantityUnit SettlmtPrcUnit
SettlmtToBaseQuantityNmrtr SettlmtToBaseQuantityNmrtr Numerator Settlement UoM to Base UoM
SettlmtToBaseQuantityDnmntr SettlmtToBaseQuantityDnmntr Denominator Settlement UoM to Base UoM
BaseUnit BaseUnit Unit of Measure
ItemNetWeight ItemNetWeight Net Weight
ItemGrossWeight ItemGrossWeight Gross Weight
ItemWeightUnit ItemWeightUnit Unit of Weight
ItemWeightUnitISOCode
ItemWeightUnitSAPCode
ItemVolume ItemVolume Volume
ItemVolumeUnit ItemVolumeUnit Volume Unit
ItemVolumeUnitISOCode
ItemVolumeUnitSAPCode
SupplierItemGrossAmount SupplierItemGrossAmount Supplier Item Gross Amount
SupplierItemNetAmount SupplierItemNetAmount Supplier Item Net Amount
SupplierItemTaxAmount SupplierItemTaxAmount Suplr Item Tax Amnt
CustomerItemGrossAmount CustomerItemGrossAmount Customer Item Gross Amount
CustomerItemNetAmount CustomerItemNetAmount Customer Item Net Amount
CustomerItemTaxAmount CustomerItemTaxAmount Customer Item Tax Amount
CashDiscountIsDeductible CashDiscountIsDeductible Cash Discount
SettlmtSourceDoc SettlmtSourceDoc Source Doc.
SettlmtSourceDocItem SettlmtSourceDocItem Item of the Source Document
SettlmtSourceDocCat SettlmtSourceDocCat SourceDocCat
SettlmtItemActivityReason SettlmtItemActivityReason Activity Reason
SettlmtDocItemText SettlmtDocItemText Short Text
SupplierProductID SupplierProductID Supp. Mat. No.
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
ProductPurchasePointsQtyUnit ProductPurchasePointsQtyUnit Points Unit
ProdPurPointsQtyUnitISOCode
ProdPurPointsQtyUnitSAPCode
ProductPurchasePointsQty ProductPurchasePointsQty Points
SuplrSettlmtBusinessArea SuplrSettlmtBusinessArea Business Area
CustSettlmtBusinessArea CustSettlmtBusinessArea Cust. Business Area
SuplrSettlmtCostCenter SuplrSettlmtCostCenter Cost Center
SuplrSettlmtProfitCenter SuplrSettlmtProfitCenter Profit Center
IncotermsVersion IncotermsVersion Inco. Version
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
CustSettlmtCostCenter CustSettlmtCostCenter Cust Cost Ctr
CustSettlmtProfitCenter CustSettlmtProfitCenter Cust. Profit Center
SettlmtPrecdgDoc SettlmtPrecdgDoc Pre. Document
SettlmtPrecdgDocItem SettlmtPrecdgDocItem Item of Preceding Document
SettlmtPrecdgDocCat SettlmtPrecdgDocCat PreDocCat
SettlmtDocItemCat SettlmtDocItemCat Item Category
SettlmtItemReltdRefDocCat SettlmtItemReltdRefDocCat Settlement Item Related Ref. Doc. Cat.
SettlmtItemReltdRefDoc SettlmtItemReltdRefDoc Settlement Item Related Reference Doc.
SettlmtItemReltdRefDocItem SettlmtItemReltdRefDocItem Settlement Item Related Ref. Doc. Item
SupplierSettlementOrder SupplierSettlementOrder Order
ItemSettlmtRelevance ItemSettlmtRelevance Itm Sttlm Relevance
SettlementFiscalYear SettlementFiscalYear Fiscal Year of Settlement
SettlmtRefDoc SettlmtRefDoc Settlmt. Ref. Doc.
SettlmtRefDocCompanyCode SettlmtRefDocCompanyCode Ref. Company Code
SettlmtRefDocItem SettlmtRefDocItem SettlmtRefDocItem
SettlmtRefDocCat SettlmtRefDocCat SettlmtRefDocCat
CustomerSettlmtRecipient CustomerSettlmtRecipient Cust Settlmt Recpnt
SupplierSubrange SupplierSubrange Suppl. Subrange
IntercompanyTaxCountry IntercompanyTaxCountry Tax Ctry/Reg. Intercompany
TaxCountry TaxCountry Tax Ctry/Reg.
PriorSupplier PriorSupplier Prior Supplier
_PriorSupplier _PriorSupplier
_CustomerSettlmtRecipient _CustomerSettlmtRecipient
_SettlmtDocItemCat _SettlmtDocItemCat

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 A_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 A_SettlmtDocItem AS
SELECT
  SettlmtDoc,
  SettlmtDocItem,
  SettlmtDocCurrency,
  Product,
  ProductGroup,
  Plant,
  SupplierTaxCode,
  CustomerTaxCode,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  cast (_SettlmtQuantityUnit.UnitOfMeasureISOCode as wlf_wfkme_iso preserving type ) AS SettlmtQuantityUnitISOCode,
  cast (_SettlmtQuantityUnit.UnitOfMeasureSAPCode as wlf_wfkme_sapcode preserving type ) AS SettlmtQuantityUnitSAPCode,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  cast (_ItemWeightUnit.UnitOfMeasureISOCode as gewei_iso preserving type ) AS ItemWeightUnitISOCode,
  cast (_ItemWeightUnit.UnitOfMeasureSAPCode as wlf_gewei_sapcode preserving type ) AS ItemWeightUnitSAPCode,
  ItemVolume,
  ItemVolumeUnit,
  cast(_ItemVolumeUnit.UnitOfMeasureISOCode as voleh_iso preserving type ) AS ItemVolumeUnitISOCode,
  cast(_ItemVolumeUnit.UnitOfMeasureSAPCode as wlf_voleh_sapcode preserving type ) AS ItemVolumeUnitSAPCode,
  SupplierItemGrossAmount,
  SupplierItemNetAmount,
  SupplierItemTaxAmount,
  CustomerItemGrossAmount,
  CustomerItemNetAmount,
  CustomerItemTaxAmount,
  CashDiscountIsDeductible,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtItemActivityReason,
  SettlmtDocItemText,
  SupplierProductID,
  TaxJurisdiction,
  ProductPurchasePointsQtyUnit,
  cast(_ProductPurchasePointsQtyUnit.UnitOfMeasureISOCode as wlf_punei_iso preserving type ) AS ProdPurPointsQtyUnitISOCode,
  cast(_ProductPurchasePointsQtyUnit.UnitOfMeasureSAPCode as wlf_punei_sapcode preserving type ) AS ProdPurPointsQtyUnitSAPCode,
  ProductPurchasePointsQty,
  SuplrSettlmtBusinessArea,
  CustSettlmtBusinessArea,
  SuplrSettlmtCostCenter,
  SuplrSettlmtProfitCenter,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  CustSettlmtCostCenter,
  CustSettlmtProfitCenter,
  SettlmtPrecdgDoc,
  SettlmtPrecdgDocItem,
  SettlmtPrecdgDocCat,
  SettlmtDocItemCat,
  SettlmtItemReltdRefDocCat,
  SettlmtItemReltdRefDoc,
  SettlmtItemReltdRefDocItem,
  SupplierSettlementOrder,
  ItemSettlmtRelevance,
  SettlementFiscalYear,
  SettlmtRefDoc,
  SettlmtRefDocCompanyCode,
  SettlmtRefDocItem,
  SettlmtRefDocCat,
  CustomerSettlmtRecipient,
  SupplierSubrange,
  IntercompanyTaxCountry,
  TaxCountry,
  PriorSupplier
FROM R_SettlmtDocItemTP
;

Learn More