ESH_S_CAPAYMENTLOTITEM

DDL: ESH_S_CAPAYMENTLOTITEM SQL: ESH_U_CAPYLOTITM Type: view Package: FKK_ESH
19 Fields 1 Data Sources

Search view -CAPAYMENTLOTITEM

ESH_S_CAPAYMENTLOTITEM is a CDS View that provides data about "Search view -CAPAYMENTLOTITEM" in SAP S/4HANA. It reads from 1 data source (ESH_N_CAPAYMENTLOTITEM) and exposes 19 fields with key fields CAPAYMENTLOT, CAPAYMENTLOTITEM. Part of development package FKK_ESH.

Data Sources (1)

SourceAliasJoin Type
ESH_N_CAPAYMENTLOTITEM ESH_N_CAPAYMENTLOTITEM from

Annotations (17)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.modelingPattern #ENTERPRISE_SEARCH_PROVIDER view
Metadata.allowExtensions true view
Search.searchable true view
EnterpriseSearch.enabled true view
ObjectModel.sapObjectNodeType.name ContrAcctgPaymentLotItem view
UI.headerInfo.typeName Contract Accounting Payment Lot Item view
UI.headerInfo.typeNamePlural Contract Accounting Payment Lot Items view
Consumption.semanticObject CAPaymentLot view
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.title.value CAPAYMENTLOT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ESH_U_CAPYLOTITM view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CAPAYMENTLOT CAPAYMENTLOT Payment Lot
KEY CAPAYMENTLOTITEM CAPAYMENTLOTITEM Payment Lot Item
BUSINESSAREA BUSINESSAREA Business Area
CAAUTHORIZATIONGROUP CAAUTHORIZATIONGROUP AuthorizGroup
CABANKACCOUNTHOLDERNAME CABANKACCOUNTHOLDERNAME
CABANKCLEARINGACCOUNT CABANKCLEARINGACCOUNT Bank Clearing Account
CABANKCLEARINGACCOUNTNAME CABANKCLEARINGACCOUNTNAME Bank Clearing Account
CACLARIFICATIONDOCUMENT CACLARIFICATIONDOCUMENT Clarification Document Number
CADOCUMENTNUMBER CADOCUMENTNUMBER Document Number
CANOTETOPAYEEINPAYMENT CANOTETOPAYEEINPAYMENT Note To Payee
CAPAYMENTAMOUNTINTRANSCURRENCY CAPAYMENTAMOUNTINTRANSCURRENCY Payment Amount
CAPAYMENTTRANSISTOBECLARIFIED CAPAYMENTTRANSISTOBECLARIFIED To Be Clarified
CAPAYTTRANSISTOBECLARIFIEDTEXT CAPAYTTRANSISTOBECLARIFIEDTEXT To Be Clarified
CAPOSTINGDATE CAPOSTINGDATE Posting Date
COMPANYCODE COMPANYCODE Receiver Company Code
COMPANYCODENAME COMPANYCODENAME Company Code Name
HOUSEBANK HOUSEBANK House Bank
HOUSEBANKNAME HOUSEBANKNAME House Bank
TRANSACTIONCURRENCY TRANSACTIONCURRENCY Transaction Currency

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_CAPAYMENTLOTITEM.
-- 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_CAPYLOTITM

CREATE VIEW ESH_S_CAPAYMENTLOTITEM AS
SELECT
  CAPAYMENTLOT,
  CAPAYMENTLOTITEM,
  BUSINESSAREA,
  CAAUTHORIZATIONGROUP,
  CABANKACCOUNTHOLDERNAME,
  CABANKCLEARINGACCOUNT,
  CABANKCLEARINGACCOUNTNAME,
  CACLARIFICATIONDOCUMENT,
  CADOCUMENTNUMBER,
  CANOTETOPAYEEINPAYMENT,
  CAPAYMENTAMOUNTINTRANSCURRENCY,
  CAPAYMENTTRANSISTOBECLARIFIED,
  CAPAYTTRANSISTOBECLARIFIEDTEXT,
  CAPOSTINGDATE,
  COMPANYCODE,
  COMPANYCODENAME,
  HOUSEBANK,
  HOUSEBANKNAME,
  TRANSACTIONCURRENCY
FROM ESH_N_CAPAYMENTLOTITEM
;

Learn More