ESH_S_INHOUSEREPAIR

DDL: ESH_S_INHOUSEREPAIR SQL: ESH_U_INHREPAIR Type: view Package: CRMS4_REPAIR_BO
25 Fields 1 Data Sources

Search view -INHOUSEREPAIR

ESH_S_INHOUSEREPAIR is a CDS View that provides data about "Search view -INHOUSEREPAIR" in SAP S/4HANA. It reads from 1 data source (ESH_N_INHOUSEREPAIR) and exposes 25 fields with key fields CUSTMGMTOBJECTTYPE, INHOUSEREPAIR. Part of development package CRMS4_REPAIR_BO.

Data Sources (1)

SourceAliasJoin Type
ESH_N_INHOUSEREPAIR ESH_N_INHOUSEREPAIR from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name InHouseRepair view
UI.headerInfo.typeName In-House Repair view
UI.headerInfo.typeNamePlural In-House Repairs view
Consumption.semanticObject InHouseRepair view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value INHOUSEREPAIR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_INHREPAIR view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY CUSTMGMTOBJECTTYPE CUSTMGMTOBJECTTYPE
KEY INHOUSEREPAIR INHOUSEREPAIR
DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL RefDistCh-Cust/Mat.
DIVISION DIVISION Internal Division ID
EQUIPMENTNAME EQUIPMENTNAME Equipment
CONTACTPERSONFIRSTNAME CONTACTPERSONFIRSTNAME Contact Person
INHREPAIRREFERENCEEQUIPMENT INHREPAIRREFERENCEEQUIPMENT
INHREPAIRSTATUS INHREPAIRSTATUS
INHREPAIRSTATUSNAME INHREPAIRSTATUSNAME Status
INHREPAIRTYPE INHREPAIRTYPE
CONTACTPERSONLASTNAME CONTACTPERSONLASTNAME Last Name
SOLDTOPARTYNAME SOLDTOPARTYNAME Sold-To Party
PERSONFULLNAME PERSONFULLNAME Employee Responsible
POSTINGDATE POSTINGDATE Posting Date for GR
PRODUCT PRODUCT Product Sold
PRODUCTNAME PRODUCTNAME Product
RESPONSIBLEEMPLOYEE RESPONSIBLEEMPLOYEE Employee Resp.
SALESGROUP SALESGROUP Sales Group
SALESGROUPORGUNITID SALESGROUPORGUNITID
SALESOFFICE SALESOFFICE Sales Office
SALESOFFICEORGUNITID SALESOFFICEORGUNITID
SALESORGANIZATION SALESORGANIZATION Sales Organization
SALESORGANIZATIONORGUNITID SALESORGANIZATIONORGUNITID
SERIALNUMBER SERIALNUMBER Serial Number
SOLDTOPARTY SOLDTOPARTY Sold-to Party

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 ESH_S_INHOUSEREPAIR.
-- 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: ESH_U_INHREPAIR
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_INHOUSEREPAIR AS
SELECT
  CUSTMGMTOBJECTTYPE,
  INHOUSEREPAIR,
  DISTRIBUTIONCHANNEL,
  DIVISION,
  EQUIPMENTNAME,
  CONTACTPERSONFIRSTNAME,
  INHREPAIRREFERENCEEQUIPMENT,
  INHREPAIRSTATUS,
  INHREPAIRSTATUSNAME,
  INHREPAIRTYPE,
  CONTACTPERSONLASTNAME,
  SOLDTOPARTYNAME,
  PERSONFULLNAME,
  POSTINGDATE,
  PRODUCT,
  PRODUCTNAME,
  RESPONSIBLEEMPLOYEE,
  SALESGROUP,
  SALESGROUPORGUNITID,
  SALESOFFICE,
  SALESOFFICEORGUNITID,
  SALESORGANIZATION,
  SALESORGANIZATIONORGUNITID,
  SERIALNUMBER,
  SOLDTOPARTY
FROM ESH_N_INHOUSEREPAIR
;

Learn More