SHSM_SERVICEENTRYSHEETLEANITEM

DDL: SHSM_SERVICEENTRYSHEETLEANITEM SQL: SHSMSRVENTSHTLIT Type: view
17 Fields 3 Data Sources

Selection View For SESITEM_C Value Help

SHSM_SERVICEENTRYSHEETLEANITEM is a CDS View that provides data about "Selection View For SESITEM_C Value Help" in SAP S/4HANA. It reads from 3 data sources (I_BusinessPartner, SERVICEENTRYSHEETLEANITEMS, SHSM_SERVICEENTRYSHEETLEAN) and exposes 17 fields with key fields mandt, SERVICEENTRYSHEET, SERVICEENTRYSHEETITEM.

Data Sources (3)

SourceAliasJoin Type
I_BusinessPartner I_BusinessPartner left_outer
SERVICEENTRYSHEETLEANITEMS SERVICEENTRYSHEETLEANITEMS from
SHSM_SERVICEENTRYSHEETLEAN SHSM_SERVICEENTRYSHEETLEAN inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMSRVENTSHTLIT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Selection View For SESITEM_C Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY mandt SERVICEENTRYSHEETLEANITEMS mandt Editing Client
KEY SERVICEENTRYSHEET SERVICEENTRYSHEETLEANITEMS SERVICEENTRYSHEET Service Entry Sheet
KEY SERVICEENTRYSHEETITEM SERVICEENTRYSHEETLEANITEMS SERVICEENTRYSHEETITEM Item Number of SES
SERVICEPERFORMER SERVICEENTRYSHEETLEANITEMS SERVICEPERFORMER Service Performer
PERFORMANCEDATE SERVICEENTRYSHEETLEANITEMS PERFORMANCEDATE Performance Date
SERVICE SERVICEENTRYSHEETLEANITEMS SERVICE Service Type
REFERENCEPURCHASEORDER SERVICEENTRYSHEETLEANITEMS REFERENCEPURCHASEORDER Reference PO
REFERENCEPURCHASEORDERITEM SERVICEENTRYSHEETLEANITEMS REFERENCEPURCHASEORDERITEM Ref. PO Item
Quantity SERVICEENTRYSHEETLEANITEMS QUANTITY Value
Unit SERVICEENTRYSHEETLEANITEMS UNIT UoM
PersonFullName I_BusinessPartner PersonFullName Full Name
plant SERVICEENTRYSHEETLEANITEMS PLANT Valuation Area
APPROVALSTATUS SHSM_SERVICEENTRYSHEETLEAN APPROVALSTATUS Document Status
ApprovalStatusDescription SHSM_SERVICEENTRYSHEETLEAN ApprovalStatusDescription
PURCHASINGGROUP SHSM_SERVICEENTRYSHEETLEAN purchasinggroup Purchasing Group
PURCHASINGORGANIZATION SHSM_SERVICEENTRYSHEETLEAN purchasingorganization Purchasing Organization
ISEOPBLOCKED SHSM_SERVICEENTRYSHEETLEAN iseopblocked Business Usage Comp.

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 SHSM_SERVICEENTRYSHEETLEANITEM.
-- 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: SHSMSRVENTSHTLIT

CREATE VIEW SHSM_SERVICEENTRYSHEETLEANITEM AS
SELECT
  SERVICEENTRYSHEETLEANITEMS.mandt AS mandt,
  SERVICEENTRYSHEETLEANITEMS.SERVICEENTRYSHEET AS SERVICEENTRYSHEET,
  SERVICEENTRYSHEETLEANITEMS.SERVICEENTRYSHEETITEM AS SERVICEENTRYSHEETITEM,
  SERVICEENTRYSHEETLEANITEMS.SERVICEPERFORMER AS SERVICEPERFORMER,
  SERVICEENTRYSHEETLEANITEMS.PERFORMANCEDATE AS PERFORMANCEDATE,
  SERVICEENTRYSHEETLEANITEMS.SERVICE AS SERVICE,
  SERVICEENTRYSHEETLEANITEMS.REFERENCEPURCHASEORDER AS REFERENCEPURCHASEORDER,
  SERVICEENTRYSHEETLEANITEMS.REFERENCEPURCHASEORDERITEM AS REFERENCEPURCHASEORDERITEM,
  SERVICEENTRYSHEETLEANITEMS.QUANTITY AS Quantity,
  SERVICEENTRYSHEETLEANITEMS.UNIT AS Unit,
  I_BusinessPartner.PersonFullName AS PersonFullName,
  SERVICEENTRYSHEETLEANITEMS.PLANT AS plant,
  SHSM_SERVICEENTRYSHEETLEAN.APPROVALSTATUS AS APPROVALSTATUS,
  SHSM_SERVICEENTRYSHEETLEAN.ApprovalStatusDescription AS ApprovalStatusDescription,
  SHSM_SERVICEENTRYSHEETLEAN.purchasinggroup AS PURCHASINGGROUP,
  SHSM_SERVICEENTRYSHEETLEAN.purchasingorganization AS PURCHASINGORGANIZATION,
  SHSM_SERVICEENTRYSHEETLEAN.iseopblocked AS ISEOPBLOCKED
FROM SERVICEENTRYSHEETLEANITEMS
INNER JOIN SHSM_SERVICEENTRYSHEETLEAN ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner ON /* join condition not captured in parsed metadata */
;

Learn More