P_Cash_Payrq_WO_Offset

Payment Request with Cash Field and without Offsetting Field | view: PPAYRQWOOFFSET | Extraction: Not supported | Component: SAP Cash Management
Tables used: FDZAPAYRQFQMC_ACTIVATION
Column Name Description
PaymentRequest Key Number for Payment Request
Column Name Description
Column Name Description
Column Name Description
TransactionDate Planning Date
OffsettingValueDate Offsetting value date
Column Name Description
FinancialAccountType Account type Show values
Column Name Description Domain name
CompanyCode Company Code BUKRS
AmountInTransactionCurrency null
AccountingDocument Document Number of an Accounting Document BELNR
AccountingDocumentItem Number of Line Item Within Accounting Document BUZEI
BusinessArea Business Area GSBER
GLAccount G/L account/internal Cash Mgmt account SKPSK
PaymentMethod List of Respected Payment Methods ZWELS
CashPlanningGroup Planning Group FDGRP
PlanningLevel Planning Level FDLEV
FiscalYear Fiscal Year GJAHR
Partner Business Partner PRQ_PARNO
DocumentItemText Item Text TEXT50
OffsettingCompanyCode Offsetting company code BUKRS
OffsettingAccount Offsetting account GRUPP
OffsettingPlanningLevel Planning Level FDLEV
Master Data Relations Join Conditions
Short Key for a House Bank
  • Short Key for a House Bank
  • Client
  • ?
  • P_CASH_PAYRQ_WO_OFFSET.HOUSEBANK == T012.HBKID
  • P_CASH_PAYRQ_WO_OFFSET.MANDT == T012.MANDT
  • P_CASH_PAYRQ_WO_OFFSET.[column in domain "BUKRS"] == T012.BUKRS
ID for Account Details
  • Short Key for a House Bank
  • Client
  • ID for Account Details
  • ?
  • P_CASH_PAYRQ_WO_OFFSET.HOUSEBANK == T012K.HBKID
  • P_CASH_PAYRQ_WO_OFFSET.MANDT == T012K.MANDT
  • P_CASH_PAYRQ_WO_OFFSET.HOUSEBANKACCOUNT == T012K.HKTID
  • P_CASH_PAYRQ_WO_OFFSET.[column in domain "BUKRS"] == T012K.BUKRS
Origin Indicator P_CASH_PAYRQ_WO_OFFSET.PAYMENTORIGIN == TFIBLORIGIN.ORIGIN
Sending Company Code for Payment Requests
  • Client
  • Sending Company Code for Payment Requests
  • P_CASH_PAYRQ_WO_OFFSET.MANDT == T001.MANDT
  • P_CASH_PAYRQ_WO_OFFSET.SENDINGCOMPANYCODE == T001.BUKRS
Company Code
  • Company Code
  • Company Code
  • Client
  • P_CASH_PAYRQ_WO_OFFSET.COMPANYCODE == T001.BUKRS
  • P_CASH_PAYRQ_WO_OFFSET.SOURCECOMPANYCODE == T001.BUKRS
  • P_CASH_PAYRQ_WO_OFFSET.MANDT == T001.MANDT
User Name
  • Client
  • User Name
  • P_CASH_PAYRQ_WO_OFFSET.MANDT == USR02.MANDT
  • P_CASH_PAYRQ_WO_OFFSET.USERNAME == USR02.BNAME