ESH_N_PAYMENT_BATCH

DDL: ESH_N_PAYMENT_BATCH SQL: ESH_L_PAYTBATCH Type: view Package: ODATA_MONITOR_PAYMENT_BATCHES
13 Fields 1 Data Sources

Anchor view -PAYMENT_BATCH

ESH_N_PAYMENT_BATCH is a CDS View that provides data about "Anchor view -PAYMENT_BATCH" in SAP S/4HANA. It reads from 1 data source (I_BANKPAYMENTBATCHITEM) and exposes 13 fields with key fields BATCHUUID, PAYMENTBATCHITEM. Part of development package ODATA_MONITOR_PAYMENT_BATCHES.

Data Sources (1)

SourceAliasJoin Type
I_BANKPAYMENTBATCHITEM I_BANKPAYMENTBATCHITEM from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.sqlViewName ESH_L_PAYTBATCH view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BATCHUUID BATCHUUID Target Grp GUID
KEY PAYMENTBATCHITEM PAYMENTBATCHITEM
SUPPLIERAUTHORIZATIONGROUP _SUPPLIER AUTHORIZATIONGROUP AuthorizGroup
CUSTOMERAUTHORIZATIONGROUP _CUSTOMER AUTHORIZATIONGROUP AuthorizGroup
CUSTOMER CUSTOMER Sold-to Party
CUSTOMERACCOUNTGROUP _CUSTOMER CUSTOMERACCOUNTGROUP Account group
PAYINGCOMPANYCODE PAYINGCOMPANYCODE Paying Company Code
PAYMENTBATCH PAYMENTBATCH
PAYMENTDOCUMENT PAYMENTDOCUMENT Payment Document Number
PAYMENTRUNDATE PAYMENTRUNDATE
SUPPLIER SUPPLIER Supplier
SUPPLIERACCOUNTGROUP _SUPPLIER SUPPLIERACCOUNTGROUP Account group
SWIFTTRANSACTIONREFERENCEUUID _PAYMENTPROPOSALHEADER SWIFTTRANSACTIONREFERENCEUUID Unique Reference

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_PAYMENT_BATCH.
-- 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_PAYTBATCH

CREATE VIEW ESH_N_PAYMENT_BATCH AS
SELECT
  BATCHUUID,
  PAYMENTBATCHITEM,
  _SUPPLIER.AUTHORIZATIONGROUP AS SUPPLIERAUTHORIZATIONGROUP,
  _CUSTOMER.AUTHORIZATIONGROUP AS CUSTOMERAUTHORIZATIONGROUP,
  CUSTOMER,
  _CUSTOMER.CUSTOMERACCOUNTGROUP AS CUSTOMERACCOUNTGROUP,
  PAYINGCOMPANYCODE,
  PAYMENTBATCH,
  PAYMENTDOCUMENT,
  PAYMENTRUNDATE,
  SUPPLIER,
  _SUPPLIER.SUPPLIERACCOUNTGROUP AS SUPPLIERACCOUNTGROUP,
  _PAYMENTPROPOSALHEADER.SWIFTTRANSACTIONREFERENCEUUID AS SWIFTTRANSACTIONREFERENCEUUID
FROM I_BANKPAYMENTBATCHITEM
;

Learn More