C_LegalDocumentStampCube

DDL: C_LEGALDOCUMENTSTAMPCUBE SQL: CLCMPLGLSTMP Type: view CONSUMPTION Package: VDM_LCM_ANALYTICS
12 Fields 2 Data Sources

Legal Doc Stamp Data - Cube

C_LegalDocumentStampCube (Consumption)

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

Sourcing & Procurement

C_LegalDocumentStampCube is a Consumption CDS View (Cube) that provides data about "Legal Doc Stamp Data - Cube" in SAP S/4HANA. It reads from 2 data sources (I_LegalDocument, I_LglCntntMDocumentStamp) and exposes 12 fields with key field LglCntntMDocumentStampUUID. Part of development package VDM_LCM_ANALYTICS.

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_LegalDocumentStampCube
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

CategoryConsumption
StateC1
Line of BusinessSourcing & Procurement
Application ComponentCM-GF-2CL
CapabilitiesData Provider for Analytical Queries
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageSourcing and Procurement for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li> <p>What is the total number of legal documents with stamps?</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 (2)

SourceAliasJoin Type
I_LegalDocument _LegalDocument inner
I_LglCntntMDocumentStamp LglCntntMDocumentStamp from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CLCMPLGLSTMP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Legal Doc Stamp Data - Cube view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
Analytics.internalName #LOCAL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMDocumentStampUUID I_LglCntntMDocumentStamp LglCntntMDocumentStampUUID Universal Unique Identifier
LglCntntMDocumentUUID I_LegalDocument LglCntntMDocumentUUID Universal Unique Identifier
LglCntntMDocument I_LegalDocument LglCntntMDocument Document ID
LglCntntMDocumentStamp I_LglCntntMDocumentStamp LglCntntMDocumentStamp Document Stamp Name
LegalTransactionHealthName Long Text
LglCntntMEntity Entity ID
LglCntntMEntityTypeName Long Text
LglCntntMGovLawText Governing Law Text
LegalTransactionHealth Legal Transaction Status
LglCntntMMainOrgTypeName Short Text for Fixed Values
CompanyCodeNameendasLglCntntMMainOrgName
TotalNumberOfLegalDocuments Total No. of Files

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_LegalDocumentStampCube.
-- 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: CLCMPLGLSTMP

CREATE VIEW C_LegalDocumentStampCube AS
SELECT
  LglCntntMDocumentStamp.LglCntntMDocumentStampUUID AS LglCntntMDocumentStampUUID,
  _LegalDocument.LglCntntMDocumentUUID AS LglCntntMDocumentUUID,
  _LegalDocument.LglCntntMDocument AS LglCntntMDocument,
  LglCntntMDocumentStamp.LglCntntMDocumentStamp AS LglCntntMDocumentStamp,
  _LegalDocument._LegalTransaction._LegalTransactionHealthText.LegalTransactionHealthName AS LegalTransactionHealthName,
  _LegalDocument._LegalTransaction._MainLegalTransactionEntity.LglCntntMEntity AS LglCntntMEntity,
  _LegalDocument._LegalTransaction._MainLegalTransactionEntity.LglCntntMEntityTypeName AS LglCntntMEntityTypeName,
  _LegalDocument._LegalTransaction._LglCntntMGovLawText[1: Language = $session.system_language].LglCntntMGovLawText AS LglCntntMGovLawText,
  _LegalDocument._LegalTransaction.LegalTransactionHealth AS LegalTransactionHealth,
  _LegalDocument._LegalTransaction._LglCntntMMainOrgTypeText.LglCntntMMainOrgTypeName AS LglCntntMMainOrgTypeName,
  case when _LegalDocument._LegalTransaction.LglCntntMMainOrgType = '04' then _LegalDocument._LegalTransaction._SalesOrganizationText.SalesOrganizationName when _LegalDocument._LegalTransaction.LglCntntMMainOrgType = '05' then _LegalDocument._LegalTransaction._PurchasingOrganization.PurchasingOrganizationName else _LegalDocument._LegalTransaction._CompanyCode.CompanyCodeName end as LglCntntMMainOrgName AS CompanyCodeNameendasLglCntntMMainOrgName,
  cast( 1 as lcm_totalld_stamps ) AS TotalNumberOfLegalDocuments
FROM I_LglCntntMDocumentStamp AS LglCntntMDocumentStamp
INNER JOIN I_LegalDocument AS _LegalDocument ON /* join condition not captured in parsed metadata */
;

Learn More