R_HUPSchedLineTP

DDL: R_HUPSCHEDLINETP Type: view_entity TRANSACTIONAL

Schedule Lines (HUP)

R_HUPSchedLineTP is a Transactional CDS View that provides data about "Schedule Lines (HUP)" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentScheduleLine) and exposes 12 fields with key fields SalesSchedulingAgreement, SalesSchedulingAgreementItem, ScheduleLine.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentScheduleLine _SalesDocumentScheduleLine from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Schedule Lines (HUP) view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SalesSchedulingAgreement SalesDocument
KEY SalesSchedulingAgreementItem SalesDocumentItem
KEY ScheduleLine ScheduleLine
Product _SalesDocumentItem Material
MaterialAvailabilityDate ProductAvailabilityDate
SalesDocumentType _SalesDocument SalesDocumentType
OrganizationDivision _SalesDocument OrganizationDivision
SalesOrganization _SalesDocument SalesOrganization
DistributionChannel _SalesDocument DistributionChannel
DeliveryDate I_SalesDocumentScheduleLine DeliveryDate
_HUPSchedgAgrmtTP _HUPSchedgAgrmtTP
_MaterialText _SalesDocumentItem _MaterialText 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@EndUserText.label: 'Schedule Lines (HUP)'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
   serviceQuality:  #D,
   dataClass:       #TRANSACTIONAL,
   sizeCategory:    #XL
}
define view entity R_HUPSchedLineTP
  as select from I_SalesDocumentScheduleLine as _SalesDocumentScheduleLine
  association to parent R_HUPSchedgAgrmtTP as _HUPSchedgAgrmtTP on  $projection.SalesSchedulingAgreement     = _HUPSchedgAgrmtTP.SalesSchedulingAgreement
                                                                and $projection.SalesSchedulingAgreementItem = _HUPSchedgAgrmtTP.SalesSchedulingAgreementItem
{
  key SalesDocument                    as SalesSchedulingAgreement,
  key SalesDocumentItem                as SalesSchedulingAgreementItem,
  key ScheduleLine,

      _SalesDocumentItem.Material      as Product,
      ProductAvailabilityDate          as MaterialAvailabilityDate,

      /* Only for authorization */
      _SalesDocument.SalesDocumentType,
      _SalesDocument.OrganizationDivision,
      _SalesDocument.SalesOrganization,
      _SalesDocument.DistributionChannel,
      
      _SalesDocumentScheduleLine.DeliveryDate,

      _HUPSchedgAgrmtTP,
      _SalesDocumentItem._MaterialText as _MaterialText
}
where
     _HUPSchedgAgrmtTP.SDDocumentCategory = 'E'
  or _HUPSchedgAgrmtTP.SDDocumentCategory = 'F'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTSCHEDULELINE",
"R_HUPSCHEDGAGRMTTP"
],
"ASSOCIATED":
[
"I_MATERIALTEXT",
"R_HUPSCHEDGAGRMTTP"
],
"BASE":
[
"I_SALESDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More