C_MngSettlmtDocsItem

DDL: C_MNGSETTLMTDOCSITEM Type: view_entity CONSUMPTION Package: WLF_UI_SDOC_F3254
196 Fields 1 Data Sources 2 OData Services

Manage Settlement Document Item

C_MngSettlmtDocsItem is a Consumption CDS View that provides data about "Manage Settlement Document Item" in SAP S/4HANA. It reads from 1 data source (R_SettlmtDocItemTP) and exposes 196 fields with key fields SettlmtDoc, SettlmtDocItem. It is exposed through 2 OData services (ASQL_F3254, UI_LO_SETMAN_SDOC_MAN). Part of development package WLF_UI_SDOC_F3254.

Data Sources (1)

SourceAliasJoin Type
R_SettlmtDocItemTP R_SettlmtDocItemTP projection

Annotations (8)

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

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F3254 ASQL_F3254 C2 NOT_RELEASED
UI_LO_SETMAN_SDOC_MAN UI_LO_SETMAN_SDOC_MAN V4 C1 NOT_RELEASED

Fields (196)

KeyFieldSource TableSource FieldDescription
KEY SettlmtDoc SettlmtDoc Settlement Doc.
KEY SettlmtDocItem SettlmtDocItem Item
SettlmtDocCurrency SettlmtDocCurrency Doc. Currency
SupplierPricingDocument SupplierPricingDocument Supplier Document Condition
CustomerPricingDocument CustomerPricingDocument Customer Document Condition
Product Product Product Sold
ProductNamelocalized
SettlmtDocItemText SettlmtDocItemText Short Text
ProductGroup ProductGroup Product Sold Group
ProductGroupNamelocalized
SupplierTaxCode SupplierTaxCode Supplier Tax Code
CustomerTaxCode CustomerTaxCode Customer Tax Code
SuplrSettlmtTxRateValdFrmDate SuplrSettlmtTxRateValdFrmDate Supplier Tax Rate Valid-From
CustSettlmtTxRateValdFrmDate CustSettlmtTxRateValdFrmDate Customer Tax Rate Valid-From
PricingDate PricingDate Pricing Date
SettlmtQuantity SettlmtQuantity SettlmtQuantity
SettlmtQuantityUnit SettlmtQuantityUnit Settlement Unit
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
SettlmtToNetPriceQtyNmrtr SettlmtToNetPriceQtyNmrtr Numerator: Sett. UoM to Sett. Price UoM
SettlmtToNetPriceQtyDnmntr SettlmtToNetPriceQtyDnmntr Denominator: Sett. UoM to Sett. PriceUoM
BaseUnit BaseUnit Unit of Measure
ItemNetWeight ItemNetWeight Net Weight
ItemGrossWeight ItemGrossWeight Gross Weight
ItemWeightUnit ItemWeightUnit Unit of Weight
ItemVolume ItemVolume Volume
ItemVolumeUnit ItemVolumeUnit Volume Unit
SupplierItemGrossAmount SupplierItemGrossAmount Supplier Item Gross Amount
SupplierItemNetAmount SupplierItemNetAmount Supplier Item Net Amount
SupplierRebateBasisAmount SupplierRebateBasisAmount Suplr Rebate Basis
SupplierEffectiveItemAmount SupplierEffectiveItemAmount Supplier Effective Item Amount
SuplrItmEligibleAmtForCshDisc SuplrItmEligibleAmtForCshDisc Csh.Disc.Bas
SupplierItemTaxAmount SupplierItemTaxAmount Suplr Item Tax Amnt
CustomerItemGrossAmount CustomerItemGrossAmount Customer Item Gross Amount
CustomerItemNetAmount CustomerItemNetAmount Customer Item Net Amount
CustomerRebateBasisAmount CustomerRebateBasisAmount Cust Rebate Basis
CustomerEffectiveItemAmount CustomerEffectiveItemAmount Customer Effective Item Amount
CustItmEligibleAmtForCshDisc CustItmEligibleAmtForCshDisc Cash Disc. Base
CustomerItemTaxAmount CustomerItemTaxAmount Customer Item Tax Amount
SettlmtItmStatisticalPrpty SettlmtItmStatisticalPrpty Statistical Prpty
SettlmtItmStatisticalPrptyNamelocalized
CashDiscountIsDeductible CashDiscountIsDeductible Cash Discount
CreatedByUser CreatedByUser User Name
CreatedByUserFullName _CreatedByUser UserDescription Full Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
SettlmtSourceDoc SettlmtSourceDoc Source Doc.
SettlmtSourceDocItem SettlmtSourceDocItem Item of the Source Document
SettlmtSourceDocCat SettlmtSourceDocCat SourceDocCat
SettlmtSourceDocFiscalYear SettlmtSourceDocFiscalYear Fiscal Year of Source Document
SettlmtItemActivityReason SettlmtItemActivityReason Activity Reason
SupplierProductID SupplierProductID Supp. Mat. No.
BusinessPlace BusinessPlace Business place
IntercompanyBusinessPlace IntercompanyBusinessPlace Business Place Intercompany
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
IntercompanyTaxJurisdiction IntercompanyTaxJurisdiction Tax Jur Intercompany
ProductPurchasePointsQtyUnit ProductPurchasePointsQtyUnit Points Unit
ProductPurchasePointsQty ProductPurchasePointsQty Points
PriorSupplierName _PriorSupplier SupplierName Supplier Name
PriorSupplier PriorSupplier Prior Supplier
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount Non-deductible
InventoryValuationType InventoryValuationType Valuation Type
SuplrSettlmtBusinessArea SuplrSettlmtBusinessArea Business Area
CustSettlmtBusinessArea CustSettlmtBusinessArea Cust. Business Area
SuplrSettlmtControllingArea SuplrSettlmtControllingArea Controlling Area
SuplrSettlmtCostCenter SuplrSettlmtCostCenter Cost Center
SuplrSettlmtProfitCenter SuplrSettlmtProfitCenter Profit Center
IncotermsVersion IncotermsVersion Inco. Version
IncotermsClassification IncotermsClassification Incoterms
virtualIncotermsTransferLocationinco2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
CustSettlmtControllingArea CustSettlmtControllingArea Customer Ctrl Area
CustSettlmtCostCenter CustSettlmtCostCenter Cust Cost Ctr
CustSettlmtProfitCenter CustSettlmtProfitCenter Cust. Profit Center
Batch Batch Lot No.
SupplierPrcDetnIsIncmplt SupplierPrcDetnIsIncmplt Supplier Pricing Elements Incomplete
CustomerPrcDetnIsIncmplt CustomerPrcDetnIsIncmplt Customer Pricing Elements Incomplete
SettlmtPrecdgDoc SettlmtPrecdgDoc Pre. Document
SettlmtPrecdgDocItem SettlmtPrecdgDocItem Item of Preceding Document
SettlmtPrecdgDocCat SettlmtPrecdgDocCat PreDocCat
SettlmtPrecdgDocFiscalYear SettlmtPrecdgDocFiscalYear Fiscal Year of Preceding Document
SettlmtDocItemCat SettlmtDocItemCat Item Category
SettlmtMgmtDocItemCatNamelocalized
SettlmtItemReltdCndnContr SettlmtItemReltdCndnContr ItmRelatedCndnContr
SettlmtDocItemStatus SettlmtDocItemStatus Status
SettlmtDocItemCancld SettlmtDocItemCancld Item Canceled
SupplierSettlementOrder SupplierSettlementOrder Order
InternalOrderDescription _SupplierSettlementOrder InternalOrderDescription Description
SupplierItemSettlmtStatus SupplierItemSettlmtStatus Sttlmnt Sts Itm Sup.
CustomerItemSettlmtStatus CustomerItemSettlmtStatus Settlmt StatusItemCu
SupplierItemSettlmtBlkgReason SupplierItemSettlmtBlkgReason Supplier Settlement Item Blocking Reason
CustomerItemSettlmtBlkgReason CustomerItemSettlmtBlkgReason Customer Settlement Item Blocking Reason
ItemSettlmtRelevance ItemSettlmtRelevance Itm Sttlm Relevance
ServicesRenderedDate ServicesRenderedDate Services Rendered Date
SuplrSettlmtCompanyCodeName _SuplrSettlmtCompanyCode CompanyCodeName Company Name
SuplrSettlmtCompanyCode SuplrSettlmtCompanyCode Suppl. Company Code
GLAccount GLAccount General Ledger
GLAccountNameasGLAccountNamelocalized
ItemDistributionStatus ItemDistributionStatus Distributn Status
SettlmtRefDocCat SettlmtRefDocCat SettlmtRefDocCat
SettlmtRefDoc SettlmtRefDoc Settlmt. Ref. Doc.
SettlmtRefDocFiscalYear SettlmtRefDocFiscalYear Year of Reference Document
SettlmtRefDocCompanyCode SettlmtRefDocCompanyCode Ref. Company Code
SettlmtRefDocCompanyCodeName _SettlmtRefDocCompanyCode CompanyCodeName Company Name
SettlmtRefDocLogicalSyst SettlmtRefDocLogicalSyst SM Ref Log Sys
SettlmtRefDocItem SettlmtRefDocItem SettlmtRefDocItem
SettlmtAddlRefDocCat SettlmtAddlRefDocCat SettlmtAddlRefDocCat
SettlmtAddlRefDoc SettlmtAddlRefDoc SettlmtAddlRefDoc
SettlmtAddlRefDocFiscalYear SettlmtAddlRefDocFiscalYear Year of Additional Reference Document
SettlmtAddlRefDocLogicalSyst SettlmtAddlRefDocLogicalSyst SM Addl Ref Log Sys
SettlmtAddlRefDocItem SettlmtAddlRefDocItem SettlmtAddlRefDocItm
SuplrSettlmtWBSElmntInternalID SuplrSettlmtWBSElmntInternalID WBS Element
CustSettlmtWBSElmntInternalID CustSettlmtWBSElmntInternalID Customer WBS Element
SettlmtDocItemCollSts SettlmtDocItemCollSts Collective Settlement Status Item
CollSettlmtItemBlkgReason CollSettlmtItemBlkgReason Collective Settlement Item Block Reason
ItmSettlmtDocCollRelevance ItmSettlmtDocCollRelevance Collective Settlement Relevance
CustomerName _CustomerSettlmtRecipient CustomerName Name of Customer
CustomerSettlmtRecipient CustomerSettlmtRecipient Cust Settlmt Recpnt
SupplierSubrange SupplierSubrange Suppl. Subrange
ProductHierarchy ProductHierarchy Prod.hierarchy
SalesSpcfcProductGroup1 SalesSpcfcProductGroup1 Sales-Specific Product Group 1
SalesSpcfcProductGroup2 SalesSpcfcProductGroup2 Sales-Specific Product Group 2
SalesSpcfcProductGroup3 SalesSpcfcProductGroup3 Sales-Specific Product Group 3
SalesSpcfcProductGroup4 SalesSpcfcProductGroup4 Sales-Specific Product Group 4
SalesSpcfcProductGroup5 SalesSpcfcProductGroup5 Sales-Specific Product Group 5
BusVolDocSalesOrganization BusVolDocSalesOrganization Sales Org in Business Volume Document
BusVolDocDistributionChannel BusVolDocDistributionChannel Distr Chnl in Business Volume Document
BusVolDocDivision BusVolDocDivision Division in Business Volume Document
ProductCommissionGroup ProductCommissionGroup Commission Grp
PriceSpecificationProductGroup PriceSpecificationProductGroup Prd.Price Grp
SalesVolumeRebateGroup SalesVolumeRebateGroup Volume Rebate Group
TaxCountry TaxCountry Tax Ctry/Reg.
IntercompanyTaxCountry IntercompanyTaxCountry Tax Ctry/Reg. Intercompany
SettlmtDocItemChangeState SettlmtDocItemChangeState Item Change State
virtualSettlmtDocHasPrftbltySgmtboolean
virtualUICT_FldGrpIntercompanyTaxboolean
virtualUICT_FldGrpVolWeightPntboolean
virtualUICT_ProfitabilitySegmentboolean
_BaseUnit _BaseUnit
_BusVolDocDistributionChannel _BusVolDocDistributionChannel
_BusVolDocDivision _BusVolDocDivision
_BusVolDocSalesOrganization _BusVolDocSalesOrganization
_CollSettlmtItemBlkgReason _CollSettlmtItemBlkgReason
_CustomerItemSettlmtBlkgReason _CustomerItemSettlmtBlkgReason
_CustomerItemSettlmtStatus _CustomerItemSettlmtStatus
_CustomerSettlmtRecipient _CustomerSettlmtRecipient
_CustSettlmtBusinessArea _CustSettlmtBusinessArea
_CustSettlmtBusinessAreaText _CustSettlmtBusinessAreaText
_CustSettlmtControllingArea _CustSettlmtControllingArea
_CustSettlmtCostCenter _CustSettlmtCostCenter
_CustSettlmtProfitCenter _CustSettlmtProfitCenter
_GLAccountInCompanyCode _GLAccountInCompanyCode
_InventoryValuationType _InventoryValuationType
_ItemSettlmtRelevance _ItemSettlmtRelevance
_ItemVolumeUnit _ItemVolumeUnit
_ItemWeightUnit _ItemWeightUnit
_ItmSettlmtDocCollRelevance _ItmSettlmtDocCollRelevance
_NetPriceQuantityUnit _NetPriceQuantityUnit
_Partner _Partner
_PriorSupplier _PriorSupplier
_Product _Product
_ProductPurchasePointsQtyUnit _ProductPurchasePointsQtyUnit
_ProductText _ProductText
_SalesSpcfcProductGroup1 _SalesSpcfcProductGroup1
_SalesSpcfcProductGroup2 _SalesSpcfcProductGroup2
_SalesSpcfcProductGroup3 _SalesSpcfcProductGroup3
_SalesSpcfcProductGroup4 _SalesSpcfcProductGroup4
_SalesSpcfcProductGroup5 _SalesSpcfcProductGroup5
_SettlmtAddlRefDocCat _SettlmtAddlRefDocCat
_SettlmtAddlRefDocLogicalSyst _SettlmtAddlRefDocLogicalSyst
_SettlmtDocCurrency _SettlmtDocCurrency
_SettlmtDocItemCancld _SettlmtDocItemCancld
_SettlmtDocItemCat _SettlmtDocItemCat
_SettlmtDocItemCollSts _SettlmtDocItemCollSts
_SettlmtDocItemStatus _SettlmtDocItemStatus
_SettlmtItemActivityReason _SettlmtItemActivityReason
_SettlmtItemReltdCndnContr _SettlmtItemReltdCndnContr
_SettlmtItmStatisticalPrpty _SettlmtItmStatisticalPrpty
_SettlmtPrecdgDocCat _SettlmtPrecdgDocCat
_SettlmtQuantityUnit _SettlmtQuantityUnit
_SettlmtRefDocCat _SettlmtRefDocCat
_SettlmtRefDocCompanyCode _SettlmtRefDocCompanyCode
_SettlmtRefDocLogicalSyst _SettlmtRefDocLogicalSyst
_SettlmtSourceDocCat _SettlmtSourceDocCat
_SuplrSettlmtBusinessArea _SuplrSettlmtBusinessArea
_SuplrSettlmtBusinessAreaText _SuplrSettlmtBusinessAreaText
_SuplrSettlmtCompanyCode _SuplrSettlmtCompanyCode
_SuplrSettlmtControllingArea _SuplrSettlmtControllingArea
_SuplrSettlmtCostCenter _SuplrSettlmtCostCenter
_SuplrSettlmtProfitCenter _SuplrSettlmtProfitCenter
_SupplierItemSettlmtBlkgReason _SupplierItemSettlmtBlkgReason
_SupplierItemSettlmtStatus _SupplierItemSettlmtStatus

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_MngSettlmtDocsItem.
-- 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_MngSettlmtDocsItem AS
SELECT
  SettlmtDoc,
  SettlmtDocItem,
  SettlmtDocCurrency,
  SupplierPricingDocument,
  CustomerPricingDocument,
  Product,
  _Product._Text.ProductName : localized AS ProductNamelocalized,
  SettlmtDocItemText,
  ProductGroup,
  _ProductGroup._ProductGroupText.ProductGroupName : localized AS ProductGroupNamelocalized,
  SupplierTaxCode,
  CustomerTaxCode,
  SuplrSettlmtTxRateValdFrmDate,
  CustSettlmtTxRateValdFrmDate,
  PricingDate,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  NetPriceQuantity,
  NetPriceQuantityUnit,
  SettlmtToBaseQuantityNmrtr,
  SettlmtToBaseQuantityDnmntr,
  SettlmtToNetPriceQtyNmrtr,
  SettlmtToNetPriceQtyDnmntr,
  BaseUnit,
  ItemNetWeight,
  ItemGrossWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  SupplierItemGrossAmount,
  SupplierItemNetAmount,
  SupplierRebateBasisAmount,
  SupplierEffectiveItemAmount,
  SuplrItmEligibleAmtForCshDisc,
  SupplierItemTaxAmount,
  CustomerItemGrossAmount,
  CustomerItemNetAmount,
  CustomerRebateBasisAmount,
  CustomerEffectiveItemAmount,
  CustItmEligibleAmtForCshDisc,
  CustomerItemTaxAmount,
  SettlmtItmStatisticalPrpty,
  _SettlmtItmStatisticalPrpty._Text.SettlmtItmStatisticalPrptyName : localized AS SettlmtItmStatisticalPrptyNamelocalized,
  CashDiscountIsDeductible,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserFullName,
  CreationDate,
  CreationTime,
  SettlmtSourceDoc,
  SettlmtSourceDocItem,
  SettlmtSourceDocCat,
  SettlmtSourceDocFiscalYear,
  SettlmtItemActivityReason,
  SupplierProductID,
  BusinessPlace,
  IntercompanyBusinessPlace,
  TaxJurisdiction,
  IntercompanyTaxJurisdiction,
  ProductPurchasePointsQtyUnit,
  ProductPurchasePointsQty,
  _PriorSupplier.SupplierName AS PriorSupplierName,
  PriorSupplier,
  NonDeductibleInputTaxAmount,
  InventoryValuationType,
  SuplrSettlmtBusinessArea,
  CustSettlmtBusinessArea,
  SuplrSettlmtControllingArea,
  SuplrSettlmtCostCenter,
  SuplrSettlmtProfitCenter,
  IncotermsVersion,
  IncotermsClassification,
  virtual IncotermsTransferLocation : inco2 AS virtualIncotermsTransferLocationinco2,
  IncotermsLocation1,
  IncotermsLocation2,
  CustSettlmtControllingArea,
  CustSettlmtCostCenter,
  CustSettlmtProfitCenter,
  Batch,
  SupplierPrcDetnIsIncmplt,
  CustomerPrcDetnIsIncmplt,
  SettlmtPrecdgDoc,
  SettlmtPrecdgDocItem,
  SettlmtPrecdgDocCat,
  SettlmtPrecdgDocFiscalYear,
  SettlmtDocItemCat,
  _SettlmtDocItemCat._Text.SettlmtMgmtDocItemCatName : localized AS SettlmtMgmtDocItemCatNamelocalized,
  SettlmtItemReltdCndnContr,
  SettlmtDocItemStatus,
  SettlmtDocItemCancld,
  SupplierSettlementOrder,
  _SupplierSettlementOrder.InternalOrderDescription AS InternalOrderDescription,
  SupplierItemSettlmtStatus,
  CustomerItemSettlmtStatus,
  SupplierItemSettlmtBlkgReason,
  CustomerItemSettlmtBlkgReason,
  ItemSettlmtRelevance,
  ServicesRenderedDate,
  _SuplrSettlmtCompanyCode.CompanyCodeName AS SuplrSettlmtCompanyCodeName,
  SuplrSettlmtCompanyCode,
  GLAccount,
  _GLAccountInCompanyCode._Text.GLAccountName as GLAccountName : localized AS GLAccountNameasGLAccountNamelocalized,
  ItemDistributionStatus,
  SettlmtRefDocCat,
  SettlmtRefDoc,
  SettlmtRefDocFiscalYear,
  SettlmtRefDocCompanyCode,
  _SettlmtRefDocCompanyCode.CompanyCodeName AS SettlmtRefDocCompanyCodeName,
  SettlmtRefDocLogicalSyst,
  SettlmtRefDocItem,
  SettlmtAddlRefDocCat,
  SettlmtAddlRefDoc,
  SettlmtAddlRefDocFiscalYear,
  SettlmtAddlRefDocLogicalSyst,
  SettlmtAddlRefDocItem,
  SuplrSettlmtWBSElmntInternalID,
  CustSettlmtWBSElmntInternalID,
  SettlmtDocItemCollSts,
  CollSettlmtItemBlkgReason,
  ItmSettlmtDocCollRelevance,
  _CustomerSettlmtRecipient.CustomerName AS CustomerName,
  CustomerSettlmtRecipient,
  SupplierSubrange,
  ProductHierarchy,
  SalesSpcfcProductGroup1,
  SalesSpcfcProductGroup2,
  SalesSpcfcProductGroup3,
  SalesSpcfcProductGroup4,
  SalesSpcfcProductGroup5,
  BusVolDocSalesOrganization,
  BusVolDocDistributionChannel,
  BusVolDocDivision,
  ProductCommissionGroup,
  PriceSpecificationProductGroup,
  SalesVolumeRebateGroup,
  TaxCountry,
  IntercompanyTaxCountry,
  SettlmtDocItemChangeState,
  virtual SettlmtDocHasPrftbltySgmt : boolean AS virtualSettlmtDocHasPrftbltySgmtboolean,
  virtual UICT_FldGrpIntercompanyTax : boolean AS virtualUICT_FldGrpIntercompanyTaxboolean,
  virtual UICT_FldGrpVolWeightPnt : boolean AS virtualUICT_FldGrpVolWeightPntboolean,
  virtual UICT_ProfitabilitySegment : boolean AS virtualUICT_ProfitabilitySegmentboolean
FROM R_SettlmtDocItemTP
;

Learn More