A_ServiceEntrySheetItem

DDL: A_SERVICEENTRYSHEETITEM SQL: ASRVCENTRSHTITM Type: view BASIC
41 Fields 1 Data Sources 2 Associations

Item

A_ServiceEntrySheetItem is a Basic CDS View that provides data about "Item" in SAP S/4HANA. It reads from 1 data source (I_ServiceEntrySheetItemBasic) and exposes 41 fields with key fields ServiceEntrySheet, ServiceEntrySheetItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceEntrySheetItemBasic I_ServiceEntrySheetItemBasic from

Associations (2)

CardinalityTargetAliasCondition
[1..*] A_SrvcEntrShtAcctAssignment _AccountAssignment _AccountAssignment.ServiceEntrySheet = $projection.ServiceEntrySheet and _AccountAssignment.ServiceEntrySheetItem = $projection.ServiceEntrySheetItem --Extension
[0..1] E_ServiceEntrySheetItem _Extension _Extension.ServiceEntrySheet = $projection.ServiceEntrySheet and _Extension.ServiceEntrySheetItem = $projection.ServiceEntrySheetItem

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName ASRVCENTRSHTITM view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Item view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet Service Entry Sheet
KEY ServiceEntrySheetItem ServiceEntrySheetItem Item Number of SES
AccountAssignmentCategory AccountAssignmentCategory Acct Assgmt Cat
ConfirmedQuantity ConfirmedQuantity Quantity in UnE
CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
Plant Plant Valuation Area
Currency Currency Valuation Crcy
IsDeleted IsDeleted TRUE
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser User Name
SESItemMaterialGroupIsInitial
MaterialGroup MaterialGroup Product Group
MultipleAcctAssgmtDistribution MultipleAcctAssgmtDistribution Distribution
NetAmount NetAmount Stated Amount
NetPriceAmount NetPriceAmount Net Price
OriginObject OriginObject Reference Document
PurchaseOrder PurchaseOrder Purchasing Document
PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseContract PurchaseContract Purchasing Doc.
PurchaseContractItem PurchaseContractItem Item
QuantityUnit QuantityUnit Unit of measure
Service Service Service Type
ServiceEntrySheetItemDesc ServiceEntrySheetItemDesc Well Code Des.
ServiceEntrySheetItemUUID ServiceEntrySheetItemUUID Key
ServiceEntrySheetUUID ServiceEntrySheetUUID Key
ServicePerformanceDate ServicePerformanceDate Performance Date
ServicePerformanceEndDate ServicePerformanceEndDate Performance End Date
ServicePerformer ServicePerformer Service Performer
WorkItem WorkItem Work Item ID
PurgDocItemExternalReference PurgDocItemExternalReference Ext. Reference ID
SESItemIsFinalEntry SESItemIsFinalEntry Final Entry
SESItemTaxCodeIsInitial
TaxCode TaxCode Tax Code
SESItemTaxCountryCodeIsInitial
TaxCountry TaxCountry Tax Ctry/Reg.
SESItmTaxJurisdictionIsInitial
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
_AccountAssignment _AccountAssignment

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view A_ServiceEntrySheetItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ASRVCENTRSHTITM

CREATE VIEW A_ServiceEntrySheetItem AS
SELECT
  ServiceEntrySheet,
  ServiceEntrySheetItem,
  AccountAssignmentCategory,
  ConfirmedQuantity,
  cast(CreatedByUser as mmpur_ses_createdbyuser preserving type ) AS CreatedByUser,
  CreationDateTime,
  PurchasingOrganization,
  PurchasingGroup,
  Plant,
  Currency,
  IsDeleted,
  LastChangeDateTime,
  cast(LastChangeUser as mmpur_ses_lastchangeuser preserving type ) AS LastChangedByUser,
  cast( ' ' as ismaterialgroupinitial) AS SESItemMaterialGroupIsInitial,
  MaterialGroup,
  MultipleAcctAssgmtDistribution,
  NetAmount,
  NetPriceAmount,
  OriginObject,
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseContract,
  PurchaseContractItem,
  QuantityUnit,
  Service,
  ServiceEntrySheetItemDesc,
  ServiceEntrySheetItemUUID,
  ServiceEntrySheetUUID,
  ServicePerformanceDate,
  ServicePerformanceEndDate,
  ServicePerformer,
  WorkItem,
  PurgDocItemExternalReference,
  SESItemIsFinalEntry,
  cast( ' ' as istaxcodeinitial) AS SESItemTaxCodeIsInitial,
  TaxCode,
  cast( ' ' as istaxcountrycodeinitial) AS SESItemTaxCountryCodeIsInitial,
  TaxCountry,
  cast( ' ' as istaxjurisdictioncodeinitial) AS SESItmTaxJurisdictionIsInitial,
  TaxJurisdiction
FROM I_ServiceEntrySheetItemBasic
LEFT OUTER JOIN A_SrvcEntrShtAcctAssignment AS _AccountAssignment ON _AccountAssignment.ServiceEntrySheet = ServiceEntrySheet AND _AccountAssignment.ServiceEntrySheetItem = ServiceEntrySheetItem  -- association [1..*]
LEFT OUTER JOIN E_ServiceEntrySheetItem AS _Extension ON _Extension.ServiceEntrySheet = ServiceEntrySheet AND _Extension.ServiceEntrySheetItem = ServiceEntrySheetItem  -- association [0..1]
;

Learn More