I_SAFTSettlementManagementItem

DDL: I_SAFTSETTLEMENTMANAGEMENTITEM SQL: ISAFTSMITEM Type: view COMPOSITE

SAF-T Settlement Management Item

I_SAFTSettlementManagementItem is a Composite CDS View that provides data about "SAF-T Settlement Management Item" in SAP S/4HANA. It reads from 1 data source (I_SettlmtMgmtDocItem) and exposes 20 fields with key fields SettlmtMgmtDoc, SettlmtMgmtDocItem.

Data Sources (1)

SourceAliasJoin Type
I_SettlmtMgmtDocItem I_SettlmtMgmtDocItem from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ISAFTSMITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label SAF-T Settlement Management Item view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SettlmtMgmtDoc SettlmtMgmtDoc Document Number
KEY SettlmtMgmtDocItem SettlmtMgmtDocItem Item
SuplrSettlmtCompanyCode SuplrSettlmtCompanyCode Suppl. Company Code
Product Product Product Sold
SettlmtQuantity SettlmtQuantity SettlmtQuantity
SettlmtQuantityUnit SettlmtQuantityUnit Settlement Unit
NetPriceAmount NetPriceAmount Net Price
SettlmtMgmtDocItemText SettlmtMgmtDocItemText Short Text
SupplierItemNetAmount SupplierItemNetAmount Supplier Item Net Amount
SettlmtItemReltdCndnContr SettlmtItemReltdCndnContr ItmRelatedCndnContr
SettlmtItemActivityReason SettlmtItemActivityReason Activity Reason
CustomerTaxCode CustomerTaxCode Customer Tax Code
SettlmtDocCurrency SettlmtDocCurrency Doc. Currency
_SettlmtItemReltdCndnContr _SettlmtItemReltdCndnContr
_Product _Product
_SettlmtMgmtDoc _SettlmtMgmtDoc
_SettlmtItemActivityReason _SettlmtItemActivityReason
_SuplrSettlmtCompanyCode _SuplrSettlmtCompanyCode
_SettlmtQuantityUnit _SettlmtQuantityUnit
_SettlmtDocCurrency _SettlmtDocCurrency

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_SAFTSettlementManagementItem.
-- 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.
-- SQL view name: ISAFTSMITEM

CREATE VIEW I_SAFTSettlementManagementItem AS
SELECT
  SettlmtMgmtDoc,
  SettlmtMgmtDocItem,
  SuplrSettlmtCompanyCode,
  Product,
  SettlmtQuantity,
  SettlmtQuantityUnit,
  NetPriceAmount,
  SettlmtMgmtDocItemText,
  SupplierItemNetAmount,
  SettlmtItemReltdCndnContr,
  SettlmtItemActivityReason,
  CustomerTaxCode,
  SettlmtDocCurrency
FROM I_SettlmtMgmtDocItem
;