R_ServiceEntrySheetTP

DDL: R_SERVICEENTRYSHEETTP Type: view_entity TRANSACTIONAL

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 33 fields with key field ServiceEntrySheet. It has 2 associations to related views.

1 data source(s) 33 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheet I_ServiceEntrySheet from

Associations (2)

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

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 (33)

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 
@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

  ----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


}
where IsDeleted = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEENTRYSHEET"
],
"ASSOCIATED":
[
"I_CURRENCY",
"I_SRVCENTRSHTAPPROVALSTATUS",
"R_SERVICEENTRYSHEETITEMTP"
],
"BASE":
[
"I_SERVICEENTRYSHEET"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More