ESH_N_SETTLMTDOCLIST

DDL: ESH_N_SETTLMTDOCLIST SQL: ESH_L_STLMTDCLST Type: view
39 Fields 1 Data Sources 2 Associations

ESH_N_SETTLMTDOCLIST is a CDS View in SAP S/4HANA. It reads from 1 data source (I_SETTLMTDOCLIST) and exposes 39 fields with key field SETTLMTDOCLIST. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SETTLMTDOCLIST I_SETTLMTDOCLIST from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (2)

CardinalityTargetAliasCondition
[0..*] dd07t _SETTLMTDOCCAT $projection.SettlmtDocCat=_SETTLMTDOCCAT.domvalue_l and _SETTLMTDOCCAT.domname='WFTYP' and _SETTLMTDOCCAT.as4local='A'
[0..*] dd07t _SETTLMTMGMTACCTGTRANSFSTS ( $projection.SettlmtMgmtAcctgTransfSts=_SETTLMTMGMTACCTGTRANSFSTS.domvalue_l AND _SETTLMTMGMTACCTGTRANSFSTS.domname='WFBSK' AND _SETTLMTMGMTACCTGTRANSFSTS.as4local='A' )

Annotations (9)

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
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ESH_L_STLMTDCLST view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY SETTLMTDOCLIST SETTLMTDOCLIST
PAYERPARTYCOMPANY _PAYERPARTYCOMPANY AUTHORIZATIONGROUP AuthorizGroup
BILLTOPARTYCOMPANY _BILLTOPARTYCOMPANY AUTHORIZATIONGROUP AuthorizGroup
ALTVINVOICINGPARTYCOMPANY _ALTVINVOICINGPARTYCOMPANY AUTHORIZATIONGROUP AuthorizGroup
PAYEEPARTYCOMPANY _PAYEEPARTYCOMPANY AUTHORIZATIONGROUP AuthorizGroup
INVOICINGPARTYCOMPANY _INVOICINGPARTYCOMPANY AUTHORIZATIONGROUP AuthorizGroup
ALTVINVOICINGPARTYGRP _ALTERNATIVEINVOICINGPARTY AUTHORIZATIONGROUP AuthorizGroup
INVOICINGPARTYAUTHGRP _INVOICINGPARTY AUTHORIZATIONGROUP AuthorizGroup
PAYEEPARTYAUTHGRP _PAYEEPARTY AUTHORIZATIONGROUP AuthorizGroup
BILLTOPARTYAUTHGRP _BILLTOPARTY AUTHORIZATIONGROUP AuthorizGroup
PAYERPARTYAUTHGRP _PAYERPARTY AUTHORIZATIONGROUP AuthorizGroup
BILLTOPARTY BILLTOPARTY Inv. Recipient
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME _COMPANYCODE COMPANYCODENAME Company Name
DISTRIBUTIONCHANNEL DISTRIBUTIONCHANNEL RefDistCh-Cust/Mat.
DIVISION DIVISION Internal Division ID
DOCUMENTDATE DOCUMENTDATE Journal Entry Date
INVOICINGPARTY INVOICINGPARTY Supplier
ORGANIZATIONBPNAME1 _ALTERNATIVEINVOICINGPARTY ORGANIZATIONBPNAME1 Name 1
INVOICINGPARTYNAME _INVOICINGPARTY ORGANIZATIONBPNAME1 Name 1
PAYEEPARTYNAME _PAYEEPARTY ORGANIZATIONBPNAME1 Name 1
BILLTOPARTYNAME _BILLTOPARTY ORGANIZATIONBPNAME1 Name 1
PAYERPARTYNAME _PAYERPARTY ORGANIZATIONBPNAME1 Name 1
PAYEEPARTY PAYEEPARTY Payee
PAYERPARTY PAYERPARTY Payer
POSTINGDATE POSTINGDATE Posting Date for GR
PURCHASINGGROUP PURCHASINGGROUP Purchasing Group
PURCHASINGORGANIZATION PURCHASINGORGANIZATION Purchasing Organization
PURCHASINGORGANIZATIONNAME _PURCHASINGORGANIZATION PURCHASINGORGANIZATIONNAME Purch. Org. Name
SALESORGANIZATION SALESORGANIZATION Sales Organization
SALESORGANIZATIONNAME
SETTLMTDOCCAT SETTLMTDOCCAT Settlement Document Category
SETTLMTDOCCATNAME
SETTLMTDOCTYPE SETTLMTDOCTYPE Settlement Document Type
SETTLMTDOCTYPEDESC
SETTLMTMGMTACCTGTRANSFSTS SETTLMTMGMTACCTGTRANSFSTS Posting Status
SETTLMTMGMTACCTGTRANSFSTSNAME
SETTLMTPROCESSTYPE SETTLMTPROCESSTYPE Settlement Process Type
SETTLMTPROCESSTYPEDESC

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_SETTLMTDOCLIST.
-- 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_STLMTDCLST
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_SETTLMTDOCLIST AS
SELECT
  SETTLMTDOCLIST,
  _PAYERPARTYCOMPANY.AUTHORIZATIONGROUP AS PAYERPARTYCOMPANY,
  _BILLTOPARTYCOMPANY.AUTHORIZATIONGROUP AS BILLTOPARTYCOMPANY,
  _ALTVINVOICINGPARTYCOMPANY.AUTHORIZATIONGROUP AS ALTVINVOICINGPARTYCOMPANY,
  _PAYEEPARTYCOMPANY.AUTHORIZATIONGROUP AS PAYEEPARTYCOMPANY,
  _INVOICINGPARTYCOMPANY.AUTHORIZATIONGROUP AS INVOICINGPARTYCOMPANY,
  _ALTERNATIVEINVOICINGPARTY.AUTHORIZATIONGROUP AS ALTVINVOICINGPARTYGRP,
  _INVOICINGPARTY.AUTHORIZATIONGROUP AS INVOICINGPARTYAUTHGRP,
  _PAYEEPARTY.AUTHORIZATIONGROUP AS PAYEEPARTYAUTHGRP,
  _BILLTOPARTY.AUTHORIZATIONGROUP AS BILLTOPARTYAUTHGRP,
  _PAYERPARTY.AUTHORIZATIONGROUP AS PAYERPARTYAUTHGRP,
  BILLTOPARTY,
  COMPANYCODE,
  _COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
  DISTRIBUTIONCHANNEL,
  DIVISION,
  DOCUMENTDATE,
  INVOICINGPARTY,
  _ALTERNATIVEINVOICINGPARTY.ORGANIZATIONBPNAME1 AS ORGANIZATIONBPNAME1,
  _INVOICINGPARTY.ORGANIZATIONBPNAME1 AS INVOICINGPARTYNAME,
  _PAYEEPARTY.ORGANIZATIONBPNAME1 AS PAYEEPARTYNAME,
  _BILLTOPARTY.ORGANIZATIONBPNAME1 AS BILLTOPARTYNAME,
  _PAYERPARTY.ORGANIZATIONBPNAME1 AS PAYERPARTYNAME,
  PAYEEPARTY,
  PAYERPARTY,
  POSTINGDATE,
  PURCHASINGGROUP,
  PURCHASINGORGANIZATION,
  _PURCHASINGORGANIZATION.PURCHASINGORGANIZATIONNAME AS PURCHASINGORGANIZATIONNAME,
  SALESORGANIZATION,
  _SALESORGANIZATION._TEXT[1: LANGUAGE = $parameters. P_Language].SALESORGANIZATIONNAME AS SALESORGANIZATIONNAME,
  SETTLMTDOCCAT,
  _SETTLMTDOCCAT[1: ddlanguage = $parameters. P_Language].ddtext AS SETTLMTDOCCATNAME,
  SETTLMTDOCTYPE,
  _SETTLMTDOCTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].SETTLMTDOCTYPEDESC AS SETTLMTDOCTYPEDESC,
  SETTLMTMGMTACCTGTRANSFSTS,
  _SETTLMTMGMTACCTGTRANSFSTS[1: ddlanguage = $parameters. P_Language].ddtext AS SETTLMTMGMTACCTGTRANSFSTSNAME,
  SETTLMTPROCESSTYPE,
  _SETTLMTPROCESSTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].SETTLMTPROCESSTYPEDESC AS SETTLMTPROCESSTYPEDESC
FROM I_SETTLMTDOCLIST
LEFT OUTER JOIN dd07t AS _SETTLMTDOCCAT ON SettlmtDocCat=_SETTLMTDOCCAT.domvalue_l AND _SETTLMTDOCCAT.domname='WFTYP' AND _SETTLMTDOCCAT.as4local='A'  -- association [0..*]
LEFT OUTER JOIN dd07t AS _SETTLMTMGMTACCTGTRANSFSTS ON ( SettlmtMgmtAcctgTransfSts=_SETTLMTMGMTACCTGTRANSFSTS.domvalue_l AND _SETTLMTMGMTACCTGTRANSFSTS.domname='WFBSK' AND _SETTLMTMGMTACCTGTRANSFSTS.as4local='A' )  -- association [0..*]
;

Learn More