I_CAPaymentRunGroup

DDL: I_CAPAYMENTRUNGROUP Type: view_entity BASIC Package: FKK_PAYMENT_RUN

Payment Run Group

I_CAPaymentRunGroup is a Basic CDS View that provides data about "Payment Run Group" in SAP S/4HANA. It reads from 1 data source (dpayg) and exposes 12 fields with key fields CAMassRunDate, CAMassRunID, CAPaymentDataOriginCode, CAInternalPaymentGroup. Part of development package FKK_PAYMENT_RUN.

Data Sources (1)

SourceAliasJoin Type
dpayg dpayg from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Payment Run Group view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #BASIC view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CAMassRunDate laufd Run On
KEY CAMassRunID Settlement ID
KEY CAPaymentDataOriginCode orign Source
KEY CAInternalPaymentGroup grpno Routine Number
CAPaymentMediumFormat formi Payt Mdm Format
CAPaymentCompanyCode opbuk Paying Co. Code
HouseBank hbkid House Bank
HouseBankAccount hktid House Bank Account
CAPaymentIsCreditOrDebit crdeb Credit/Debit Memo
CAPaymentMethod zlsch Pymt Meth.
NumberOfPayments anz_erz No. of Payts
NumberOfPaymentsInFile anz_erl Completed Pymts

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 I_CAPaymentRunGroup.
-- 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.

CREATE VIEW I_CAPaymentRunGroup AS
SELECT
  laufd AS CAMassRunDate,
  cast(laufi as laufi_kk) AS CAMassRunID,
  orign AS CAPaymentDataOriginCode,
  grpno AS CAInternalPaymentGroup,
  formi AS CAPaymentMediumFormat,
  opbuk AS CAPaymentCompanyCode,
  hbkid AS HouseBank,
  hktid AS HouseBankAccount,
  crdeb AS CAPaymentIsCreditOrDebit,
  zlsch AS CAPaymentMethod,
  anz_erz AS NumberOfPayments,
  anz_erl AS NumberOfPaymentsInFile
FROM dpayg
;