A_LegalSupportDocument_C0869

DDL: A_LEGALSUPPORTDOCUMENT_C0869 Type: view_entity CONSUMPTION
24 Fields 2 Data Sources 1 Associations

Legal Supporting Document

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

Data Sources (2)

SourceAliasJoin Type
R_LegalDocumentTP LegalDocument from
R_LegalDocumentTP ParentDocument inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] A_LegalDocAgreement_C0869 _LegalDocAgreement $projection.LglCntntMDocumentUUID = _LegalDocAgreement.LglCntntMDocumentUUID

Annotations (11)

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

Fields (24)

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

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_LegalSupportDocument_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_LegalSupportDocument_C0869 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.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  LegalDocument.InternalDocumentStatus AS InternalDocumentStatus,
  LegalDocument.LglCntntMDocPaperType AS LglCntntMDocPaperType,
  LegalDocument.LglCntntMProfile AS LglCntntMProfile,
  LegalDocument.LglTransAccessLvl AS LglTransAccessLvl,
  LegalDocument.LglCntntMDocumentIsTopVersion AS LglCntntMDocumentIsTopVersion,
  LegalDocument.LglCntntMParentDocument AS LglCntntMParentDocument,
  LegalDocument.LglCntntMIsMandatory AS LglCntntMIsMandatory,
  LegalDocument.LegalDocumentVersion AS LegalDocumentVersion,
  cast( '' as lcm_doc_vers_is_with_content ) AS LglCntntMDocVersIsWithContent,
  LegalDocument.LglCntntMMainOrgCoCode AS LglCntntMMainOrgCoCode,
  LegalDocument.LglCntntMMainOrgPurOrg AS LglCntntMMainOrgPurOrg,
  LegalDocument.LglCntntMMainOrgSalesOrg AS LglCntntMMainOrgSalesOrg
FROM R_LegalDocumentTP AS LegalDocument
INNER JOIN R_LegalDocumentTP AS ParentDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN A_LegalDocAgreement_C0869 AS _LegalDocAgreement ON LglCntntMDocumentUUID = _LegalDocAgreement.LglCntntMDocumentUUID  -- association [0..*]
;

Learn More