A_ServiceEntrySheet

DDL: A_SERVICEENTRYSHEET SQL: ASRVCENTRSHT Type: view COMPOSITE

Service Entry Sheet

A_ServiceEntrySheet is a Composite CDS View that provides data about "Service Entry Sheet" in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheetBasic) and exposes 26 fields with key field ServiceEntrySheet. It has 2 associations to related views.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetBasic I_ServiceEntrySheetBasic from

Associations (2)

CardinalityTargetAliasCondition
[1..*] A_ServiceEntrySheetItem _ServiceEntrySheetItem _ServiceEntrySheetItem.ServiceEntrySheet = $projection.ServiceEntrySheet --Extension
[0..1] E_ServiceEntrySheet _Extension _Extension.ServiceEntrySheet = $projection.ServiceEntrySheet

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ASRVCENTRSHT view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Service Entry Sheet view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet
ApprovalDateTime ApprovalDateTime
ApprovalStatus ApprovalStatus
SESWorkflowStatus _SESWorkflowStatus SESWorkflowStatus
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
Currency Currency
IsDeleted IsDeleted
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangeUser
MaterialDocument MaterialDocument
MaterialDocumentYear MaterialDocumentYear
OriginObjectType OriginObjectType
PurchaseOrder PurchaseOrder
ResponsiblePerson ResponsiblePerson
ServiceEntrySheetName ServiceEntrySheetName
ServiceEntrySheetUUID ServiceEntrySheetUUID
Supplier Supplier
PurgDocExternalSystem PurgDocExternalSystem
PurgDocExternalReference PurgDocExternalReference
ExternalRevisionDateTime ExternalRevisionDateTime
PostingDate PostingDate
_ServiceEntrySheetItem _ServiceEntrySheetItem 
@AbapCatalog.sqlViewName: 'ASRVCENTRSHT'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Service Entry Sheet'
@VDM.viewType : #COMPOSITE
@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

@ObjectModel: {
   usageType.serviceQuality: #C,
   usageType.sizeCategory: #L,
   usageType.dataClass: #TRANSACTIONAL,
   createEnabled: true,
   updateEnabled: true,
   deleteEnabled: false
}
define view A_ServiceEntrySheet
  as select from I_ServiceEntrySheetBasic
  association [1..*] to A_ServiceEntrySheetItem as _ServiceEntrySheetItem on _ServiceEntrySheetItem.ServiceEntrySheet = $projection.ServiceEntrySheet

  --Extension Association
  association [0..1] to E_ServiceEntrySheet     as _Extension             on _Extension.ServiceEntrySheet = $projection.ServiceEntrySheet

{
  key ServiceEntrySheet,
      ApprovalDateTime,
      ApprovalStatus,

      _SESWorkflowStatus.SESWorkflowStatus,
      CreatedByUser,
      CreationDateTime,

      PurchasingOrganization,
      PurchasingGroup,
      IsEndOfPurposeBlocked,

      @Semantics.currencyCode:true
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'
      Currency,

      IsDeleted,
      LastChangeDateTime,
      LastChangeUser as LastChangedByUser,
      MaterialDocument,
      MaterialDocumentYear,

      //@ObjectModel.sapObjectNodeTypeReference: 'SESOriginObjectType'

      OriginObjectType,
      PurchaseOrder,
      ResponsiblePerson,
      ServiceEntrySheetName,
      ServiceEntrySheetUUID,
      Supplier,
      PurgDocExternalSystem,
      PurgDocExternalReference,
      ExternalRevisionDateTime,
      PostingDate,
      _ServiceEntrySheetItem

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SERVICEENTRYSHEETBASIC",
"I_SESWORKFLOWSTATUS"
],
"ASSOCIATED":
[
"A_SERVICEENTRYSHEETITEM",
"E_SERVICEENTRYSHEET"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More