C_FrcElmntOrgMasterEquipVH

DDL: C_FRCELMNTORGMASTEREQUIPVH SQL: CMASTEREQUIPVH Type: view CONSUMPTION
13 Fields 1 Data Sources

Value help for Master Equipment

C_FrcElmntOrgMasterEquipVH is a Consumption CDS View that provides data about "Value help for Master Equipment" in SAP S/4HANA. It reads from 1 data source (I_FrcElmntOrgMasterEquipment) and exposes 13 fields with key field Equipment.

Data Sources (1)

SourceAliasJoin Type
I_FrcElmntOrgMasterEquipment _FrcElmntOrgMasterEquip from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CMASTEREQUIPVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view
Consumption.ranked true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Value help for Master Equipment view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_FrcElmntOrgMasterEquipment Equipment Equipment
FrcElmntOrgTailNumber I_FrcElmntOrgMasterEquipment FrcElmntOrgTailNumber Tail ID
FrcElmntOrgModelIdn I_FrcElmntOrgMasterEquipment FrcElmntOrgModelIdn
FrcElmntOrgRemarkText I_FrcElmntOrgMasterEquipment FrcElmntOrgRemarkText
FrcElmntOrgSiteID I_FrcElmntOrgMasterEquipment FrcElmntOrgSiteID
FrcElmntOrgActualConfign I_FrcElmntOrgMasterEquipment FrcElmntOrgActualConfign
FrcElmntOrgEquipType I_FrcElmntOrgMasterEquipment FrcElmntOrgEquipType
EquipmentCategory I_FrcElmntOrgMasterEquipment EquipmentCategory EquipCategory
StorageLocation I_FrcElmntOrgMasterEquipment StorageLocation Storage Location
Plant I_FrcElmntOrgMasterEquipment Plant Plant
EquipmentName I_FrcElmntOrgMasterEquipment EquipmentName Equipment Name
EquipmentHasLongText I_FrcElmntOrgMasterEquipment EquipmentHasLongText
Language I_FrcElmntOrgMasterEquipment Language Report Text Language

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_FrcElmntOrgMasterEquipVH.
-- 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: CMASTEREQUIPVH

CREATE VIEW C_FrcElmntOrgMasterEquipVH AS
SELECT
  _FrcElmntOrgMasterEquip.Equipment AS Equipment,
  _FrcElmntOrgMasterEquip.FrcElmntOrgTailNumber AS FrcElmntOrgTailNumber,
  _FrcElmntOrgMasterEquip.FrcElmntOrgModelIdn AS FrcElmntOrgModelIdn,
  _FrcElmntOrgMasterEquip.FrcElmntOrgRemarkText AS FrcElmntOrgRemarkText,
  _FrcElmntOrgMasterEquip.FrcElmntOrgSiteID AS FrcElmntOrgSiteID,
  _FrcElmntOrgMasterEquip.FrcElmntOrgActualConfign AS FrcElmntOrgActualConfign,
  _FrcElmntOrgMasterEquip.FrcElmntOrgEquipType AS FrcElmntOrgEquipType,
  _FrcElmntOrgMasterEquip.EquipmentCategory AS EquipmentCategory,
  _FrcElmntOrgMasterEquip.StorageLocation AS StorageLocation,
  _FrcElmntOrgMasterEquip.Plant AS Plant,
  _FrcElmntOrgMasterEquip.EquipmentName AS EquipmentName,
  _FrcElmntOrgMasterEquip.EquipmentHasLongText AS EquipmentHasLongText,
  _FrcElmntOrgMasterEquip.Language AS Language
FROM I_FrcElmntOrgMasterEquipment AS _FrcElmntOrgMasterEquip
;

Learn More