ESH_S_CUSTSETTLMTLIST

DDL: ESH_S_CUSTSETTLMTLIST SQL: ESH_U_CSTSTMTLST Type: view Package: WZRE
29 Fields 1 Data Sources

Search view -CUSTSETTLMTLIST

ESH_S_CUSTSETTLMTLIST is a CDS View that provides data about "Search view -CUSTSETTLMTLIST" in SAP S/4HANA. It reads from 1 data source (ESH_N_CUSTSETTLMTLIST) and exposes 29 fields with key field CUSTSETTLMTLIST. Part of development package WZRE.

Data Sources (1)

SourceAliasJoin Type
ESH_N_CUSTSETTLMTLIST ESH_N_CUSTSETTLMTLIST from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (18)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name CustomerSettlementList view
UI.headerInfo.typeName Customer Settlement List view
UI.headerInfo.typeNamePlural Customer Settlement Lists view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value CUSTSETTLMTLIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_CSTSTMTLST view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY CUSTSETTLMTLIST CUSTSETTLMTLIST Customer Settlement List
BILLTOPARTYAUTHGRP BILLTOPARTYAUTHGRP AuthorizGroup
PAYERPARTYAUTHGRP PAYERPARTYAUTHGRP AuthorizGroup
BILLTOPARTYCOMPANYAUTHGRP BILLTOPARTYCOMPANYAUTHGRP AuthorizGroup
PAYERPARTYCOMPANYAUTHGRP PAYERPARTYCOMPANYAUTHGRP AuthorizGroup
BILLTOPARTY BILLTOPARTY Inv. Recipient
COMPANYCODENAME COMPANYCODENAME Company Name
CUSTOMERTOTALGROSSAMOUNT CUSTOMERTOTALGROSSAMOUNT Customer Total Gross Amount
CUSTOMERTOTALNETAMOUNT CUSTOMERTOTALNETAMOUNT Extracted Net Value
CUSTSETTLMTCOMPANYCODE CUSTSETTLMTCOMPANYCODE Cust. Company Code
CUSTSETTLMTLISTCURRENCY CUSTSETTLMTLISTCURRENCY
DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL RefDistCh-Cust/Mat.
DISTRIBUTIONCHANNELNAME DISTRIBUTIONCHANNELNAME
DIVISION DIVISION Internal Division ID
DIVISIONNAME DIVISIONNAME Division Description
BILLTOPARTYNAME BILLTOPARTYNAME Bill-to Party
PAYERPARTYNAME PAYERPARTYNAME Payer Party
PAYERPARTY PAYERPARTY Payer Party
POSTINGDATE POSTINGDATE Posting Date for GR
SALESORGANIZATION SALESORGANIZATION Sales Organization
SALESORGANIZATIONNAME SALESORGANIZATIONNAME Sales Organization
SETTLMTDOCCAT SETTLMTDOCCAT Settlement Document Category
SETTLMTDOCCATNAME SETTLMTDOCCATNAME Settlement Document Category
SETTLMTDOCTYPE SETTLMTDOCTYPE Settlement Document Type
SETTLMTDOCTYPEDESC SETTLMTDOCTYPEDESC Settlement Document Type
SETTLMTMGMTACCTGTRANSFSTS SETTLMTMGMTACCTGTRANSFSTS Posting Status
SETTLMTMGMTACCTGTRANSFSTSNAME SETTLMTMGMTACCTGTRANSFSTSNAME Posting Status
SETTLMTPROCESSTYPE SETTLMTPROCESSTYPE Settlement Process Type
SETTLMTPROCESSTYPEDESC SETTLMTPROCESSTYPEDESC Settlement Process Type

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_CUSTSETTLMTLIST.
-- 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_CSTSTMTLST
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_S_CUSTSETTLMTLIST AS
SELECT
  CUSTSETTLMTLIST,
  BILLTOPARTYAUTHGRP,
  PAYERPARTYAUTHGRP,
  BILLTOPARTYCOMPANYAUTHGRP,
  PAYERPARTYCOMPANYAUTHGRP,
  BILLTOPARTY,
  COMPANYCODENAME,
  CUSTOMERTOTALGROSSAMOUNT,
  CUSTOMERTOTALNETAMOUNT,
  CUSTSETTLMTCOMPANYCODE,
  CUSTSETTLMTLISTCURRENCY,
  DISTRIBUTIONCHANNEL,
  DISTRIBUTIONCHANNELNAME,
  DIVISION,
  DIVISIONNAME,
  BILLTOPARTYNAME,
  PAYERPARTYNAME,
  PAYERPARTY,
  POSTINGDATE,
  SALESORGANIZATION,
  SALESORGANIZATIONNAME,
  SETTLMTDOCCAT,
  SETTLMTDOCCATNAME,
  SETTLMTDOCTYPE,
  SETTLMTDOCTYPEDESC,
  SETTLMTMGMTACCTGTRANSFSTS,
  SETTLMTMGMTACCTGTRANSFSTSNAME,
  SETTLMTPROCESSTYPE,
  SETTLMTPROCESSTYPEDESC
FROM ESH_N_CUSTSETTLMTLIST
;

Learn More