ESH_N_PRELIMBILLINGDOCUMENT

DDL: ESH_N_PRELIMBILLINGDOCUMENT SQL: ESH_L_PREBILDOC Type: view
28 Fields 1 Data Sources 1 Associations

ESH_N_PRELIMBILLINGDOCUMENT is a CDS View in SAP S/4HANA. It reads from 1 data source (I_PRELIMBILLINGDOCUMENT) and exposes 28 fields with key field PRELIMBILLINGDOCUMENT. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PRELIMBILLINGDOCUMENT I_PRELIMBILLINGDOCUMENT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Associations (1)

CardinalityTargetAliasCondition
[0..*] dd07t _PRELIMBILLINGDOCUMENTSTATUS $projection.PrelimBillingDocumentStatus=_PRELIMBILLINGDOCUMENTSTATUS.domvalue_l and _PRELIMBILLINGDOCUMENTSTATUS.domname='PBD_STATUS' and _PRELIMBILLINGDOCUMENTSTATUS.as4local='A'

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ESH_L_PREBILDOC view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY PRELIMBILLINGDOCUMENT PRELIMBILLINGDOCUMENT
BILLINGDOCUMENTDATE BILLINGDOCUMENTDATE Billing Date
BILLINGDOCUMENTITEMTEXT _ITEM BILLINGDOCUMENTITEMTEXT Item Descr.
BILLINGDOCUMENTTYPE BILLINGDOCUMENTTYPE Billing Type
BILLINGDOCUMENTTYPENAME
BILLTOPARTY _ENHANCEDFIELDS BILLTOPARTY Inv. Recipient
BILLTOPARTYNAME
PAYERPARTYNAME
SOLDTOPARTYNAME
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME _COMPANYCODE COMPANYCODENAME Company Name
CREATEDBYUSER CREATEDBYUSER User Name
CUSTOMERPAYMENTTERMS CUSTOMERPAYMENTTERMS Pyt Terms
CUSTOMERPAYMENTTERMSNAME
DOCUMENTREFERENCEID DOCUMENTREFERENCEID Reference
MATERIAL _ITEM MATERIAL Vehicle Model
MATERIALNAME
PAYERPARTY PAYERPARTY Payer
BUSINESSPARTNER
PRELIMBILLINGDOCSTATUSDESC
PRELIMBILLINGDOCUMENTSTATUS PRELIMBILLINGDOCUMENTSTATUS
SALESORGANIZATION SALESORGANIZATION Sales Organization
SALESORGANIZATIONNAME
SOLDTOPARTY SOLDTOPARTY Sold-to Party
TOTALNETAMOUNT TOTALNETAMOUNT Total Net Amount
TAXAMOUNT TOTALTAXAMOUNT Tax Amount
TRANSACTIONCURRENCY TRANSACTIONCURRENCY Transaction Currency
USERDESCRIPTION _CREATEDBYUSER USERDESCRIPTION Full Name

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_PRELIMBILLINGDOCUMENT.
-- 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_PREBILDOC
-- Parameters: P_Language : abap.lang

CREATE VIEW ESH_N_PRELIMBILLINGDOCUMENT AS
SELECT
  PRELIMBILLINGDOCUMENT,
  BILLINGDOCUMENTDATE,
  _ITEM.BILLINGDOCUMENTITEMTEXT AS BILLINGDOCUMENTITEMTEXT,
  BILLINGDOCUMENTTYPE,
  _BILLINGDOCUMENTTYPE._TEXT[1: LANGUAGE = $parameters. P_Language].BILLINGDOCUMENTTYPENAME AS BILLINGDOCUMENTTYPENAME,
  _ENHANCEDFIELDS.BILLTOPARTY AS BILLTOPARTY,
  _ENHANCEDFIELDS._BILLTOPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME1 AS BILLTOPARTYNAME,
  _PAYERPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME1 AS PAYERPARTYNAME,
  _SOLDTOPARTY._STANDARDADDRESS.BUSINESSPARTNERNAME1 AS SOLDTOPARTYNAME,
  COMPANYCODE,
  _COMPANYCODE.COMPANYCODENAME AS COMPANYCODENAME,
  CREATEDBYUSER,
  CUSTOMERPAYMENTTERMS,
  _CUSTOMERPAYMENTTERMS._TEXT[1: LANGUAGE = $parameters. P_Language].CUSTOMERPAYMENTTERMSNAME AS CUSTOMERPAYMENTTERMSNAME,
  DOCUMENTREFERENCEID,
  _ITEM.MATERIAL AS MATERIAL,
  _ITEM._MATERIAL._TEXT[1: LANGUAGE = $parameters. P_Language].MATERIALNAME AS MATERIALNAME,
  PAYERPARTY,
  _CREATEDBYUSER._BUSINESSPARTNER.PERSONFULLNAME AS BUSINESSPARTNER,
  _PRELIMBILLINGDOCUMENTSTATUS[1: ddlanguage = $parameters. P_Language].ddtext AS PRELIMBILLINGDOCSTATUSDESC,
  PRELIMBILLINGDOCUMENTSTATUS,
  SALESORGANIZATION,
  _SALESORGANIZATION._TEXT[1: LANGUAGE = $parameters. P_Language].SALESORGANIZATIONNAME AS SALESORGANIZATIONNAME,
  SOLDTOPARTY,
  TOTALNETAMOUNT,
  TOTALTAXAMOUNT AS TAXAMOUNT,
  TRANSACTIONCURRENCY,
  _CREATEDBYUSER.USERDESCRIPTION AS USERDESCRIPTION
FROM I_PRELIMBILLINGDOCUMENT
LEFT OUTER JOIN dd07t AS _PRELIMBILLINGDOCUMENTSTATUS ON PrelimBillingDocumentStatus=_PRELIMBILLINGDOCUMENTSTATUS.domvalue_l AND _PRELIMBILLINGDOCUMENTSTATUS.domname='PBD_STATUS' AND _PRELIMBILLINGDOCUMENTSTATUS.as4local='A'  -- association [0..*]
;

Learn More