I_ServiceEntrySheetAPI01

DDL: I_SERVICEENTRYSHEETAPI01 SQL: IMMSESAPI01 Type: view BASIC

Service Entry Sheet

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

1 data source(s) 23 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetBasic I_ServiceEntrySheetBasic from

Associations (2)

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

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMMSESAPI01 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
EndUserText.label Service Entry Sheet view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet
ServiceEntrySheetName ServiceEntrySheetName
Supplier Supplier
PurchaseOrder PurchaseOrder
IsDeleted IsDeleted
ApprovalStatus ApprovalStatus
ApprovalDateTime ApprovalDateTime
ResponsiblePerson ResponsiblePerson
OriginObjectType OriginObjectType
Currency Currency
MaterialDocument MaterialDocument
MaterialDocumentYear MaterialDocumentYear
PurgDocExternalSystem PurgDocExternalSystem
PurgDocExternalReference PurgDocExternalReference
PostingDate PostingDate
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangeUser
_ServiceEntrySheetItem _ServiceEntrySheetItem 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMMSESAPI01'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@EndUserText.label: 'Service Entry Sheet'

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED

@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE]

define view I_ServiceEntrySheetAPI01
  as select from I_ServiceEntrySheetBasic

  association [1..*] to I_ServiceEntrySheetItemAPI01 as _ServiceEntrySheetItem      on $projection.ServiceEntrySheet = _ServiceEntrySheetItem.ServiceEntrySheet

  association [0..1] to E_ServiceEntrySheet          as _ServiceEntrySheetExtension on $projection.ServiceEntrySheet = _ServiceEntrySheetExtension.ServiceEntrySheet

{
  key ServiceEntrySheet,
      ServiceEntrySheetName,
      Supplier,
      PurchaseOrder,
      IsDeleted,
      ApprovalStatus,
      ApprovalDateTime,
      ResponsiblePerson,
      OriginObjectType,
      Currency,
      MaterialDocument,
      MaterialDocumentYear,
      PurgDocExternalSystem,
      PurgDocExternalReference,
      PostingDate,

      // Fields for Authorization Checks

      PurchasingOrganization,
      PurchasingGroup,
      IsEndOfPurposeBlocked,

      // Admin Data

      CreationDateTime,
      CreatedByUser,
      LastChangeDateTime,
      LastChangeUser as LastChangedByUser,

      // Associations

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

Learn More