ESH_N_INHOUSEREPAIR

DDL: ESH_N_INHOUSEREPAIR SQL: ESH_L_INHREPAIR Type: view
26 Fields 1 Data Sources 1 Associations

ESH_N_INHOUSEREPAIR is a CDS View in SAP S/4HANA. It reads from 1 data source (I_INHOUSEREPAIR) and exposes 26 fields with key fields CUSTMGMTOBJECTTYPE, INHOUSEREPAIR. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_INHOUSEREPAIR I_INHOUSEREPAIR from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] N_INHREPAIRSTATUSTEXT _INHREPAIRSTATUSTEXT $projection.InhRepairStatus=_INHREPAIRSTATUSTEXT.InhRepairStatus

Annotations (6)

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
AbapCatalog.sqlViewName ESH_L_INHREPAIR view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY CUSTMGMTOBJECTTYPE CUSTMGMTOBJECTTYPE Trans. Cat.
KEY INHOUSEREPAIR INHOUSEREPAIR
DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL RefDistCh-Cust/Mat.
DIVISION DIVISION Internal Division ID
EQUIPMENTNAME
CONTACTPERSONFIRSTNAME _CONTACTPERSON FIRSTNAME First Name
INHREPAIRREFERENCEEQUIPMENT _INHOUSEREPAIRITEM INHREPAIRREFERENCEEQUIPMENT
INHREPAIRSTATUS INHREPAIRSTATUS
INHREPAIRSTATUSNAME
INHREPAIRTYPE INHREPAIRTYPE Type of Data
CONTACTPERSONLASTNAME _CONTACTPERSON LASTNAME Last Name
SOLDTOPARTYNAME _SOLDTOPARTY ORGANIZATIONBPNAME1 Name 1
PERSONFULLNAME _RESPONSIBLEEMPLOYEE PERSONFULLNAME Full Name
POSTINGDATE POSTINGDATE Posting Date for GR
PRODUCT _INHOUSEREPAIRITEM PRODUCT Product Sold
PRODUCTNAME
RESPONSIBLEEMPLOYEE RESPONSIBLEEMPLOYEE Employee Resp.
SALESGROUP SALESGROUP Sales Group
SALESGROUPORGUNITID SALESGROUPORGUNITID Sales Group
SALESOFFICE SALESOFFICE Sales Office
SALESOFFICEORGUNITID SALESOFFICEORGUNITID Sales Office
SALESORGANIZATION SALESORGANIZATION Sales Organization
SALESORGANIZATIONORGUNITID SALESORGANIZATIONORGUNITID
SERIALNUMBER _INHOUSEREPAIRITEM SERIALNUMBER Serial Number
SERVICEDOCUMENTLONGTEXT _SRVCDOCHEADERLONGTEXT SERVICEDOCUMENTLONGTEXT
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_N_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_L_INHREPAIR
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_INHOUSEREPAIR AS
SELECT
  CUSTMGMTOBJECTTYPE,
  INHOUSEREPAIR,
  DISTRIBUTIONCHANNEL,
  DIVISION,
  _INHOUSEREPAIRITEM._INHREPAIRREFERENCEEQUIPTEXT[1: LANGUAGE = $parameters. P_Language].EQUIPMENTNAME AS EQUIPMENTNAME,
  _CONTACTPERSON.FIRSTNAME AS CONTACTPERSONFIRSTNAME,
  _INHOUSEREPAIRITEM.INHREPAIRREFERENCEEQUIPMENT AS INHREPAIRREFERENCEEQUIPMENT,
  INHREPAIRSTATUS,
  _INHREPAIRSTATUSTEXT[1: LANGUAGE = $parameters. P_Language].INHREPAIRSTATUSNAME AS INHREPAIRSTATUSNAME,
  INHREPAIRTYPE,
  _CONTACTPERSON.LASTNAME AS CONTACTPERSONLASTNAME,
  _SOLDTOPARTY.ORGANIZATIONBPNAME1 AS SOLDTOPARTYNAME,
  _RESPONSIBLEEMPLOYEE.PERSONFULLNAME AS PERSONFULLNAME,
  POSTINGDATE,
  _INHOUSEREPAIRITEM.PRODUCT AS PRODUCT,
  _INHOUSEREPAIRITEM._PRODUCTTEXT[1: LANGUAGE = $parameters. P_Language].PRODUCTNAME AS PRODUCTNAME,
  RESPONSIBLEEMPLOYEE,
  SALESGROUP,
  SALESGROUPORGUNITID,
  SALESOFFICE,
  SALESOFFICEORGUNITID,
  SALESORGANIZATION,
  SALESORGANIZATIONORGUNITID,
  _INHOUSEREPAIRITEM.SERIALNUMBER AS SERIALNUMBER,
  _SRVCDOCHEADERLONGTEXT.SERVICEDOCUMENTLONGTEXT AS SERVICEDOCUMENTLONGTEXT,
  SOLDTOPARTY
FROM I_INHOUSEREPAIR
LEFT OUTER JOIN N_INHREPAIRSTATUSTEXT AS _INHREPAIRSTATUSTEXT ON InhRepairStatus=_INHREPAIRSTATUSTEXT.InhRepairStatus  -- association [0..*]
;

Learn More