R_MaintenanceJobPackageBuildTP

DDL: R_MAINTENANCEJOBPACKAGEBUILDTP Type: view_entity TRANSACTIONAL Package: RAP_EAM_MAINTJOBPACKAGE
19 Fields 1 Data Sources 1 Associations

Maintenance Work Pack - TP

R_MaintenanceJobPackageBuildTP is a Transactional CDS View that provides data about "Maintenance Work Pack - TP" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceJobPackageBuild) and exposes 19 fields with key field MaintenanceJobPackageBuildUUID. It has 1 association to related views. Part of development package RAP_EAM_MAINTJOBPACKAGE.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceJobPackageBuild I_MaintenanceJobPackageBuild from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_MaintenanceJobPackageTP _MaintenanceJobPackageTP

Annotations (9)

NameValueLevelField
EndUserText.label Maintenance Work Pack - TP view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey MaintenanceJobPackageBuildUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name MaintenanceJobPackageBuild view
VDM.viewType #TRANSACTIONAL view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceJobPackageBuildUUID MaintenanceJobPackageBuildUUID Package Build UUID
MaintenanceJobPackageBuild MaintenanceJobPackageBuild Work Pack
MaintJobPckgBuildType MaintJobPckgBuildType Work Pack Type
MaintJobPckgBuildGrpgCriteria MaintJobPckgBuildGrpgCriteria Grouping Criteria
MaintenanceJobPackageBuildName MaintenanceJobPackageBuildName Job Pckg Build Name
MaintJobPckgBuildOutputStatus _MaintJobPackageBuildStatus MaintJobPckgBuildOutputStatus Output Status
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
CreatedByUserName
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName
_MaintenanceJobPackageTP _MaintenanceJobPackageTP
_MaintJobPckgBuildType _MaintJobPckgBuildType
_MaintJobPckgBuildGrpgCritra _MaintJobPckgBuildGrpgCritra
_MaintJobPackageBuildStatus _MaintJobPackageBuildStatus
_MaintJobPckgBuildTotals _MaintJobPckgBuildTotals
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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 R_MaintenanceJobPackageBuildTP.
-- 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 R_MaintenanceJobPackageBuildTP AS
SELECT
  MaintenanceJobPackageBuildUUID,
  MaintenanceJobPackageBuild,
  MaintJobPckgBuildType,
  MaintJobPckgBuildGrpgCriteria,
  MaintenanceJobPackageBuildName,
  _MaintJobPackageBuildStatus.MaintJobPckgBuildOutputStatus AS MaintJobPckgBuildOutputStatus,
  CreationDateTime,
  CreatedByUser,
  cast('' as eams_person_responsible_name ) AS CreatedByUserName,
  LastChangeDateTime,
  LastChangedByUser,
  cast('' as eams_person_responsible_name ) AS LastChangedByUserName
FROM I_MaintenanceJobPackageBuild
LEFT OUTER JOIN R_MaintenanceJobPackageTP AS _MaintenanceJobPackageTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More