ESH_N_SRVCCONF

DDL: ESH_N_SRVCCONF SQL: ESH_L_SRVCCONF Type: view Package: CRMS4_REPORT

Anchor view -SRVCCONF

ESH_N_SRVCCONF is a CDS View that provides data about "Anchor view -SRVCCONF" in SAP S/4HANA. It reads from 1 data source (I_SERVICEDOCUMENTENHCD) and exposes 32 fields with key fields SERVICEDOCUMENT, SERVICEOBJECTTYPE. Part of development package CRMS4_REPORT.

1 data source(s) 32 fields

Data Sources (1)

SourceAliasJoin Type
I_SERVICEDOCUMENTENHCD I_SERVICEDOCUMENTENHCD from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName ESH_L_SRVCCONF view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY SERVICEDOCUMENT SERVICEDOCUMENT
KEY SERVICEOBJECTTYPE SERVICEOBJECTTYPE
DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL
DIVISION DIVISION
SOLDTOFIRSTNAME _SOLDTOPARTY FIRSTNAME
EMPFIRSTNAME _RESPEMPLOYEE FIRSTNAME
SOLDTOLASTNAME _SOLDTOPARTY LASTNAME
EMPLASTNAME _RESPEMPLOYEE LASTNAME
EMPORGFNAME _RESPEMPLOYEE ORGANIZATIONBPNAME1
SOLDTOORGFNAME _SOLDTOPARTY ORGANIZATIONBPNAME1
EMPORGLNAME _RESPEMPLOYEE ORGANIZATIONBPNAME2
SOLDTOORGLNAME _SOLDTOPARTY ORGANIZATIONBPNAME2
POSTINGDATE POSTINGDATE
REFINHOUSEREPAIRISEXISTING REFINHOUSEREPAIRISEXISTING
RESPONSIBLEEMPLOYEE RESPONSIBLEEMPLOYEE
SALESGROUP SALESGROUP
SALESGROUPORGUNITID SALESGROUPORGUNITID
SALESOFFICE SALESOFFICE
SALESOFFICEORGUNITID SALESOFFICEORGUNITID
SALESORGANIZATION SALESORGANIZATION
SALESORGANIZATIONORGUNITID SALESORGANIZATIONORGUNITID
SERVICEDOCGROSSAMOUNT SERVICEDOCGROSSAMOUNT
SERVICEDOCNETAMOUNT SERVICEDOCNETAMOUNT
SERVICEDOCUMENTDESCRIPTION SERVICEDOCUMENTDESCRIPTION
SERVICEDOCUMENTISOPEN SERVICEDOCUMENTISOPEN
SERVICEDOCUMENTSTATUSNAME
SERVICEDOCUMENTTYPE SERVICEDOCUMENTTYPE
SERVICEDOCUMENTTYPENAME
SERVICEDOCUMENTUUID SERVICEDOCUMENTUUID
SERVICEORGANIZATION SERVICEORGANIZATION
SOLDTOPARTY SOLDTOPARTY
TRANSACTIONCURRENCY TRANSACTIONCURRENCY 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MIXED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@AbapCatalog.sqlViewName: 'ESH_L_SRVCCONF'
define view ESH_N_SRVCCONF
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_SERVICEDOCUMENTENHCD {

key SERVICEDOCUMENT,

key SERVICEOBJECTTYPE,

DISTRIBUTIONCHANNEL,

DIVISION,

_SOLDTOPARTY.FIRSTNAME as SOLDTOFIRSTNAME,

_RESPEMPLOYEE.FIRSTNAME as EMPFIRSTNAME,

_SOLDTOPARTY.LASTNAME as SOLDTOLASTNAME,

_RESPEMPLOYEE.LASTNAME as EMPLASTNAME,

_RESPEMPLOYEE.ORGANIZATIONBPNAME1 as EMPORGFNAME,

_SOLDTOPARTY.ORGANIZATIONBPNAME1 as SOLDTOORGFNAME,

_RESPEMPLOYEE.ORGANIZATIONBPNAME2 as EMPORGLNAME,

_SOLDTOPARTY.ORGANIZATIONBPNAME2 as SOLDTOORGLNAME,

POSTINGDATE,

REFINHOUSEREPAIRISEXISTING,

RESPONSIBLEEMPLOYEE,

SALESGROUP,

SALESGROUPORGUNITID,

SALESOFFICE,

SALESOFFICEORGUNITID,

SALESORGANIZATION,

SALESORGANIZATIONORGUNITID,

SERVICEDOCGROSSAMOUNT,

SERVICEDOCNETAMOUNT,

SERVICEDOCUMENTDESCRIPTION,

SERVICEDOCUMENTISOPEN,

_SERVICEDOCUMENTSTATUS._SERVICEDOCUMENTSTATUSTEXT[1: Language = $parameters. P_Language].SERVICEDOCUMENTSTATUSNAME,

SERVICEDOCUMENTTYPE,

_SERVICEDOCUMENTTYPE._SERVICEDOCUMENTTYPETEXT[1: LANGUAGE = $parameters. P_Language].SERVICEDOCUMENTTYPENAME,

SERVICEDOCUMENTUUID,

SERVICEORGANIZATION,

SOLDTOPARTY,

TRANSACTIONCURRENCY
}where ServiceObjectType = 'BUS2000117' AND 
REFINHOUSEREPAIRISEXISTING is initial

Learn More