C_ProdCmplncLglEntityMappgHist

DDL: C_PRODCMPLNCLGLENTITYMAPPGHIST SQL: CLEMHISTORY Type: view CONSUMPTION
15 Fields 1 Data Sources

Version History of Legal Entity Mappings

C_ProdCmplncLglEntityMappgHist is a Consumption CDS View that provides data about "Version History of Legal Entity Mappings" in SAP S/4HANA. It reads from 1 data source (I_ProdCmplncLglEntityMappingTP) and exposes 15 fields with key field ProdCmplncLglEntyMappgUUID.

Data Sources (1)

SourceAliasJoin Type
I_ProdCmplncLglEntityMappingTP I_ProdCmplncLglEntityMappingTP from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CLEMHISTORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Version History of Legal Entity Mappings view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncLglEntyMappgUUID ProdCmplncLglEntyMappgUUID LE Mapping UUID
CmplRqUUID CmplRqUUID Compl Req.
ProdCmplncLegalEntityUUID ProdCmplncLegalEntityUUID Legal Entity UUID
ProductionPlant ProductionPlant Prod plnt
ProductionCompanyCode ProductionCompanyCode Prodn Co Code
ReceivingCompanyCode ReceivingCompanyCode Rcvg Co Code
ReceivingPlant ReceivingPlant Receiving Plant
SellingCompanyCode SellingCompanyCode Selling Company Code
SellingPlant SellingPlant Selling Plant
SVTBusinessProcessScenario SVTBusinessProcessScenario Scenario
ProdCmplncLegalEntity _ProdCmplncLegalEntity ProdCmplncLegalEntity
ProdCmplncLegalEntityDesc _ProdCmplncLegalEntity ProdCmplncLegalEntityDesc
PCLglEntyMappgValidFromDate PCLglEntyMappgValidFromDate
PCLglEntyMappgValidToDate PCLglEntyMappgValidToDate
ComplianceRequirement ComplianceRequirement Compliance Requirement

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_ProdCmplncLglEntityMappgHist.
-- 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: CLEMHISTORY

CREATE VIEW C_ProdCmplncLglEntityMappgHist AS
SELECT
  ProdCmplncLglEntyMappgUUID,
  CmplRqUUID,
  ProdCmplncLegalEntityUUID,
  ProductionPlant,
  ProductionCompanyCode,
  ReceivingCompanyCode,
  ReceivingPlant,
  SellingCompanyCode,
  SellingPlant,
  SVTBusinessProcessScenario,
  _ProdCmplncLegalEntity.ProdCmplncLegalEntity AS ProdCmplncLegalEntity,
  _ProdCmplncLegalEntity.ProdCmplncLegalEntityDesc AS ProdCmplncLegalEntityDesc,
  PCLglEntyMappgValidFromDate,
  PCLglEntyMappgValidToDate,
  ComplianceRequirement
FROM I_ProdCmplncLglEntityMappingTP
;

Learn More