A_ServiceEntrySheetItem_2

DDL: A_SERVICEENTRYSHEETITEM_2 Type: view_entity CONSUMPTION
38 Fields 1 Data Sources

Item

A_ServiceEntrySheetItem_2 is a Consumption CDS View that provides data about "Item" in SAP S/4HANA. It reads from 1 data source (R_ServiceEntrySheetItemTP) and exposes 38 fields with key fields ServiceEntrySheet, ServiceEntrySheetItem.

Data Sources (1)

SourceAliasJoin Type
R_ServiceEntrySheetItemTP R_ServiceEntrySheetItemTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Item view
OData.entityType.name ServiceEntrySheetItem_Type view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (38)

KeyFieldSource TableSource FieldDescription
KEY ServiceEntrySheet ServiceEntrySheet Service Entry Sheet
KEY ServiceEntrySheetItem ServiceEntrySheetItem Item Number of SES
ServiceEntrySheetItemUniqueID ServiceEntrySheetItemUniqueID
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
PurgDocumentItemDeletionCode PurgDocumentItemDeletionCode TRUE
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
IsEndOfPurposeBlocked IsEndOfPurposeBlocked Busin. Purp. Cmpltd.
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
ServicePerformanceDate ServicePerformanceDate
ServicePerformanceEndDate ServicePerformanceEndDate
ServicePerformer ServicePerformer Service Performer
WorkItem WorkItem Work Item ID
PurgDocItemExternalReference PurgDocItemExternalReference
SESItemIsFinalEntry SESItemIsFinalEntry Final Entry
TaxCode TaxCode Tax Code
TaxCountry TaxCountry Tax Ctry/Reg.
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
NetPriceQuantity NetPriceQuantity Price Unit
OrderPriceUnit OrderPriceUnit Order Price Un.

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

CREATE VIEW A_ServiceEntrySheetItem_2 AS
SELECT
  ServiceEntrySheet,
  ServiceEntrySheetItem,
  ServiceEntrySheetItemUniqueID,
  AccountAssignmentCategory,
  ConfirmedQuantity,
  cast(CreatedByUser as mmpur_ses_createdbyuser preserving type ) AS CreatedByUser,
  CreationDateTime,
  PurchasingOrganization,
  PurchasingGroup,
  Plant,
  Currency,
  PurgDocumentItemDeletionCode,
  LastChangeDateTime,
  LastChangedByUser,
  IsEndOfPurposeBlocked,
  MaterialGroup,
  MultipleAcctAssgmtDistribution,
  NetAmount,
  NetPriceAmount,
  OriginObject,
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseContract,
  PurchaseContractItem,
  QuantityUnit,
  Service,
  ServiceEntrySheetItemDesc,
  ServicePerformanceDate,
  ServicePerformanceEndDate,
  ServicePerformer,
  WorkItem,
  PurgDocItemExternalReference,
  SESItemIsFinalEntry,
  TaxCode,
  TaxCountry,
  TaxJurisdiction,
  NetPriceQuantity,
  OrderPriceUnit
FROM R_ServiceEntrySheetItemTP
;

Learn More