C_LegalTransactionPhseDocType

DDL: C_LEGALTRANSACTIONPHSEDOCTYPE SQL: CLCMLTPHDOCTYPE Type: view CONSUMPTION Package: ODATA_LCM_LT

Document Cntnt Type in Phase for Legal Transaction

C_LegalTransactionPhseDocType is a Consumption CDS View that provides data about "Document Cntnt Type in Phase for Legal Transaction" in SAP S/4HANA. It reads from 1 data source (I_LegalTransactionPhseDocType) and exposes 8 fields with key field LglCntntMPhaseCntntTypeUUID. It has 1 association to related views. Part of development package ODATA_LCM_LT.

Data Sources (1)

SourceAliasJoin Type
I_LegalTransactionPhseDocType I_LegalTransactionPhseDocType from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_LCMLegalTrDocument _LCMLegalTrDocument $projection.LglCntntMDocument = _LCMLegalTrDocument.LegalDocument and _LCMLegalTrDocument.LglCntntMDocumentIsTopVersion = 'X'

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CLCMLTPHDOCTYPE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
AbapCatalog.preserveKey true view
ObjectModel.semanticKey LglCntntMPhaseDocUUID view
ObjectModel.representativeKey LglCntntMPhaseCntntTypeUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
UI.headerInfo.typeName Phase Documet Type view
UI.headerInfo.typeNamePlural Phases Documnet Typess view
UI.headerInfo.title.value LglCntntMPhaseCntntTypeUUID view
UI.headerInfo.description.value LglCntntMPhaseCntntTypeUUID view
EndUserText.label Document Cntnt Type in Phase for Legal Transaction view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMPhaseCntntTypeUUID LglCntntMPhaseCntntTypeUUID Universal Unique ID
LglCntntMPhaseDocUUID LglCntntMPhaseDocUUID Universal Unique ID
LegalTransactionUUID LegalTransactionUUID Universal Unique ID
LglCntntMCntxtDocumentID LglCntntMCntxtDocumentID Context Document ID
LglCntntMDocument LglCntntMDocument Document ID
DocumentDescription _LCMLegalTrDocument DocumentDescription Title
_LCMLegalTrDocument _LCMLegalTrDocument
_LegalTransaction _LegalTransaction

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_LegalTransactionPhseDocType.
-- 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: CLCMLTPHDOCTYPE

CREATE VIEW C_LegalTransactionPhseDocType AS
SELECT
  LglCntntMPhaseCntntTypeUUID,
  LglCntntMPhaseDocUUID,
  LegalTransactionUUID,
  LglCntntMCntxtDocumentID,
  LglCntntMDocument,
  _LCMLegalTrDocument.DocumentDescription AS DocumentDescription
FROM I_LegalTransactionPhseDocType
LEFT OUTER JOIN C_LCMLegalTrDocument AS _LCMLegalTrDocument ON LglCntntMDocument = _LCMLegalTrDocument.LegalDocument AND _LCMLegalTrDocument.LglCntntMDocumentIsTopVersion = 'X'  -- association [1..1]
;