I_EquipmentPRTByInternalKey

DDL: I_EQUIPMENTPRTBYINTERNALKEY SQL: IPPEQUIPRTIK Type: view BASIC Package: VDM_PP_MD_PRT
48 Fields 2 Data Sources 2 Associations

Equipment PRT by internal key

I_EquipmentPRTByInternalKey is a Basic CDS View (Dimension) that provides data about "Equipment PRT by internal key" in SAP S/4HANA. It reads from 2 data sources (crve_a, I_ProdnRsceToolMasterData) and exposes 48 fields with key fields ProductionResourceType, ProductionResourceInternalID. It has 2 associations to related views. Part of development package VDM_PP_MD_PRT.

Data Sources (2)

SourceAliasJoin Type
crve_a crve_a inner
I_ProdnRsceToolMasterData PRT from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_Equipment _Equipment $projection.Equipment = _Equipment.Equipment
[1..1] I_EquipmentProdnRsceTool _EquipmentProdnRsceTool $projection.Equipment = _EquipmentProdnRsceTool.Equipment

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IPPEQUIPRTIK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
ObjectModel.representativeKey ProductionResourceInternalID view
ObjectModel.semanticKey Equipment view
Analytics.dataCategory #DIMENSION view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Equipment PRT by internal key view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
Metadata.allowExtensions true view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY ProductionResourceType I_ProdnRsceToolMasterData ProductionResourceType Object Type
KEY ProductionResourceInternalID I_ProdnRsceToolMasterData ProductionResourceInternalID Object ID
Equipment crve_a equnr Equipment
ProductionResourceToolGroup1 I_ProdnRsceToolMasterData ProductionResourceToolGroup1 Grouping Key 1
ProductionResourceToolGroup2 I_ProdnRsceToolMasterData ProductionResourceToolGroup2 Grouping Key 2
ProductionResourceUsage I_ProdnRsceToolMasterData ProductionResourceUsage Usage
ShopFloorRtgPRTIsRegistrable I_ProdnRsceToolMasterData ShopFloorRtgPRTIsRegistrable Registrable
ProdnRsceToolControlProfile ProdnRsceToolControlProfile PRT Control Profile
ChangeNumber I_ProdnRsceToolMasterData ChangeNumber Change Number
ProdnRsceToolStandardTextCode ProdnRsceToolStandardTextCode Std Text Key
ProdnRsceToolTotQtyCalcFormula ProdnRsceToolTotQtyCalcFormula Formula
ProdnRsceToolUsageQtyCalcFmla ProdnRsceToolUsageQtyCalcFmla Formula
StartDateOffsetReferenceCode StartDateOffsetReferenceCode
EndDateOffsetReferenceCode EndDateOffsetReferenceCode
ProdPRTLoadRecordsAreCreated ProdPRTLoadRecordsAreCreated Load records
EndDateOffsetDurnIsReferenced EndDateOffsetDurnIsReferenced
StartDateOffstDurnIsReferenced StartDateOffstDurnIsReferenced
EndDteOffstRefCodeIsReferenced EndDteOffstRefCodeIsReferenced
StartDateOffsetRefCodeIsRefcd StartDateOffsetRefCodeIsRefcd
PRTTotQtyCalcFmlaIsReferenced PRTTotQtyCalcFmlaIsReferenced
PRTUsgeQtyCalcFmlaIsReferenced PRTUsgeQtyCalcFmlaIsReferenced
PRTControlProfileIsReferenced PRTControlProfileIsReferenced
PRTStdTextCodeIsReferenced PRTStdTextCodeIsReferenced
StartDateOffsetDuration StartDateOffsetDuration
StartDateOffsetDurationUnit StartDateOffsetDurationUnit Unit
EndDateOffsetDuration EndDateOffsetDuration
EndDateOffsetDurationUnit EndDateOffsetDurationUnit Unit
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangedByUser LastChangedByUser User Name
_ProductionResourceType _ProductionResourceType
_Equipment _Equipment
_EquipmentProdnRsceTool _EquipmentProdnRsceTool
_ProdnRsceToolGroup1 _ProdnRsceToolGroup1
_ProdnRsceToolGroup2 _ProdnRsceToolGroup2
_ProductionResourceUsage _ProductionResourceUsage
_ProdnRsceToolControlProfile _ProdnRsceToolControlProfile
_ProdnRsceToolStandardText _ProdnRsceToolStandardText
_ProdnRsceToolTotQtyCalcFmla _ProdnRsceToolTotQtyCalcFmla
_ProdnRsceToolUsageQtyCalcFmla _ProdnRsceToolUsageQtyCalcFmla
_StartDateOffsetReferenceCode _StartDateOffsetReferenceCode
_EndDateOffsetReferenceCode _EndDateOffsetReferenceCode
_StartDateOffsetDurationUnit _StartDateOffsetDurationUnit
_EndDateOffsetDurationUnit _EndDateOffsetDurationUnit
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_ChangeMaster _ChangeMaster

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 I_EquipmentPRTByInternalKey.
-- 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: IPPEQUIPRTIK

CREATE VIEW I_EquipmentPRTByInternalKey AS
SELECT
  PRT.ProductionResourceType AS ProductionResourceType,
  PRT.ProductionResourceInternalID AS ProductionResourceInternalID,
  crve_a.equnr AS Equipment,
  PRT.ProductionResourceToolGroup1 AS ProductionResourceToolGroup1,
  PRT.ProductionResourceToolGroup2 AS ProductionResourceToolGroup2,
  PRT.ProductionResourceUsage AS ProductionResourceUsage,
  PRT.ShopFloorRtgPRTIsRegistrable AS ShopFloorRtgPRTIsRegistrable,
  ProdnRsceToolControlProfile,
  PRT.ChangeNumber AS ChangeNumber,
  ProdnRsceToolStandardTextCode,
  ProdnRsceToolTotQtyCalcFormula,
  ProdnRsceToolUsageQtyCalcFmla,
  StartDateOffsetReferenceCode,
  EndDateOffsetReferenceCode,
  ProdPRTLoadRecordsAreCreated,
  EndDateOffsetDurnIsReferenced,
  StartDateOffstDurnIsReferenced,
  EndDteOffstRefCodeIsReferenced,
  StartDateOffsetRefCodeIsRefcd,
  PRTTotQtyCalcFmlaIsReferenced,
  PRTUsgeQtyCalcFmlaIsReferenced,
  PRTControlProfileIsReferenced,
  PRTStdTextCodeIsReferenced,
  StartDateOffsetDuration,
  StartDateOffsetDurationUnit,
  EndDateOffsetDuration,
  EndDateOffsetDurationUnit,
  CreationDate,
  CreatedByUser,
  LastChangeDate,
  LastChangedByUser
FROM I_ProdnRsceToolMasterData AS PRT
INNER JOIN crve_a ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Equipment AS _Equipment ON Equipment = _Equipment.Equipment  -- association [1..1]
LEFT OUTER JOIN I_EquipmentProdnRsceTool AS _EquipmentProdnRsceTool ON Equipment = _EquipmentProdnRsceTool.Equipment  -- association [1..1]
;

Learn More