C_LegalDocumentStampQuery

DDL: C_LEGALDOCUMENTSTAMPQUERY SQL: CLCMSTMPQUERY Type: view CONSUMPTION
10 Fields 1 Data Sources

Legal Document Stamp - Query

C_LegalDocumentStampQuery (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Sourcing & Procurement

C_LegalDocumentStampQuery is a Consumption CDS View that provides data about "Legal Document Stamp - Query" in SAP S/4HANA. It reads from 1 data source (C_LegalDocumentStampCube) and exposes 10 fields with key field LglCntntMDocumentStampUUID.

SAP Help Documentation

CategoryCDS Views for Enterprise Contract Management
Corresponding DataSourceFor CDS views that have the annotation ANALYTICS.QUERY = true , enter the corresponding technical name of the analytical DataSource here. This name is 2C<value of annotation ABAPCATALOG.SQLVIEWNAME> , for example 2CCLCMPLGLSTMP for CDS view C_LegalDocumentStampQuery
Purpose
This CDS view provides the data to answer the following business questions: What is the total number of legal documents with stamps? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object: LCM_DOC activity ‘03’ (Legal Document Activity '03')

Structure
Further Important Fields Important fields in this view include the following: Field Name Description LGLCNTNTMDOCUMENT Legal Document LGLCNTNTMDOCUMENTSTAMP Document Stamp LGLCNTNTMDOCUMENTSTAMPNAME Document Stamp Name LEGALTRANSACTIONHEALTHNAME Health LGLCNTNTMENTITY Main Entity LGLCNTNTMENTITYTYPENAME Main Entity Name LGLCNTNTMGOVLAWTEXT Governing Law

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentCM-GF
CapabilitiesAnalytical Query
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view ...</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>&lt;Business question&gt;</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

Documentation

Data Sources (1)

SourceAliasJoin Type
C_LegalDocumentStampCube C_LegalDocumentStampCube from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CLCMSTMPQUERY view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
Analytics.query true view
OData.publish true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Legal Document Stamp - Query view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #ANALYTICAL_QUERY view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMDocumentStampUUID LglCntntMDocumentStampUUID Universal Unique Identifier
LglCntntMDocument LglCntntMDocument Document ID
LglCntntMDocumentStampName LglCntntMDocumentStampName Stamp Name
LegalTransactionHealthName LegalTransactionHealthName Status of Legal Transaction
LglCntntMEntity LglCntntMEntity Main Entity
LglCntntMEntityTypeName LglCntntMEntityTypeName Main Entity Type
LglCntntMGovLawText LglCntntMGovLawText Governing Law Text
LglCntntMMainOrgName LglCntntMMainOrgName Name of Company Code or Company
LglCntntMMainOrgTypeName LglCntntMMainOrgTypeName Short Text for Fixed Values
TotalNumberOfLegalDocuments TotalNumberOfLegalDocuments Total No. of Legal Documents

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_LegalDocumentStampQuery.
-- 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: CLCMSTMPQUERY

CREATE VIEW C_LegalDocumentStampQuery AS
SELECT
  LglCntntMDocumentStampUUID,
  LglCntntMDocument,
  LglCntntMDocumentStampName,
  LegalTransactionHealthName,
  LglCntntMEntity,
  LglCntntMEntityTypeName,
  LglCntntMGovLawText,
  LglCntntMMainOrgName,
  LglCntntMMainOrgTypeName,
  TotalNumberOfLegalDocuments
FROM C_LegalDocumentStampCube
;

Learn More