A_LegalDocument_C0869

DDL: A_LEGALDOCUMENT_C0869 Type: view_entity CONSUMPTION

Legal Document

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

Data Sources (1)

SourceAliasJoin Type
R_LegalDocumentTP R_LegalDocumentTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_LegalSupportDocument_C0869 _LegalSupportDocument $projection.LglCntntMDocument = _LegalSupportDocument.LglCntntMParentDocument

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Legal Document view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name LegalDocument view
OData.entityType.name LegalDocument_Type view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMDocumentUUID LglCntntMDocumentUUID Universal Unique ID
LglCntntMDocument LglCntntMDocument Document ID
LglCntntMDocumentLinkedObject LglCntntMDocumentLinkedObject Object
LglCntntMDocumentLinkedObjKey LglCntntMDocumentLinkedObjKey UUID Char32
LegalTransaction LegalTransaction Legal Transaction ID
LegalTransactionUUID LegalTransactionUUID Universal Unique ID
LglCntntMDocContentType LglCntntMDocContentType Content Type
LglCntntMLanguage LglCntntMLanguage Language
DocumentDescription DocumentDescription Doc. Name
LglCntntMDocAccessLvl LglCntntMDocAccessLvl Acs. Level
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
InternalDocumentStatus InternalDocumentStatus Status
LglCntntMDocPaperType LglCntntMDocPaperType Paper Type
LglCntntMProfile LglCntntMProfile Profile
LglTransAccessLvl LglTransAccessLvl Acs. Level
LglCntntMDocumentIsTopVersion LglCntntMDocumentIsTopVersion TRUE
LglCntntMParentDocument LglCntntMParentDocument Parent Document ID
LglCntntMIsMandatory LglCntntMIsMandatory Is Mandatory
LegalDocumentVersion LegalDocumentVersion Docu. Version
LglCntntMMainOrgCoCode LglCntntMMainOrgCoCode Entity ID
LglCntntMMainOrgPurOrg LglCntntMMainOrgPurOrg Entity ID
LglCntntMMainOrgSalesOrg LglCntntMMainOrgSalesOrg Entity ID
_LegalSupportDocument _LegalSupportDocument

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 A_LegalDocument_C0869.
-- 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 A_LegalDocument_C0869 AS
SELECT
  LglCntntMDocumentUUID,
  LglCntntMDocument,
  LglCntntMDocumentLinkedObject,
  LglCntntMDocumentLinkedObjKey,
  LegalTransaction,
  LegalTransactionUUID,
  LglCntntMDocContentType,
  LglCntntMLanguage,
  DocumentDescription,
  LglCntntMDocAccessLvl,
  IsEndOfPurposeBlocked,
  InternalDocumentStatus,
  LglCntntMDocPaperType,
  LglCntntMProfile,
  LglTransAccessLvl,
  LglCntntMDocumentIsTopVersion,
  LglCntntMParentDocument,
  LglCntntMIsMandatory,
  LegalDocumentVersion,
  LglCntntMMainOrgCoCode,
  LglCntntMMainOrgPurOrg,
  LglCntntMMainOrgSalesOrg
FROM R_LegalDocumentTP
LEFT OUTER JOIN A_LegalSupportDocument_C0869 AS _LegalSupportDocument ON LglCntntMDocument = _LegalSupportDocument.LglCntntMParentDocument  -- association [0..*]
;