I_SetlMgmtItmTxtDetnProced

DDL: I_SETLMGMTITMTXTDETNPROCED Type: view BASIC

Text Determination Procedure for Item

I_SetlMgmtItmTxtDetnProced is a Basic CDS View that provides data about "Text Determination Procedure for Item" in SAP S/4HANA. It reads from 1 data source (ttxg) and exposes 3 fields with key field SettlmtItmTxtDetnProced. It has 2 associations to related views.

SAP Help Documentation

CategorySettlement Management Document
StatusReleased
Purpose
This CDS view provides access to the list of Text Determination Procedures which can be assigned to Settlement Document Types and which can be used on item level for Settlement Management Documents. This CDS view provides the prerequisites for answering the following business question: How many possible Text Determination Procedures are defined for item level?

Prerequisites
This CDS view has restricted access. It can be only reached through the association from Settlement Document Type or the Text Object Type Assignment for Item. For the prerequisites on the Settlement Document Type, refer to Settlement Document Type . Furthermore, refer to Text Object Type Assignment for Item .

Structure
Measures and attributes One important measure and attribute is:: Settlement Item Text Determination Procedure ( SettlmtItmTxtDetnProced )

View on SAP Help Portal →

Data Sources (1)

SourceAliasJoin Type
ttxg ttxg from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_SetlMgmtItmTxtDetnProcedT _Text $projection.SettlmtItmTxtDetnProced = _Text.SettlmtItmTxtDetnProced
[0..*] I_SetlMgmtItmTxtObjTypeAssgmt _SetlMgmtItmTxtObjTypeAssgmt $projection.SettlmtItmTxtDetnProced = _SetlMgmtItmTxtObjTypeAssgmt.SettlmtItmTxtDetnProced

Annotations (22)

NameValueLevelField
AbapCatalog.sqlViewName IWLFITMTXTDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #SINGLE view
AbapCatalog.buffering.numberOfKeyFields 001 view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.representativeKey SettlmtItmTxtDetnProced view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataExtraction.enabled false view
Analytics.internalName #LOCAL view
EndUserText.label Text Determination Procedure for Item view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions false view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SettlmtItmTxtDetnProced TextDetermProc.
_Text _Text
_SetlMgmtItmTxtObjTypeAssgmt _SetlMgmtItmTxtObjTypeAssgmt

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_SetlMgmtItmTxtDetnProced.
-- 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 I_SetlMgmtItmTxtDetnProced AS
SELECT
  cast (txtgr as txtgr_i preserving type ) AS SettlmtItmTxtDetnProced
FROM ttxg
LEFT OUTER JOIN I_SetlMgmtItmTxtDetnProcedT AS _Text ON SettlmtItmTxtDetnProced = _Text.SettlmtItmTxtDetnProced  -- association [0..*]
LEFT OUTER JOIN I_SetlMgmtItmTxtObjTypeAssgmt AS _SetlMgmtItmTxtObjTypeAssgmt ON SettlmtItmTxtDetnProced = _SetlMgmtItmTxtObjTypeAssgmt.SettlmtItmTxtDetnProced  -- association [0..*]
;