I_ServiceEntrySheetItemAPI01

DDL: I_SERVICEENTRYSHEETITEMAPI01 SQL: IMMSESITAPI01 Type: view BASIC Package: VDM_MM_PUR_SES_PUBLIC

Service Entry Sheet Item

I_ServiceEntrySheetItemAPI01 is a Basic CDS View that provides data about "Service Entry Sheet Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheetItemBasic) and exposes 30 fields with key fields ServiceEntrySheet, ServiceEntrySheetItem. It has 2 associations to related views. Part of development package VDM_MM_PUR_SES_PUBLIC.

1 data source(s) 30 fields

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetItemBasic I_ServiceEntrySheetItemBasic from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ServiceEntrySheetAPI01 _ServiceEntrySheet $projection.ServiceEntrySheet = _ServiceEntrySheet.ServiceEntrySheet
[0..1] E_ServiceEntrySheetItem _ServiceEntrySheetItmExtension $projection.ServiceEntrySheet = _ServiceEntrySheetItmExtension.ServiceEntrySheet and $projection.ServiceEntrySheetItem = _ServiceEntrySheetItmExtension.ServiceEntrySheetItem

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IMMSESITAPI01 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
EndUserText.label Service Entry Sheet Item 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 (30)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet
KEY ServiceEntrySheetItem ServiceEntrySheetItem
PurchaseOrder PurchaseOrder
PurchaseOrderItem PurchaseOrderItem
IsDeleted IsDeleted
Service Service
ServiceEntrySheetItemDesc ServiceEntrySheetItemDesc
ServicePerformer ServicePerformer
AccountAssignmentCategory AccountAssignmentCategory
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution
WorkItem WorkItem
ConfirmedQuantity ConfirmedQuantity
QuantityUnit QuantityUnit
ServicePerformanceDate ServicePerformanceDate
OriginObject OriginObject
NetAmount NetAmount
NetPriceAmount NetPriceAmount
Currency _ServiceEntrySheet Currency
PurgDocItemExternalReference PurgDocItemExternalReference
PurchaseContract PurchaseContract
PurchaseContractItem PurchaseContractItem
PurchasingOrganization PurchasingOrganization
PurchasingGroup PurchasingGroup
Plant Plant
IsEndOfPurposeBlocked IsEndOfPurposeBlocked
CreationDateTime CreationDateTime
CreatedByUser CreatedByUser
LastChangeDateTime LastChangeDateTime
LastChangedByUser LastChangeUser
_ServiceEntrySheet _ServiceEntrySheet 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IMMSESITAPI01'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@EndUserText.label: 'Service Entry Sheet Item'

@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_ServiceEntrySheetItemAPI01
  as select from I_ServiceEntrySheetItemBasic

  association [1..1] to I_ServiceEntrySheetAPI01 as _ServiceEntrySheet             on  $projection.ServiceEntrySheet = _ServiceEntrySheet.ServiceEntrySheet
  association [0..1] to E_ServiceEntrySheetItem  as _ServiceEntrySheetItmExtension on  $projection.ServiceEntrySheet     = _ServiceEntrySheetItmExtension.ServiceEntrySheet
                                                                                   and $projection.ServiceEntrySheetItem = _ServiceEntrySheetItmExtension.ServiceEntrySheetItem
{
  key ServiceEntrySheet,
  key ServiceEntrySheetItem,
      PurchaseOrder,
      PurchaseOrderItem,
      IsDeleted,
      Service,
      ServiceEntrySheetItemDesc,
      ServicePerformer,
      AccountAssignmentCategory,
      MultipleAcctAssgmtDistribution,
      WorkItem,
      @Semantics.quantity.unitOfMeasure: 'QuantityUnit'
      ConfirmedQuantity,
      @Semantics.unitOfMeasure: true
      QuantityUnit,
      ServicePerformanceDate,
      OriginObject,
      @Semantics.amount.currencyCode: 'Currency'
      NetAmount,
      @Semantics.amount.currencyCode: 'Currency'
      NetPriceAmount,
      @Semantics.currencyCode:true
      _ServiceEntrySheet.Currency as Currency,
      PurgDocItemExternalReference,
      PurchaseContract,
      PurchaseContractItem,

      // Fields for Authorization Checks

      PurchasingOrganization,
      PurchasingGroup,
      Plant,
      IsEndOfPurposeBlocked,

      // Admin Data

      CreationDateTime,
      CreatedByUser,
      LastChangeDateTime,
      LastChangeUser              as LastChangedByUser,

      // Associations

      _ServiceEntrySheet
}

Learn More