C_SlsDocItmCatTxtDetnItmVH

DDL: C_SLSDOCITMCATTXTDETNITMVH Type: view CONSUMPTION Package: ODATA_SD_S4H_COMMON
6 Fields 2 Data Sources 1 OData Services

Text Detn Proced Items by Item category

C_SlsDocItmCatTxtDetnItmVH is a Consumption CDS View that provides data about "Text Detn Proced Items by Item category" in SAP S/4HANA. It reads from 2 data sources (I_SalesDocumentItemCategory, I_TextDeterminationProcedItem) and exposes 6 fields with key fields SalesDocumentItemCategory, TextDeterminationProcedure, TextDeterminationProcedObject, TextDeterminationProcedureItem, LongTextID. It is exposed through 1 OData service (ASQL_F5987). Part of development package ODATA_SD_S4H_COMMON.

Data Sources (2)

SourceAliasJoin Type
I_SalesDocumentItemCategory SalesDocumentItemCategory from
I_TextDeterminationProcedItem TextDeterminationItem inner

Annotations (16)

NameValueLevelField
EndUserText.label Text Detn Proced Items by Item category view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CSDITMTXTDETNITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Consumption.valueHelpDefault.fetchValues #AUTOMATICALLY_WHEN_DISPLAYED view
Consumption.ranked true view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.representativeKey LongTextID view
AccessControl.authorizationCheck #NOT_REQUIRED view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F5987 ASQL_F5987 C2 NOT_RELEASED

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SalesDocumentItemCategory I_SalesDocumentItemCategory SalesDocumentItemCategory Item Category
KEY TextDeterminationProcedure I_SalesDocumentItemCategory TextDeterminationProcedure TextDetermProc.
KEY TextDeterminationProcedObject
KEY TextDeterminationProcedureItem I_TextDeterminationProcedItem TextDeterminationProcedureItem SeqNo-textIDGr
KEY LongTextID I_TextDeterminationProcedItem LongTextID Text ID
LongTextIDText

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_SlsDocItmCatTxtDetnItmVH.
-- 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_SlsDocItmCatTxtDetnItmVH AS
SELECT
  SalesDocumentItemCategory.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  SalesDocumentItemCategory.TextDeterminationProcedure AS TextDeterminationProcedure,
  SalesDocumentItemCategory._TextDeterminationProcedure.TextDeterminationProcedObject AS TextDeterminationProcedObject,
  TextDeterminationItem.TextDeterminationProcedureItem AS TextDeterminationProcedureItem,
  TextDeterminationItem.LongTextID AS LongTextID,
  TextDeterminationItem._LongTextID._TextObjectTypeText[1: Language=$session.system_language].TextObjectTypeName AS LongTextIDText
FROM I_SalesDocumentItemCategory AS SalesDocumentItemCategory
INNER JOIN I_TextDeterminationProcedItem AS TextDeterminationItem ON /* join condition not captured in parsed metadata */
;

Learn More