V_PAYMENT_OM_DET_PARAM

DDL: V_PAYMENT_OM_DET_PARAM SQL: V_PAYMT_OM_P_CDS Type: view Package: FINS_OUTPUT_MGMT_FO_PAYM_ADV

Parameter for Output Determination in Payment Advice

V_PAYMENT_OM_DET_PARAM is a CDS View that provides data about "Parameter for Output Determination in Payment Advice" in SAP S/4HANA. It reads from 1 data source (reguh) and exposes 14 fields with key fields PaymentRunDate, PaymentRunID, PaymentRunIsProposal, PayingCompanyCode, Supplier. Part of development package FINS_OUTPUT_MGMT_FO_PAYM_ADV.

Data Sources (1)

SourceAliasJoin Type
reguh reguh from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName V_PAYMT_OM_P_CDS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PaymentRunDate laufd Run On
KEY PaymentRunID laufi Settlement ID
KEY PaymentRunIsProposal xvorl Proposal Run
KEY PayingCompanyCode zbukr Paying CoCd
KEY Supplier lifnr Vendor no.
KEY Customer kunnr Stock customer
KEY PaymentRecipient empfg Pmnt Recipient
KEY PaymentDocument vblnr Payment Doc.No.
PayeeLanguage zspra Payee lang. key
PaymentMethod rzawe Pymt Meth.
SupplierCountry land1 Trip Ctry/Reg
SendingCompanyCode absbu Snd.co.cde
SeparatePaymentAdviceIsIssued xavis Sep.Paymt.Adv.
HouseBank hbkid House Bank

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 V_PAYMENT_OM_DET_PARAM.
-- 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: V_PAYMT_OM_P_CDS

CREATE VIEW V_PAYMENT_OM_DET_PARAM AS
SELECT
  laufd AS PaymentRunDate,
  laufi AS PaymentRunID,
  xvorl AS PaymentRunIsProposal,
  zbukr AS PayingCompanyCode,
  lifnr AS Supplier,
  kunnr AS Customer,
  empfg AS PaymentRecipient,
  vblnr AS PaymentDocument,
  zspra AS PayeeLanguage,
  rzawe AS PaymentMethod,
  land1 AS SupplierCountry,
  absbu AS SendingCompanyCode,
  xavis AS SeparatePaymentAdviceIsIssued,
  hbkid AS HouseBank
FROM reguh
;