I_EHSJobStepForJobAtLocationTP

DDL: I_EHSJOBSTEPFORJOBATLOCATIONTP SQL: IEHSJOBSTPLOCTP Type: view TRANSACTIONAL

Job Step for Job at Location

I_EHSJobStepForJobAtLocationTP is a Transactional CDS View that provides data about "Job Step for Job at Location" in SAP S/4HANA. It reads from 1 data source (I_EHSJobStepForJobAtLocation) and exposes 6 fields with key field EHSJobStepForJobAtLocationUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_EHSJobStepForJobAtLocation I_EHSJobStepForJobAtLocation from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_EHSJobStepForJobAtLocTextTP _EHSJobStepForJobAtLocTextTP $projection.EHSJobStepForJobAtLocationUUID = _EHSJobStepForJobAtLocTextTP.EHSJobStepForJobAtLocationUUID

Annotations (16)

NameValueLevelField
EndUserText.label Job Step for Job at Location view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName IEHSJOBSTPLOCTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.writeActivePersistence EHHSSD_LOCJOBSTP view
ObjectModel.transactionalProcessingUnitRoot true view
ObjectModel.representativeKey EHSJobStepForJobAtLocationUUID view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EHSJobStepForJobAtLocationUUID EHSJobStepForJobAtLocationUUID
EHSJobAtLocationUUID EHSJobAtLocationUUID
EHSJobStep EHSJobStep
EHSJobStepSequenceNo EHSJobStepSequenceNo
_EHSJobAtLocationTP _EHSJobAtLocationTP
_EHSJobStepForJobAtLocTextTP _EHSJobStepForJobAtLocTextTP
@EndUserText.label: 'Job Step for Job at Location'
@AccessControl.authorizationCheck: #NOT_REQUIRED

@AbapCatalog.sqlViewName: 'IEHSJOBSTPLOCTP'
@AbapCatalog.compiler.compareFilter: true

@ClientHandling.algorithm: #SESSION_VARIABLE


@ObjectModel: { 
                usageType: {
                    sizeCategory: #M,
                    serviceQuality: #B,
                    dataClass: #TRANSACTIONAL
                },
                
                createEnabled: true,
                deleteEnabled: true,
                updateEnabled: true,

                writeActivePersistence: 'EHHSSD_LOCJOBSTP',
                
                transactionalProcessingUnitRoot:true,

                semanticKey: ['EHSJobStepForJobAtLocationUUID'],
                representativeKey: 'EHSJobStepForJobAtLocationUUID'
}

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view I_EHSJobStepForJobAtLocationTP 
  as select from I_EHSJobStepForJobAtLocation 
  
  association[1..1] to I_EHSJobAtLocationTP as _EHSJobAtLocationTP 
    on $projection.EHSJobAtLocationUUID = _EHSJobAtLocationTP.EHSJobAtLocationUUID

  association [0..*] to I_EHSJobStepForJobAtLocTextTP as _EHSJobStepForJobAtLocTextTP
    on $projection.EHSJobStepForJobAtLocationUUID = _EHSJobStepForJobAtLocTextTP.EHSJobStepForJobAtLocationUUID

  {
  
//   @ObjectModel.foreignKey.association: '_EHSJobStepForJobAtLocTextTP'

   key EHSJobStepForJobAtLocationUUID, // BOPF DB_KEY 


   @ObjectModel.foreignKey.association: '_EHSJobAtLocationTP'
   EHSJobAtLocationUUID, // BOPF PARENT_KEY

  
   @ObjectModel.mandatory: true
   EHSJobStep,
   @ObjectModel.mandatory: true
   EHSJobStepSequenceNo,
 
   @ObjectModel.association.type: [#TO_COMPOSITION_PARENT,#TO_COMPOSITION_ROOT]
   _EHSJobAtLocationTP,
   
   @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
   _EHSJobStepForJobAtLocTextTP
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EHSJOBSTEPFORJOBATLOCATION"
],
"ASSOCIATED":
[
"I_EHSJOBATLOCATIONTP",
"I_EHSJOBSTEPFORJOBATLOCTEXTTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/