ESH_S_PAYMENT_BATCH

DDL: ESH_S_PAYMENT_BATCH SQL: ESH_U_PAYTBATCH Type: view Package: ODATA_MONITOR_PAYMENT_BATCHES

Search view -PAYMENT_BATCH

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

Data Sources (1)

SourceAliasJoin Type
ESH_N_PAYMENT_BATCH ESH_N_PAYMENT_BATCH from

Annotations (18)

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
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name BankPaymentBatch view
UI.headerInfo.typeName Payment Batch view
UI.headerInfo.typeNamePlural Payment Batches view
Consumption.semanticObject PaymentItem view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value PAYMENTBATCH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_PAYTBATCH view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BATCHUUID BATCHUUID Target Grp GUID
KEY PAYMENTBATCHITEM PAYMENTBATCHITEM
SUPPLIERAUTHORIZATIONGROUP SUPPLIERAUTHORIZATIONGROUP AuthorizGroup
CUSTOMERAUTHORIZATIONGROUP CUSTOMERAUTHORIZATIONGROUP AuthorizGroup
CUSTOMER CUSTOMER Sold-to Party
CUSTOMERACCOUNTGROUP CUSTOMERACCOUNTGROUP Account group
PAYINGCOMPANYCODE PAYINGCOMPANYCODE Paying Company Code
PAYMENTBATCH PAYMENTBATCH
PAYMENTDOCUMENT PAYMENTDOCUMENT Payment Document Number
PAYMENTRUNDATE PAYMENTRUNDATE
SUPPLIER SUPPLIER Supplier
SUPPLIERACCOUNTGROUP SUPPLIERACCOUNTGROUP Account group
SWIFTTRANSACTIONREFERENCEUUID 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_S_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_U_PAYTBATCH

CREATE VIEW ESH_S_PAYMENT_BATCH AS
SELECT
  BATCHUUID,
  PAYMENTBATCHITEM,
  SUPPLIERAUTHORIZATIONGROUP,
  CUSTOMERAUTHORIZATIONGROUP,
  CUSTOMER,
  CUSTOMERACCOUNTGROUP,
  PAYINGCOMPANYCODE,
  PAYMENTBATCH,
  PAYMENTDOCUMENT,
  PAYMENTRUNDATE,
  SUPPLIER,
  SUPPLIERACCOUNTGROUP,
  SWIFTTRANSACTIONREFERENCEUUID
FROM ESH_N_PAYMENT_BATCH
;