I_SetlMgmtItmTxtDetnProced
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
| Category | Settlement Management Document |
|---|---|
| Status | Released |
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 )
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 )
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| ttxg | ttxg | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_SetlMgmtItmTxtDetnProcedT | _Text | $projection.SettlmtItmTxtDetnProced = _Text.SettlmtItmTxtDetnProced |
| [0..*] | I_SetlMgmtItmTxtObjTypeAssgmt | _SetlMgmtItmTxtObjTypeAssgmt | $projection.SettlmtItmTxtDetnProced = _SetlMgmtItmTxtObjTypeAssgmt.SettlmtItmTxtDetnProced |
Annotations (22)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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..*]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA