R_PaymentRunPlanTP

DDL: R_PAYMENTRUNPLANTP Type: view_entity TRANSACTIONAL
72 Fields 1 Data Sources

Payment Run Plan

R_PaymentRunPlanTP is a Transactional CDS View that provides data about "Payment Run Plan" in SAP S/4HANA. It reads from 1 data source (fap_payplan) and exposes 72 fields with key fields PaymentRunPlanUUID, PaymentRunPlanVersion.

Data Sources (1)

SourceAliasJoin Type
fap_payplan _PaymentPlan from

Annotations (10)

NameValueLevelField
AbapCatalog.dataMaintenance #RESTRICTED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Payment Run Plan view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name PaymentRun view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.personalData.blocking #REQUIRED view

Fields (72)

KeyFieldSource TableSource FieldDescription
KEY PaymentRunPlanUUID paymentrunplanuuid Payment Plan UUID
KEY PaymentRunPlanVersion paymentrunplanversion Version Number
PaymentRunPlanName paymentrunplanname Plan Name
PaymentRunPlanPurpose paymentrunplanpurpose Category
CompanyCodeParameterValue companycodeparametervalue Company Code
PaymentRunPreliminaryID paymentrunpreliminaryid Payment Run ID
SupplierList supplierlist Supplier Selection
CustomerCollections customercollections Customer Selection
Country country Venue: Ctry/Reg
PaymentMethodsList paymentmethodslist Payment Methods
PaymentRunPlanSelectionField1 paymentrunplanselectionfield1 Free Selection 1
PaymentRunPlanSelField1Value paymentrunplanselfield1value Selection Value 1
PaymentRunPlanSelectionField2 paymentrunplanselectionfield2 Free Selection 2
PaymentRunPlanSelField2Value paymentrunplanselfield2value Selection Value 2
PaymentRunPlanSelectionField3 paymentrunplanselectionfield3 Free Selection 3
PaymentRunPlanSelField3Value paymentrunplanselfield3value Selection Value 3
PaymentRunPlanSelectionField4 paymentrunplanselectionfield4 Free Selection 4
PaymentRunPlanSelField4Value paymentrunplanselfield4value Selection Value 4
RecurrenceType recurrencetype Recurrence Type
RecurrenceFrequency recurrencefrequency Recurrence Frequency
MonthlyRecurrenceType monthlyrecurrencetype Monthly Recur. Type
CalendarDay calendarday Occur Day in a Month
EndOfMonthBackwardShiftValue endofmonthbackwardshiftvalue Day from End
WeekOfMonth weekofmonth Week of Month
WorkDayRule workdayrule Recurrence Weekdays
TimeZoneID timezoneid Time Zone
PaymentRunPlanCustomCalendar paymentrunplancustomcalendar Custom Calendar
PostingDateDaysShiftValue postingdatedaysshiftvalue Next Post Date Shift
ReleaseTime releasetime Run Time
JobIsStartedImmediately jobisstartedimmediately Start immediat.
PaymentRunPlanPostgDteSpecRule paymentrunplanpostgdtespecrule Posting Date
PostingDateShiftInDays postingdateshiftindays Posting Date Shift
PaymentRunPlanEntryDateSel paymentrunplanentrydatesel Docs Entered Up To
EntryDateSelectionShiftInDays entrydateselectionshiftindays Entry Date Shift
PaymentRunPlanDueDateSelection paymentrunplanduedateselection Cust. Items Due By
DueDateSelectionShiftInDays duedateselectionshiftindays Due by Date Shift
FactoryCalendar factorycalendar Factory Calendar
NonWorkingDayAdjustment nonworkingdayadjustment On Non-Working Days
StartDate startdate Valid From
EndDate enddate Term to
PaymentRunPlanExclusionStrtDte paymentrunplanexclusionstrtdte Exclusion Start Date
PaymentRunPlanExclusionEndDate paymentrunplanexclusionenddate Exclusion End date
PaytMdmIsCreatedByDueDate paytmdmiscreatedbyduedate Payment Medium
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
PaymentRunPlanStatus paymentrunplanstatus Status
JobName jobname Name of Send Process
_CompanyCode _CompanyCode
_WeekDay _WeekDay
_WeekOfMonth _WeekOfMonth
_FactoryCalendar _FactoryCalendar
_TimeZoneID _TimeZoneID
_Supplier _Supplier
_Customer _Customer
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_RecurrenceType _RecurrenceType
_PaymentRunPlanPurpose _PaymentRunPlanPurpose
_MonthlyRecurrenceType _MonthlyRecurrenceType
_NonWorkingDayAdjustment _NonWorkingDayAdjustment
_PostingDate _PostingDate
_PaymentRunPlanEntryDateSel _PaymentRunPlanEntryDateSel
_PaymentRunPlanDueDateSelName _PaymentRunPlanDueDateSelName
_PaymentRunPlanSelectionField1 _PaymentRunPlanSelectionField1
_PaymentRunPlanSelectionField2 _PaymentRunPlanSelectionField2
_PaymentRunPlanSelectionField3 _PaymentRunPlanSelectionField3
_PaymentRunPlanSelectionField4 _PaymentRunPlanSelectionField4
_PaymentMethod _PaymentMethod
_PaymentRunPlanStatus _PaymentRunPlanStatus
_PaymentRunPlanCustomCalStdVH _PaymentRunPlanCustomCalStdVH

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 R_PaymentRunPlanTP.
-- 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 R_PaymentRunPlanTP AS
SELECT
  PaymentRunPlanUUID,
  PaymentRunPlanVersion,
  PaymentRunPlanName,
  PaymentRunPlanPurpose,
  CompanyCodeParameterValue,
  PaymentRunPreliminaryID,
  SupplierList,
  CustomerCollections,
  Country,
  PaymentMethodsList,
  PaymentRunPlanSelectionField1,
  PaymentRunPlanSelField1Value,
  PaymentRunPlanSelectionField2,
  PaymentRunPlanSelField2Value,
  PaymentRunPlanSelectionField3,
  PaymentRunPlanSelField3Value,
  PaymentRunPlanSelectionField4,
  PaymentRunPlanSelField4Value,
  RecurrenceType,
  RecurrenceFrequency,
  MonthlyRecurrenceType,
  CalendarDay,
  EndOfMonthBackwardShiftValue,
  WeekOfMonth,
  WorkDayRule,
  TimeZoneID,
  PaymentRunPlanCustomCalendar,
  PostingDateDaysShiftValue,
  ReleaseTime,
  JobIsStartedImmediately,
  PaymentRunPlanPostgDteSpecRule,
  PostingDateShiftInDays,
  PaymentRunPlanEntryDateSel,
  EntryDateSelectionShiftInDays,
  PaymentRunPlanDueDateSelection,
  DueDateSelectionShiftInDays,
  FactoryCalendar,
  NonWorkingDayAdjustment,
  StartDate,
  EndDate,
  PaymentRunPlanExclusionStrtDte,
  PaymentRunPlanExclusionEndDate,
  PaytMdmIsCreatedByDueDate,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  PaymentRunPlanStatus,
  JobName
FROM fap_payplan AS _PaymentPlan
;

Learn More