C_LglCntntMDocAgreementTP

DDL: C_LGLCNTNTMDOCAGREEMENTTP SQL: CLGLCNTDOCAGRMTP Type: view CONSUMPTION
19 Fields 1 Data Sources 1 Associations

Legal Document Agreeement

C_LglCntntMDocAgreementTP is a Consumption CDS View that provides data about "Legal Document Agreeement" in SAP S/4HANA. It reads from 1 data source (I_LglCntntMDocAgreementTP) and exposes 19 fields with key field LglCntntMAgreementUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_LglCntntMDocAgreementTP I_LglCntntMDocAgreementTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_LCMDocumentTP _DocumentTP $projection.LglCntntMDocumentUUID = _DocumentTP.LglCntntMDocumentUUID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CLGLCNTDOCAGRMTP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey LglCntntMAgreementUUID view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
UI.headerInfo.typeName Agreement view
UI.headerInfo.typeNamePlural Agreements view
UI.headerInfo.title.label Agreement view
EndUserText.label Legal Document Agreeement view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMAgreementUUID LglCntntMAgreementUUID Agreement UUID
LglCntntMDocumentUUID LglCntntMDocumentUUID Universal Unique ID
LglCntntMContractTypeName LglCntntMContractTypeName Contract Type
LglCntntMAgreementTemplateID LglCntntMAgreementTemplateID Agreement Template ID
LglCntntMAgreementSystemID LglCntntMAgreementSystemID System ID
LglCntntMLogHandler Application Log ID
LglCntntMDocAgrmtCoreStatus LglCntntMDocAgrmtCoreStatus Agrmnt. Core Status
LglCntntMDocAgrmtBizStatus LglCntntMDocAgrmtBizStatus Agrmt Bus Status
LglCntntMAgreementTemplateName LglCntntMAgreementTemplateName Agreement Tmpl Name
LglCntntMDocAgrmtVersion LglCntntMDocAgrmtVersion Ext. Version
LglCntntMCreatedUTCDateTime LglCntntMCreatedUTCDateTime Date & Time
LglCntntMCreatedByUser LglCntntMCreatedByUser Created By
LglCntntMChangedUTCDateTime LglCntntMChangedUTCDateTime Changed On
LglCntntMChangedByUser LglCntntMChangedByUser Changed By
LglCntntMAgreementName LglCntntMAgreementName
_ChangedBy _ChangedBy
_CreatedBy _CreatedBy
_DocumentAuth _DocumentAuth
_DocumentTP _DocumentTP

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_LglCntntMDocAgreementTP.
-- 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: CLGLCNTDOCAGRMTP

CREATE VIEW C_LglCntntMDocAgreementTP AS
SELECT
  LglCntntMAgreementUUID,
  LglCntntMDocumentUUID,
  LglCntntMContractTypeName,
  LglCntntMAgreementTemplateID,
  LglCntntMAgreementSystemID,
  cast( LglCntntMLogHandler as char22 preserving type ) AS LglCntntMLogHandler,
  LglCntntMDocAgrmtCoreStatus,
  LglCntntMDocAgrmtBizStatus,
  LglCntntMAgreementTemplateName,
  LglCntntMDocAgrmtVersion,
  LglCntntMCreatedUTCDateTime,
  LglCntntMCreatedByUser,
  LglCntntMChangedUTCDateTime,
  LglCntntMChangedByUser,
  LglCntntMAgreementName
FROM I_LglCntntMDocAgreementTP
LEFT OUTER JOIN C_LCMDocumentTP AS _DocumentTP ON LglCntntMDocumentUUID = _DocumentTP.LglCntntMDocumentUUID  -- association [1..1]
;

Learn More