C_EquipmentDataDP

DDL: C_EQUIPMENTDATADP Type: view_entity CONSUMPTION Package: VDM_EAM_EQUIPMENT
75 Fields 1 Data Sources 2 Associations 1 OData Services

Equipment DP

C_EquipmentDataDP is a Consumption CDS View that provides data about "Equipment DP" in SAP S/4HANA. It reads from 1 data source (C_EquipmentDataDEX) and exposes 75 fields with key fields Equipment, ValidityEndDate, EquipUsagePeriodSequenceNumber. It has 2 associations to related views. It is exposed through 1 OData service (DP_EQUIPMENT). Part of development package VDM_EAM_EQUIPMENT.

Data Sources (1)

SourceAliasJoin Type
C_EquipmentDataDEX C_EquipmentDataDEX from

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_EquipmentPartnerDP _EquipmentPartner $projection.Equipment = _EquipmentPartner.Equipment
[0..*] C_EquipmentTextDP _Text $projection.Equipment = _Text.Equipment

Annotations (12)

NameValueLevelField
EndUserText.label Equipment DP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.representativeKey Equipment view
ObjectModel.sapObjectNodeType.name Equipment view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
DataIntegration.deltaReplication.intended true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
DP_EQUIPMENT DP_EQUIPMENT C2 NOT_RELEASED

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment Equipment check
KEY ValidityEndDate ValidityEndDate ValidTo
KEY EquipUsagePeriodSequenceNumber EquipUsagePeriodSequenceNumber
ABCIndicator ABCIndicator ABC Indicator
AcquisitionValue AcquisitionValue
AddressID AddressID Ship-to address
MasterFixedAsset MasterFixedAsset Fixed Asset
CompanyCode CompanyCode Receiver Company Code
CostCenter CostCenter Cost Center
ControllingArea ControllingArea Controlling Area
Currency Currency Valuation Crcy
OperationStartDate OperationStartDate
TechnicalObjectType TechnicalObjectType Text object
FunctionalLocation FunctionalLocation Object ID
InventoryNumber InventoryNumber
AssetLocation AssetLocation Location
MaintenancePlant MaintenancePlant Plant
AssetRoom AssetRoom Room
Material Material Vehicle Model
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
PlantSection PlantSection Plant Section
MaintenancePlannerGroup MaintenancePlannerGroup Planner Group
WBSElementExternalID WBSElementExternalID WBS Element External ID
EquipmentCategory EquipmentCategory EquipCategory
CreationDate CreationDate Time Stamp
Plant Plant Valuation Area
MainWorkCenterInternalID MainWorkCenterInternalID Work Center
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
SettlementOrder SettlementOrder SettlementOrder
WorkCenterInternalID WorkCenterInternalID Work Center
WorkCenter WorkCenter Work Center
WorkCenterPlant WorkCenterPlant Plant
LastChangeDateTime LastChangeDateTime Timestamp
EquipmentIsMarkedForDeletion EquipmentIsMarkedForDeletion
NextEquipUsagePeriodSqncNmbr NextEquipUsagePeriodSqncNmbr
MaintObjectLocAcctAssgmtNmbr MaintObjectLocAcctAssgmtNmbr Loc/AccAssmt
WorkCenterTypeCode WorkCenterTypeCode Object Type
CatalogProfile CatalogProfile Catalog Profile
SuperordinateEquipment SuperordinateEquipment
TechnicalObjectSortCode TechnicalObjectSortCode
ConstructionMaterial ConstructionMaterial ConstType
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndTime ValidityEndTime Valid To Time
EquipmentManufacturerPrtNmbr EquipmentManufacturerPrtNmbr Mfr Part Number
Division Division Internal Division ID
StorageLocation StorageLocation StorageLocation
AssetManufacturerName AssetManufacturerName Manufacturer
ManufacturerPartTypeName ManufacturerPartTypeName Model number
ManufacturerCountry ManufacturerCountry Mnf. Cntry/Regn
ConstructionYear ConstructionYear
ConstructionMonth ConstructionMonth
AcquisitionDate AcquisitionDate Date Entered
MaintObjectInternalID MaintObjectInternalID Object number
SerialNumber SerialNumber Serial Number
Customer Customer Sold-to Party
AuthorizationGroup AuthorizationGroup AuthorizGroup
GrossWeight GrossWeight Total Weight
GrossWeightUnit GrossWeightUnit
SizeOrDimensionText SizeOrDimensionText Size/dimensions
Batch Batch Lot No.
Supplier Supplier Supplier
EquipmentEndOfUseDate EquipmentEndOfUseDate
MaintObjectFreeDefinedAttrib MaintObjectFreeDefinedAttrib Sort Field
BusinessArea BusinessArea Business Area
WBSElementInternalID WBSElementInternalID WBS Internal ID
FixedAsset FixedAsset Sub-number
LinearDataStartPoint LinearDataStartPoint
LinearDataEndPoint LinearDataEndPoint
LinearDataLength LinearDataLength
LinearDataUnitOfMeasure LinearDataUnitOfMeasure
_Customer _Customer
_Supplier _Supplier
_EquipmentPartner _EquipmentPartner
_Text _Text

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_EquipmentDataDP.
-- 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_EquipmentDataDP AS
SELECT
  Equipment,
  ValidityEndDate,
  EquipUsagePeriodSequenceNumber,
  ABCIndicator,
  AcquisitionValue,
  AddressID,
  MasterFixedAsset,
  CompanyCode,
  CostCenter,
  ControllingArea,
  Currency,
  OperationStartDate,
  TechnicalObjectType,
  FunctionalLocation,
  InventoryNumber,
  AssetLocation,
  MaintenancePlant,
  AssetRoom,
  Material,
  MaintenancePlanningPlant,
  PlantSection,
  MaintenancePlannerGroup,
  WBSElementExternalID,
  EquipmentCategory,
  CreationDate,
  Plant,
  MainWorkCenterInternalID,
  MainWorkCenter,
  MainWorkCenterPlant,
  SettlementOrder,
  WorkCenterInternalID,
  WorkCenter,
  WorkCenterPlant,
  LastChangeDateTime,
  EquipmentIsMarkedForDeletion,
  NextEquipUsagePeriodSqncNmbr,
  MaintObjectLocAcctAssgmtNmbr,
  WorkCenterTypeCode,
  CatalogProfile,
  SuperordinateEquipment,
  TechnicalObjectSortCode,
  ConstructionMaterial,
  ValidityStartDate,
  ValidityEndTime,
  EquipmentManufacturerPrtNmbr,
  Division,
  StorageLocation,
  AssetManufacturerName,
  ManufacturerPartTypeName,
  ManufacturerCountry,
  ConstructionYear,
  ConstructionMonth,
  AcquisitionDate,
  MaintObjectInternalID,
  SerialNumber,
  Customer,
  AuthorizationGroup,
  GrossWeight,
  GrossWeightUnit,
  SizeOrDimensionText,
  Batch,
  Supplier,
  EquipmentEndOfUseDate,
  MaintObjectFreeDefinedAttrib,
  BusinessArea,
  WBSElementInternalID,
  FixedAsset,
  LinearDataStartPoint,
  LinearDataEndPoint,
  LinearDataLength,
  LinearDataUnitOfMeasure
FROM C_EquipmentDataDEX
LEFT OUTER JOIN C_EquipmentPartnerDP AS _EquipmentPartner ON Equipment = _EquipmentPartner.Equipment  -- association [0..*]
LEFT OUTER JOIN C_EquipmentTextDP AS _Text ON Equipment = _Text.Equipment  -- association [0..*]
;

Learn More