P_EquipmentSearch

DDL: P_EQUIPMENTSEARCH SQL: PEQUISEARCH Type: view BASIC
65 Fields 1 Data Sources 4 Associations

P_EquipmentSearch is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (I_Equipment) and exposes 65 fields with key field Equipment. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_Equipment I_Equipment from

Parameters (2)

NameTypeDefault
P_Language abap.lang
P_KeyDate sydate

Associations (4)

CardinalityTargetAliasCondition
[0..*] I_TextObjectPlainLongText _LongText $projection.Equipment = _LongText.TextObjectKey and _LongText.TextObjectCategory = 'EQUI' and _LongText.TextObjectType = 'LTXT'
[0..*] I_TextObjectPlainLongText _LongTextIntNote $projection.Equipment = _LongTextIntNote.TextObjectKey and _LongTextIntNote.TextObjectCategory = 'EQUI' and _LongTextIntNote.TextObjectType = 'INTV'
[0..*] I_ClfnObjectCharcValForKeyDate _CharValueAssignment $projection.Equipment = _CharValueAssignment.ClfnObjectID and _CharValueAssignment.ClfnObjectTable = 'EQUI'
[0..*] I_ClfnObjectClassForKeyDate _ClassAssignment $projection.Equipment = _ClassAssignment.ClfnObjectID and _ClassAssignment.ClfnObjectTable = 'EQUI'

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PEQUISEARCH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.representativeKey Equipment view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment Equipment check
EquipmentCategory EquipmentCategory EquipCategory
TechnicalObjectType TechnicalObjectType Text object
Plant Plant Valuation Area
Division Division Internal Division ID
StorageLocation StorageLocation StorageLocation
CreatedByUser CreatedByUser User Name
LastChangedByUser LastChangedByUser User Name
CreationDate CreationDate Time Stamp
LastChangeDate LastChangeDate Time Stamp
AssetManufacturerName AssetManufacturerName Manufacturer
ManufacturerPartTypeName ManufacturerPartTypeName Model number
ManufacturerCountry ManufacturerCountry Mnf. Cntry/Regn
ConstructionYear ConstructionYear ConstructYear
ConstructionMonth ConstructionMonth ConstructMth
AcquisitionDate AcquisitionDate Date Entered
Currency Currency Valuation Crcy
AcquisitionValue AcquisitionValue AcquistnValue
MaintObjectInternalID MaintObjectInternalID Object number
SerialNumber Serial Number
EquipUsagePeriodSequenceNumber EquipUsagePeriodSequenceNumber ConsecNumber
Material Material Vehicle Model
Customer Customer Sold-to Party
AuthorizationGroup AuthorizationGroup AuthorizGroup
ManufacturerSerialNumber ManufacturerSerialNumber Mnf.serial no.
UniqueItemIdentifier UniqueItemIdentifier UII
UniqueItemIdentifierStrucType UniqueItemIdentifierStrucType IUID Type
UniqueItemIdentifierRespPlant UniqueItemIdentifierRespPlant Resp. Plant UII
AssetSynchronizationRule AssetSynchronizationRule Change equipment
InventoryNumber InventoryNumber Inventory No.
GrossWeight GrossWeight Total Weight
GrossWeightUnit GrossWeightUnit Weight Unit
SizeOrDimensionText SizeOrDimensionText Size/dimensions
Batch Batch Lot No.
OperationStartDate OperationStartDate Start-up date
Supplier Supplier Supplier
HasEquipmentData HasEquipmentData Equipment data
MasterWarranty MasterWarranty Master warranty
LastChangeDateTime LastChangeDateTime Timestamp
_Batch _Batch
_CreatedByUser _CreatedByUser
_Currency _Currency
_CurrentTimeSegment _CurrentTimeSegment
_Customer _Customer
_Division _Division
_EquipmentCategory _EquipmentCategory
_EquipmentText _EquipmentText
_EquipmentTimeSeg _EquipmentTimeSeg
_GrossWeightUnit _GrossWeightUnit
_LastChangedByUser _LastChangedByUser
_LinearAssetManagementData _LinearAssetManagementData
_ManufacturerCountry _ManufacturerCountry
_MasterWarranty _MasterWarranty
_MasterWrntyObjectAssgmt _MasterWrntyObjectAssgmt
_Plant _Plant
_PlantMaintenancePartner _PlantMaintenancePartner
_SerialNumberStockSegment _SerialNumberStockSegment
_Status _Status
_StorageLocation _StorageLocation
_Supplier _Supplier
_TechnicalObjectType _TechnicalObjectType
_LongText _LongText
_LongTextIntNote _LongTextIntNote
_CharValueAssignment _CharValueAssignment
_ClassAssignment _ClassAssignment

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 P_EquipmentSearch.
-- 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: PEQUISEARCH
-- Parameters: P_Language : abap.lang, P_KeyDate : sydate

CREATE VIEW P_EquipmentSearch AS
SELECT
  Equipment,
  EquipmentCategory,
  TechnicalObjectType,
  Plant,
  Division,
  StorageLocation,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  LastChangeDate,
  AssetManufacturerName,
  ManufacturerPartTypeName,
  ManufacturerCountry,
  ConstructionYear,
  ConstructionMonth,
  AcquisitionDate,
  Currency,
  AcquisitionValue,
  MaintObjectInternalID,
  cast( SerialNumber as equnr) AS SerialNumber,
  EquipUsagePeriodSequenceNumber,
  Material,
  Customer,
  AuthorizationGroup,
  ManufacturerSerialNumber,
  UniqueItemIdentifier,
  UniqueItemIdentifierStrucType,
  UniqueItemIdentifierRespPlant,
  AssetSynchronizationRule,
  InventoryNumber,
  GrossWeight,
  GrossWeightUnit,
  SizeOrDimensionText,
  Batch,
  OperationStartDate,
  Supplier,
  HasEquipmentData,
  MasterWarranty,
  LastChangeDateTime
FROM I_Equipment
LEFT OUTER JOIN I_TextObjectPlainLongText AS _LongText ON Equipment = _LongText.TextObjectKey AND _LongText.TextObjectCategory = 'EQUI' AND _LongText.TextObjectType = 'LTXT'  -- association [0..*]
LEFT OUTER JOIN I_TextObjectPlainLongText AS _LongTextIntNote ON Equipment = _LongTextIntNote.TextObjectKey AND _LongTextIntNote.TextObjectCategory = 'EQUI' AND _LongTextIntNote.TextObjectType = 'INTV'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectCharcValForKeyDate AS _CharValueAssignment ON Equipment = _CharValueAssignment.ClfnObjectID AND _CharValueAssignment.ClfnObjectTable = 'EQUI'  -- association [0..*]
LEFT OUTER JOIN I_ClfnObjectClassForKeyDate AS _ClassAssignment ON Equipment = _ClassAssignment.ClfnObjectID AND _ClassAssignment.ClfnObjectTable = 'EQUI'  -- association [0..*]
;

Learn More