C_LCMContextEntityTP

DDL: C_LCMCONTEXTENTITYTP Type: view_entity CONSUMPTION

LCM Context Entity

C_LCMContextEntityTP is a Consumption CDS View that provides data about "LCM Context Entity" in SAP S/4HANA. It reads from 1 data source (I_LCMContextEntityTP) and exposes 33 fields with key field LglCntntMCntxtEntityUUID.

Data Sources (1)

SourceAliasJoin Type
I_LCMContextEntityTP I_LCMContextEntityTP projection

Annotations (9)

NameValueLevelField
EndUserText.label LCM Context Entity view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY LglCntntMCntxtEntityUUID LglCntntMCntxtEntityUUID Universal Unique ID
LglCntntMContextUUID LglCntntMContextUUID Universal Unique ID
LglCntntMRank LglCntntMRank Seq No
LglCntntMEntityType LglCntntMEntityType Entity Type
LglCntntMTechEntityType LglCntntMTechEntityType Entity Techn. Type
LglCntntMEntity LglCntntMEntity Entity ID
LglCntntMEntityName _LCMContextEntityAggr LglCntntMEntityName
LglCntntMIsMandatory LglCntntMIsMandatory Is Mandatory
LglCntntMIsMainEntity LglCntntMIsMainEntity Main Entity
LglCntntMIsIntegRelevant LglCntntMIsIntegRelevant Integrated
LglCntntMSupplierFirstName _LCMContextEntityAggr LglCntntMSupplierFirstName
LglCntntMSupplierLastName _LCMContextEntityAggr LglCntntMSupplierLastName
LglCntntMSupplierOrgFirstName _LCMContextEntityAggr LglCntntMSupplierOrgFirstName
LglCntntMSupplierOrgSecondName _LCMContextEntityAggr LglCntntMSupplierOrgSecondName
LglCntntMSupplierGrpFirstName _LCMContextEntityAggr LglCntntMSupplierGrpFirstName
LglCntntMSupplierGrpSecondName _LCMContextEntityAggr LglCntntMSupplierGrpSecondName
LglCntntMCustomerFirstName _LCMContextEntityAggr LglCntntMCustomerFirstName
LglCntntMCustomerSecondName _LCMContextEntityAggr LglCntntMCustomerSecondName
LglCntntMCustomerOrgFirstName _LCMContextEntityAggr LglCntntMCustomerOrgFirstName
LglCntntMCustomerOrgSecondName _LCMContextEntityAggr LglCntntMCustomerOrgSecondName
LglCntntMCustomerGrpFirstName _LCMContextEntityAggr LglCntntMCustomerGrpFirstName
LglCntntMCustomerGrpSecondName _LCMContextEntityAggr LglCntntMCustomerGrpSecondName
FirstName _LCMContextEntityAggr FirstName First Name
LastName _LCMContextEntityAggr LastName Last Name
OrganizationBPName1 _LCMContextEntityAggr OrganizationBPName1 Name 1
OrganizationBPName2 _LCMContextEntityAggr OrganizationBPName2 Name 2
GroupBusinessPartnerName1 _LCMContextEntityAggr GroupBusinessPartnerName1 Name 1
GroupBusinessPartnerName2 _LCMContextEntityAggr GroupBusinessPartnerName2 Name 2
CompanyCodeName _LCMContextEntityAggr CompanyCodeName Company Name
SalesOrganizationName _LCMContextEntityAggr SalesOrganizationName Sales Organization Description
PurchasingOrganizationName _LCMContextEntityAggr PurchasingOrganizationName Purch. Org. Name
_LglCntntMContext _LglCntntMContext
LglCntntMEntityTypeNamelocalized

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_LCMContextEntityTP.
-- 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 C_LCMContextEntityTP AS
SELECT
  LglCntntMCntxtEntityUUID,
  LglCntntMContextUUID,
  LglCntntMRank,
  LglCntntMEntityType,
  LglCntntMTechEntityType,
  LglCntntMEntity,
  _LCMContextEntityAggr.LglCntntMEntityName AS LglCntntMEntityName,
  LglCntntMIsMandatory,
  LglCntntMIsMainEntity,
  LglCntntMIsIntegRelevant,
  _LCMContextEntityAggr.LglCntntMSupplierFirstName AS LglCntntMSupplierFirstName,
  _LCMContextEntityAggr.LglCntntMSupplierLastName AS LglCntntMSupplierLastName,
  _LCMContextEntityAggr.LglCntntMSupplierOrgFirstName AS LglCntntMSupplierOrgFirstName,
  _LCMContextEntityAggr.LglCntntMSupplierOrgSecondName AS LglCntntMSupplierOrgSecondName,
  _LCMContextEntityAggr.LglCntntMSupplierGrpFirstName AS LglCntntMSupplierGrpFirstName,
  _LCMContextEntityAggr.LglCntntMSupplierGrpSecondName AS LglCntntMSupplierGrpSecondName,
  _LCMContextEntityAggr.LglCntntMCustomerFirstName AS LglCntntMCustomerFirstName,
  _LCMContextEntityAggr.LglCntntMCustomerSecondName AS LglCntntMCustomerSecondName,
  _LCMContextEntityAggr.LglCntntMCustomerOrgFirstName AS LglCntntMCustomerOrgFirstName,
  _LCMContextEntityAggr.LglCntntMCustomerOrgSecondName AS LglCntntMCustomerOrgSecondName,
  _LCMContextEntityAggr.LglCntntMCustomerGrpFirstName AS LglCntntMCustomerGrpFirstName,
  _LCMContextEntityAggr.LglCntntMCustomerGrpSecondName AS LglCntntMCustomerGrpSecondName,
  _LCMContextEntityAggr.FirstName AS FirstName,
  _LCMContextEntityAggr.LastName AS LastName,
  _LCMContextEntityAggr.OrganizationBPName1 AS OrganizationBPName1,
  _LCMContextEntityAggr.OrganizationBPName2 AS OrganizationBPName2,
  _LCMContextEntityAggr.GroupBusinessPartnerName1 AS GroupBusinessPartnerName1,
  _LCMContextEntityAggr.GroupBusinessPartnerName2 AS GroupBusinessPartnerName2,
  _LCMContextEntityAggr.CompanyCodeName AS CompanyCodeName,
  _LCMContextEntityAggr.SalesOrganizationName AS SalesOrganizationName,
  _LCMContextEntityAggr.PurchasingOrganizationName AS PurchasingOrganizationName,
  _LCMEntityTypeText.LglCntntMEntityTypeName : localized AS LglCntntMEntityTypeNamelocalized
FROM I_LCMContextEntityTP
;