C_EquipMaterialSerialNumberVH

DDL: C_EQUIPMATERIALSERIALNUMBERVH Type: view_entity CONSUMPTION Package: VDM_EAM_EQUIPMENT
17 Fields 1 Data Sources 1 OData Services

Consumption of Equipment

C_EquipMaterialSerialNumberVH is a Consumption CDS View that provides data about "Consumption of Equipment" in SAP S/4HANA. It reads from 1 data source (I_EquipMaterialSerialNumberVH) and exposes 17 fields with key field Equipment. It is exposed through 1 OData service (ASQL_F6879). Part of development package VDM_EAM_EQUIPMENT.

Data Sources (1)

SourceAliasJoin Type
I_EquipMaterialSerialNumberVH I_EquipMaterialSerialNumberVH from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey Equipment view
EndUserText.label Consumption of Equipment view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F6879 ASQL_F6879 C2 NOT_RELEASED

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment Equipment check
EquipmentName EquipmentName Tech. Obj. Desc
EquipmentCategory EquipmentCategory EquipCategory
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerName BusinessPartnerName Extracted Customer Name
Material Material Vehicle Model
MaterialName MaterialName Material Description
SerialNumber SerialNumber Serial Number
AuthorizationGroup AuthorizationGroup AuthorizGroup
Customer Customer Sold-to Party
Supplier Supplier Supplier
HasEquipmentData HasEquipmentData
_Customer _Customer
_EquipmentText _EquipmentText
_Material _Material
_SoldToParty _SoldToParty
_Supplier _Supplier

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_EquipMaterialSerialNumberVH.
-- 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_EquipMaterialSerialNumberVH AS
SELECT
  Equipment,
  EquipmentName,
  EquipmentCategory,
  BusinessPartner,
  BusinessPartnerName,
  Material,
  MaterialName,
  SerialNumber,
  AuthorizationGroup,
  Customer,
  Supplier,
  HasEquipmentData
FROM I_EquipMaterialSerialNumberVH
;

Learn More