R_ServiceEntrySheetTP

DDL: R_SERVICEENTRYSHEETTP Type: view_entity TRANSACTIONAL Package: RAP_MM_PUR_SES

Service Entry Sheet Header

R_ServiceEntrySheetTP is a Transactional CDS View that provides data about "Service Entry Sheet Header" in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheet) and exposes 34 fields with key field ServiceEntrySheet. It has 3 associations to related views. Part of development package RAP_MM_PUR_SES.

1 data source(s) 34 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheet I_ServiceEntrySheet from

Associations (3)

CardinalityTargetAliasCondition
[1..1] E_ServiceEntrySheet _ServiceEntrySheetExtension $projection.ServiceEntrySheet = _ServiceEntrySheetExtension.ServiceEntrySheet
[1..*] R_ServiceEntrySheetItemTP _ServiceEntrySheetItem
[0..*] R_ServiceEntrySheetNoteTP _ServiceEntrySheetNote

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Service Entry Sheet Header view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey ServiceEntrySheet view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name ServiceEntrySheet view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet
ServiceEntrySheetName ServiceEntrySheetName
Supplier Supplier
SupplierName SupplierName
PurchaseOrder PurchaseOrder
PurchaseOrderCurrency PurchaseOrderCurrency
IsDeleted IsDeleted
ApprovalStatus ApprovalStatus
SESWorkflowStatus SESWorkflowStatus
ApprovalDateTime ApprovalDateTime
ResponsiblePerson ResponsiblePerson
SESOriginObjectType OriginObjectType
Currency Currency
MaterialDocument MaterialDocument
MaterialDocumentYear MaterialDocumentYear
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangeUser
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
PurgDocExternalSystem PurgDocExternalSystem
PurgDocExternalReference PurgDocExternalReference
ExternalRevisionDateTime ExternalRevisionDateTime
PostingDate PostingDate
PricingDocument PricingDocument
TotalNetAmount TotalNetAmount
TotalSESNetAmountInclSalesTax TotalSESNetAmountInclSalesTax
_ServiceEntrySheetItem _ServiceEntrySheetItem
_PurchaseOrderCurrency _PurchaseOrderCurrency
_ApprovalStatusValueHelp _ApprovalStatusValueHelp
_DocumentCurrency _DocumentCurrency
_ServiceEntrySheetNote _ServiceEntrySheetNote 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Service Entry Sheet Header'

@AccessControl.personalData.blocking: #REQUIRED

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

@ObjectModel.semanticKey:  [ 'ServiceEntrySheet' ]
@ObjectModel.representativeKey: 'ServiceEntrySheet'

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

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.sapObjectNodeType.name: 'ServiceEntrySheet'

define root view entity R_ServiceEntrySheetTP
  as select from I_ServiceEntrySheet

  composition [1..*] of R_ServiceEntrySheetItemTP as _ServiceEntrySheetItem
  composition [0..*] of R_ServiceEntrySheetNoteTP as _ServiceEntrySheetNote
  
  ----Extension Association
  association [1..1] to E_ServiceEntrySheet       as _ServiceEntrySheetExtension on $projection.ServiceEntrySheet = _ServiceEntrySheetExtension.ServiceEntrySheet

{
  key ServiceEntrySheet,
      ServiceEntrySheetName,
      Supplier,
      SupplierName,
      PurchaseOrder,
      @ObjectModel.foreignKey.association: '_PurchaseOrderCurrency'
      PurchaseOrderCurrency,
      @Semantics.booleanIndicator
      IsDeleted,
      @ObjectModel.foreignKey.association: '_ApprovalStatusValueHelp'
      ApprovalStatus,
      SESWorkflowStatus,
      ApprovalDateTime,
      ResponsiblePerson,
      OriginObjectType as SESOriginObjectType,
      @ObjectModel.foreignKey.association: '_DocumentCurrency'
      Currency,
      MaterialDocument,
      MaterialDocumentYear,
      CreationDateTime,
      CreatedByUser,
      LastChangeDateTime,
      LastChangeUser   as LastChangedByUser,
      PurchasingOrganization,
      PurchasingGroup,
      @Semantics.booleanIndicator
      IsEndOfPurposeBlocked,
      PurgDocExternalSystem,
      PurgDocExternalReference,
      ExternalRevisionDateTime,
      PostingDate,
      PricingDocument,
      @Semantics.amount.currencyCode: 'Currency'
      TotalNetAmount,
      @Semantics.amount.currencyCode: 'Currency'
      TotalSESNetAmountInclSalesTax,

      /* Associations */
      _ServiceEntrySheetItem,
      _PurchaseOrderCurrency,
      _ApprovalStatusValueHelp,
      _DocumentCurrency,
      _ServiceEntrySheetNote


}
where IsDeleted = ''

Learn More