R_BankPaymentRunDocumentTP

DDL: R_BANKPAYMENTRUNDOCUMENTTP Type: view_entity TRANSACTIONAL
161 Fields 1 Data Sources

Payment run documents - TP

R_BankPaymentRunDocumentTP is a Transactional CDS View that provides data about "Payment run documents - TP" in SAP S/4HANA. It reads from 1 data source (I_BankPaymentRunDocument) and exposes 161 fields with key fields PaymentRunDate, PaymentRunID, PayingCompanyCode, Supplier, Customer.

Data Sources (1)

SourceAliasJoin Type
I_BankPaymentRunDocument I_BankPaymentRunDocument from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Payment run documents - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name BankPaymentRunDocument view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (161)

KeyFieldSource TableSource FieldDescription
KEY PaymentRunDate PaymentRunDate
KEY PaymentRunID PaymentRunID
KEY PayingCompanyCode PayingCompanyCode Paying Company Code
KEY Supplier Supplier Supplier
KEY Customer Customer Sold-to Party
KEY PaymentRecipient PaymentRecipient
KEY PaymentDocument PaymentDocument Payment Document Number
PaymentRunMergeDate PaymentRunMergeDate
PaymentRunMergeIdentifier PaymentRunMergeIdentifier
HouseBank HouseBank House Bank
HouseBankAccount HouseBankAccount House Bank Account
PaymentMethod PaymentMethod Pymt Meth.
PaymentMethodSupplement PaymentMethodSupplement Pmnt Meth. Sup.
PaymentCurrency PaymentCurrency Payment Currency
PaymentDocumentPostingDate PaymentDocumentPostingDate
ValueDate ValueDate Value Date
PayeeBankValueDate PayeeBankValueDate
PaidItemDueDate PaidItemDueDate
PaymentBatch PaymentBatch
PaymentRunIsProposal PaymentRunIsProposal
SupplierClerkIDBySupplier SupplierClerkIDBySupplier Acct w/ vendor
BankAccountHolderName BankAccountHolderName Account Holder
AccountingClerk AccountingClerk Clerk Abbrev.
PaidAmountInPaytCurrency PaidAmountInPaytCurrency Payment Amount
AmountInCompanyCodeCurrency AmountInCompanyCodeCurrency Local Crcy Amt
PayeeBankControlKey PayeeBankControlKey
BankControlKey BankControlKey Control Key
BankCountry BankCountry Bank Ctry/Rgn. Key
PaymentRunDocumentPayeeBankKey PaymentRunDocumentPayeeBankKey
PayeeBank PayeeBank
BusinessArea BusinessArea Business Area
CashDiscountAmtInTransacCrcy CashDiscountAmtInTransacCrcy
CashDiscountAmtInCoCodeCrcy CashDiscountAmtInCoCodeCrcy Discount Amt
SupplierCityName SupplierCityName Supplier City
PayeeCityName PayeeCityName
SupplierCountry SupplierCountry
PayeeBankCountry PayeeBankCountry
District District District Court
EDIPaymentOrderStatus EDIPaymentOrderStatus
EDIPaymentAdviceStatus EDIPaymentAdviceStatus
PaymentRequestPaymentGroup PaymentRequestPaymentGroup
BankInternalID BankInternalID Bank Key
Bank Bank Bank Number
HouseBankIBAN HouseBankIBAN
PayeeIBAN PayeeIBAN
DataExchangeInstructionKey DataExchangeInstructionKey Instruction Key
DataExchangeInstruction1 DataExchangeInstruction1 Instruction 1
DataExchangeInstruction2 DataExchangeInstruction2 Instruction 2
DataExchangeInstruction3 DataExchangeInstruction3 Instruction 3
DataExchangeInstruction4 DataExchangeInstruction4 Instruction 4
PaymentReason PaymentReason Payment Reason
DirectDebitType DirectDebitType
LostCashDiscountInTransacCrcy LostCashDiscountInTransacCrcy
LostCashDiscountInCoCodeCrcy LostCashDiscountInCoCodeCrcy
FunctionalCurrency FunctionalCurrency Functional Currency
PaymentAmountInFunctionalCrcy PaymentAmountInFunctionalCrcy
CashDiscountAmountInFuncnlCrcy CashDiscountAmountInFuncnlCrcy
SupplierName SupplierName Supplier Name
SupplierAdditionalName SupplierAdditionalName
CustomerName CustomerName Name of Customer
CustomerAdditionalName CustomerAdditionalName
PayeeName PayeeName
PayeeAdditionalName PayeeAdditionalName
PayeeTitle PayeeTitle
AddressID AddressID Ship-to address
NumberOfTextLines NumberOfTextLines
NumberOfPaidItems NumberOfPaidItems
BankAccount BankAccount Bank acct
BankAccountLongID BankAccountLongID
POBoxDeviatingCityName POBoxDeviatingCityName PO Box City
POBoxPostalCode POBoxPostalCode PO Box Postal Code
PayeePOBoxPostalCode PayeePOBoxPostalCode
PayeePostalCode PayeePostalCode
PayeeBankAccount PayeeBankAccount
PayeeBankAccountLongID PayeeBankAccountLongID
PayeeCountry PayeeCountry
PayeeLanguage PayeeLanguage
PayeePOBox PayeePOBox
PayeeStreet PayeeStreet
PaymentReference PaymentReference Payment Reference
PersonnelNumber PersonnelNumber Personnel No.
POBox POBox PO Box
PostalCode PostalCode Postal Code
PostingDate PostingDate Posting Date for GR
BankAccountReferenceText BankAccountReferenceText Reference
Region Region Venue Region
PaymentOrder PaymentOrder
SendingCompanyCode SendingCompanyCode
SEPASequenceType SEPASequenceType
StreetAddressName StreetAddressName Street
SWIFTCode SWIFTCode SWIFT/BIC
SEPAMandateUUID SEPAMandateUUID Mandate ID
SupplierRegion SupplierRegion
ExchangeRate ExchangeRate Exchange rate
PaymentOrigin PaymentOrigin
BillOfExchangeIssueDate BillOfExchangeIssueDate
BillOfExchangeDueDate BillOfExchangeDueDate
PaymentsGroupingCriterion PaymentsGroupingCriterion
SWIFTTransactionReferenceUUID SWIFTTransactionReferenceUUID Unique Reference
BusinessPlace BusinessPlace Business place
BankChainBank1Type BankChainBank1Type
BankChainBank1Country BankChainBank1Country
BankChainBank1 BankChainBank1
BankChainBank1BankAccount BankChainBank1BankAccount
BankChainBank1ControlKey BankChainBank1ControlKey
BankChainBank1DetailReference BankChainBank1DetailReference
BankChainBank1IBAN BankChainBank1IBAN
BankChainBank2Type BankChainBank2Type
BankChainBank2Country BankChainBank2Country
BankChainBank2 BankChainBank2
BankChainBank2BankAccount BankChainBank2BankAccount
BankChainBank2ControlKey BankChainBank2ControlKey
BankChainBank2DetailReference BankChainBank2DetailReference
BankChainBank2IBAN BankChainBank2IBAN
BankChainBank3Type BankChainBank3Type
BankChainBank3Country BankChainBank3Country
BankChainBank3 BankChainBank3
BankChainBank3BankAccount BankChainBank3BankAccount
BankChainBank3ControlKey BankChainBank3ControlKey
BankChainBank3DetailReference BankChainBank3DetailReference
BankChainBank3IBAN BankChainBank3IBAN
PayeePaymentSystem PayeePaymentSystem
PayeeAliasType PayeeAliasType
PayeeAliasName PayeeAliasName
CompanyCodeCurrency CompanyCodeCurrency Local Currency
Country Country Venue: Ctry/Reg
FiscalYearVariant FiscalYearVariant FY Variant
SWIFTGPIReason SWIFTGPIReason
PaymentBatchItemCurrentStatus PaymentBatchItemCurrentStatus
PaymentBatchRuleCurrency PaymentBatchRuleCurrency
IsUrgentPayment IsUrgentPayment
PaymentMethodName PaymentMethodName Text
FiscalYear FiscalYear G/L Fiscal Year
PaymentRunFileIdentifier PaymentRunFileIdentifier
PaymentRunFileDate PaymentRunFileDate
MergeBatchNumber MergeBatchNumber
PaymentStatusReasonName PaymentStatusReasonName
PaymentReasonText PaymentReasonText
AliasTypeText AliasTypeText
AccountingDocument AccountingDocument Journal Entry
BatchItemExists BatchItemExists
PaymentMediumReference PaymentMediumReference
PaymentStatusReasonByBankName PaymentStatusReasonByBankName
PaymentStatusReasonByBank PaymentStatusReasonByBank
PaytBatItmCurStsName PaytBatItmCurStsName
FinancialAccountType FinancialAccountType Fin. Account Type
PaymentBatchItem PaymentBatchItem
BatchUUID BatchUUID Target Grp GUID
PayBatchItemCurStsCritlVal PayBatchItemCurStsCritlVal
PayBatchHeaderCurStsCritlVal PayBatchHeaderCurStsCritlVal
OriginName OriginName
BankChainIsHidden BankChainIsHidden
PayeeCountryName PayeeCountryName
PayeeBankCountryName PayeeBankCountryName
BankCountryName BankCountryName Country/Region
BankChainBank1CountryName BankChainBank1CountryName
BankChainBank2CountryName BankChainBank2CountryName
BankChainBank3CountryName BankChainBank3CountryName
PaymentRunIDSemanticObject PaymentRunIDSemanticObject
PaytBatHdrCurStsName PaytBatHdrCurStsName
_CompanyCode _CompanyCode

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_BankPaymentRunDocumentTP.
-- 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_BankPaymentRunDocumentTP AS
SELECT
  PaymentRunDate,
  PaymentRunID,
  PayingCompanyCode,
  Supplier,
  Customer,
  PaymentRecipient,
  PaymentDocument,
  PaymentRunMergeDate,
  PaymentRunMergeIdentifier,
  HouseBank,
  HouseBankAccount,
  PaymentMethod,
  PaymentMethodSupplement,
  PaymentCurrency,
  PaymentDocumentPostingDate,
  ValueDate,
  PayeeBankValueDate,
  PaidItemDueDate,
  PaymentBatch,
  PaymentRunIsProposal,
  SupplierClerkIDBySupplier,
  BankAccountHolderName,
  AccountingClerk,
  PaidAmountInPaytCurrency,
  AmountInCompanyCodeCurrency,
  PayeeBankControlKey,
  BankControlKey,
  BankCountry,
  PaymentRunDocumentPayeeBankKey,
  PayeeBank,
  BusinessArea,
  CashDiscountAmtInTransacCrcy,
  CashDiscountAmtInCoCodeCrcy,
  SupplierCityName,
  PayeeCityName,
  SupplierCountry,
  PayeeBankCountry,
  District,
  EDIPaymentOrderStatus,
  EDIPaymentAdviceStatus,
  PaymentRequestPaymentGroup,
  BankInternalID,
  Bank,
  HouseBankIBAN,
  PayeeIBAN,
  DataExchangeInstructionKey,
  DataExchangeInstruction1,
  DataExchangeInstruction2,
  DataExchangeInstruction3,
  DataExchangeInstruction4,
  PaymentReason,
  DirectDebitType,
  LostCashDiscountInTransacCrcy,
  LostCashDiscountInCoCodeCrcy,
  FunctionalCurrency,
  PaymentAmountInFunctionalCrcy,
  CashDiscountAmountInFuncnlCrcy,
  SupplierName,
  SupplierAdditionalName,
  CustomerName,
  CustomerAdditionalName,
  PayeeName,
  PayeeAdditionalName,
  PayeeTitle,
  AddressID,
  NumberOfTextLines,
  NumberOfPaidItems,
  BankAccount,
  BankAccountLongID,
  POBoxDeviatingCityName,
  POBoxPostalCode,
  PayeePOBoxPostalCode,
  PayeePostalCode,
  PayeeBankAccount,
  PayeeBankAccountLongID,
  PayeeCountry,
  PayeeLanguage,
  PayeePOBox,
  PayeeStreet,
  PaymentReference,
  PersonnelNumber,
  POBox,
  PostalCode,
  PostingDate,
  BankAccountReferenceText,
  Region,
  PaymentOrder,
  SendingCompanyCode,
  SEPASequenceType,
  StreetAddressName,
  SWIFTCode,
  SEPAMandateUUID,
  SupplierRegion,
  ExchangeRate,
  PaymentOrigin,
  BillOfExchangeIssueDate,
  BillOfExchangeDueDate,
  PaymentsGroupingCriterion,
  SWIFTTransactionReferenceUUID,
  BusinessPlace,
  BankChainBank1Type,
  BankChainBank1Country,
  BankChainBank1,
  BankChainBank1BankAccount,
  BankChainBank1ControlKey,
  BankChainBank1DetailReference,
  BankChainBank1IBAN,
  BankChainBank2Type,
  BankChainBank2Country,
  BankChainBank2,
  BankChainBank2BankAccount,
  BankChainBank2ControlKey,
  BankChainBank2DetailReference,
  BankChainBank2IBAN,
  BankChainBank3Type,
  BankChainBank3Country,
  BankChainBank3,
  BankChainBank3BankAccount,
  BankChainBank3ControlKey,
  BankChainBank3DetailReference,
  BankChainBank3IBAN,
  PayeePaymentSystem,
  PayeeAliasType,
  PayeeAliasName,
  CompanyCodeCurrency,
  Country,
  FiscalYearVariant,
  SWIFTGPIReason,
  PaymentBatchItemCurrentStatus,
  PaymentBatchRuleCurrency,
  IsUrgentPayment,
  PaymentMethodName,
  FiscalYear,
  PaymentRunFileIdentifier,
  PaymentRunFileDate,
  MergeBatchNumber,
  PaymentStatusReasonName,
  PaymentReasonText,
  AliasTypeText,
  AccountingDocument,
  BatchItemExists,
  PaymentMediumReference,
  PaymentStatusReasonByBankName,
  PaymentStatusReasonByBank,
  PaytBatItmCurStsName,
  FinancialAccountType,
  PaymentBatchItem,
  BatchUUID,
  PayBatchItemCurStsCritlVal,
  PayBatchHeaderCurStsCritlVal,
  OriginName,
  BankChainIsHidden,
  PayeeCountryName,
  PayeeBankCountryName,
  BankCountryName,
  BankChainBank1CountryName,
  BankChainBank2CountryName,
  BankChainBank3CountryName,
  PaymentRunIDSemanticObject,
  PaytBatHdrCurStsName
FROM I_BankPaymentRunDocument
;

Learn More