I_SUPPROTFLEXIBLETIMEBUCKETTP

CDS View

Supply Protection Flexible Time Bucket

I_SUPPROTFLEXIBLETIMEBUCKETTP is a CDS View in S/4HANA. Supply Protection Flexible Time Bucket. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_SupProtFlexibleTimeBucket view_entity projection CONSUMPTION Flexible Time Bucket
A_SupProtFlexibleTimeBucket_2 view_entity projection CONSUMPTION Flexible Time Bucket
C_SupProtFlexibleTimeBucketTP view_entity projection CONSUMPTION Supply Protection Flexible Time Bucket 
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@AccessControl.authorizationCheck: #MANDATORY

@ObjectModel:   { usageType: { serviceQuality: #C,
                               sizeCategory:   #XL,
                               dataClass:      #MIXED } }

@EndUserText.label: 'Supply Protection Flexible Time Bucket'
define view entity I_SupProtFlexibleTimeBucketTP
  as select from I_SupProtFlexibleTimeBucket

  association to parent I_SupplyProtectionTP as _SupplyProtectionTP on $projection.SupplyProtectionUUID = _SupplyProtectionTP.SupplyProtectionUUID
{
  key SupProtFlexibleTimeBucketUUID,
      SupplyProtectionUUID,

      SupProtPeriodStartUTCDateTime,
      cast(tstmp_to_dats( cast( SupProtPeriodStartUTCDateTime as abap.dec(15,0) ), 'UTC', $session.client, 'NULL' ) as vdm_v_start_date) as StartDate,

      SupProtPeriodEndUTCDateTime,
      cast(tstmp_to_dats( cast( SupProtPeriodEndUTCDateTime as abap.dec(15,0) ),'UTC', $session.client, 'NULL' ) as vdm_v_end_date)      as EndDate,

      cast(dats_days_between( tstmp_to_dats( cast( SupProtPeriodStartUTCDateTime as abap.dec(15,0) ), 'UTC', $session.client, 'NULL' ),
                              tstmp_to_dats( cast( SupProtPeriodEndUTCDateTime as abap.dec(15,0) ),'UTC', $session.client, 'NULL' ) ) + 1
          as sup_period_days )                                                                                                           as NumberOfDays,

      @Semantics.systemDateTime.createdAt: true
      CreationDateTime,      
      @Semantics.user.createdBy: true
      CreatedByUser,
      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,
      @Semantics.user.lastChangedBy: true
      LastChangedByUser,

      /* Associations */
      _SupplyProtectionTP
}

Learn More