I_LegalDocumentTP

DDL: I_LEGALDOCUMENTTP Type: view_entity TRANSACTIONAL

Legal Document - TP

I_LegalDocumentTP is a Transactional CDS View that provides data about "Legal Document - TP" in SAP S/4HANA. It reads from 1 data source (R_LegalDocumentTP) and exposes 38 fields with key field LglCntntMDocumentUUID.

Data Sources (1)

SourceAliasJoin Type
R_LegalDocumentTP R_LegalDocumentTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Legal Document - TP view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name LegalDocument view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMDocumentUUID LegalDocument LglCntntMDocumentUUID Universal Unique ID
LglCntntMDocument LegalDocument LglCntntMDocument Document ID
LglCntntMDocumentLinkedObject LegalDocument LglCntntMDocumentLinkedObject Object
LglCntntMDocumentLinkedObjKey LegalDocument LglCntntMDocumentLinkedObjKey UUID Char32
LegalTransaction LegalDocument LegalTransaction Legal Transaction ID
LegalTransactionUUID LegalDocument LegalTransactionUUID Universal Unique ID
LglCntntMDocContentType LegalDocument LglCntntMDocContentType Content Type
LglCntntMLanguage LegalDocument LglCntntMLanguage Language
DocumentDescription LegalDocument DocumentDescription Doc. Name
LglCntntMDocAccessLvl LegalDocument LglCntntMDocAccessLvl Acs. Level
LglCntntMDocPaperType LegalDocument LglCntntMDocPaperType Paper Type
LegalDocumentSource LegalDocument LegalDocumentSource Legal Doc Source
LglCntntMChangedUTCDateTime LegalDocument LglCntntMChangedUTCDateTime Changed On
LglCntntMChangedByUser LegalDocument LglCntntMChangedByUser Changed By
LglCntntMCreatedUTCDateTime LegalDocument LglCntntMCreatedUTCDateTime Created On
LglCntntMCreatedByUser LegalDocument LglCntntMCreatedByUser Created By
InternalDocumentStatus LegalDocument InternalDocumentStatus Status
LglCntntMDocumentIsTopVersion LegalDocument LglCntntMDocumentIsTopVersion TRUE
LglCntntMVirtualDocVersKey LegalDocument LglCntntMVirtualDocVersKey Virtual Doc Version
LglCntntMDocAssemblyStatus LegalDocument LglCntntMDocAssemblyStatus Assembly Status
LglCntntMTmplID LegalDocument LglCntntMTmplID Template ID
LglCntntMDocType LegalDocument LglCntntMDocType Document Type
LglCntntMDocLowTouchLevel LegalDocument LglCntntMDocLowTouchLevel Doc Low touch level
LglCntntMIsMandatory LegalDocument LglCntntMIsMandatory Is Mandatory
LegalDocumentVersion LegalDocument LegalDocumentVersion Docu. Version
LglCntntMParentDocument LegalDocument LglCntntMParentDocument Parent Document ID
LglCntntMDocumentKind LegalDocument LglCntntMDocumentKind Document Kind
LglCntntMDocAmendmentType LglCntntMDocAmendmentType Amendment Type
LglCntntMDocEffectiveFromDate LglCntntMDocEffectiveFromDate Effective From
LglCntntMDocEffectiveToDate LglCntntMDocEffectiveToDate
LglCntntMSgntrPreference LglCntntMSgntrPreference Signature Preference
LglCntntMMainLinkdObjType LegalDocument LglCntntMMainLinkdObjType Main Linked Obj Type
IsEndOfPurposeBlocked LegalDocument IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
LglCntntMProfile LegalDocument LglCntntMProfile Profile
LglTransAccessLvl LegalDocument LglTransAccessLvl Acs. Level
LglCntntMMainOrgCoCode LegalDocument LglCntntMMainOrgCoCode Entity ID
LglCntntMMainOrgPurOrg LegalDocument LglCntntMMainOrgPurOrg Entity ID
LglCntntMMainOrgSalesOrg LegalDocument LglCntntMMainOrgSalesOrg Entity ID

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_LegalDocumentTP.
-- 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_LegalDocumentTP AS
SELECT
  LegalDocument.LglCntntMDocumentUUID AS LglCntntMDocumentUUID,
  LegalDocument.LglCntntMDocument AS LglCntntMDocument,
  LegalDocument.LglCntntMDocumentLinkedObject AS LglCntntMDocumentLinkedObject,
  LegalDocument.LglCntntMDocumentLinkedObjKey AS LglCntntMDocumentLinkedObjKey,
  LegalDocument.LegalTransaction AS LegalTransaction,
  LegalDocument.LegalTransactionUUID AS LegalTransactionUUID,
  LegalDocument.LglCntntMDocContentType AS LglCntntMDocContentType,
  LegalDocument.LglCntntMLanguage AS LglCntntMLanguage,
  LegalDocument.DocumentDescription AS DocumentDescription,
  LegalDocument.LglCntntMDocAccessLvl AS LglCntntMDocAccessLvl,
  LegalDocument.LglCntntMDocPaperType AS LglCntntMDocPaperType,
  LegalDocument.LegalDocumentSource AS LegalDocumentSource,
  LegalDocument.LglCntntMChangedUTCDateTime AS LglCntntMChangedUTCDateTime,
  LegalDocument.LglCntntMChangedByUser AS LglCntntMChangedByUser,
  LegalDocument.LglCntntMCreatedUTCDateTime AS LglCntntMCreatedUTCDateTime,
  LegalDocument.LglCntntMCreatedByUser AS LglCntntMCreatedByUser,
  LegalDocument.InternalDocumentStatus AS InternalDocumentStatus,
  LegalDocument.LglCntntMDocumentIsTopVersion AS LglCntntMDocumentIsTopVersion,
  LegalDocument.LglCntntMVirtualDocVersKey AS LglCntntMVirtualDocVersKey,
  LegalDocument.LglCntntMDocAssemblyStatus AS LglCntntMDocAssemblyStatus,
  LegalDocument.LglCntntMTmplID AS LglCntntMTmplID,
  LegalDocument.LglCntntMDocType AS LglCntntMDocType,
  LegalDocument.LglCntntMDocLowTouchLevel AS LglCntntMDocLowTouchLevel,
  LegalDocument.LglCntntMIsMandatory AS LglCntntMIsMandatory,
  LegalDocument.LegalDocumentVersion AS LegalDocumentVersion,
  LegalDocument.LglCntntMParentDocument AS LglCntntMParentDocument,
  LegalDocument.LglCntntMDocumentKind AS LglCntntMDocumentKind,
  LglCntntMDocAmendmentType,
  LglCntntMDocEffectiveFromDate,
  LglCntntMDocEffectiveToDate,
  LglCntntMSgntrPreference,
  LegalDocument.LglCntntMMainLinkdObjType AS LglCntntMMainLinkdObjType,
  LegalDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  LegalDocument.LglCntntMProfile AS LglCntntMProfile,
  LegalDocument.LglTransAccessLvl AS LglTransAccessLvl,
  LegalDocument.LglCntntMMainOrgCoCode AS LglCntntMMainOrgCoCode,
  LegalDocument.LglCntntMMainOrgPurOrg AS LglCntntMMainOrgPurOrg,
  LegalDocument.LglCntntMMainOrgSalesOrg AS LglCntntMMainOrgSalesOrg
FROM R_LegalDocumentTP
;