C_PaymentRequestCustomerVH

Customer Value Help for Payment Request | view: CPAYREQCUSVH | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP
Tables used: BUT000KNA1KNBKKNB1KNB5CVI_CUST_LINKTIBAN
Column Name Description
Customer Customer ID
CompanyCode FK Company Code
BankCountry FK Country/Region Key of Bank
Bank Bank Keys
BankAccount Bank account number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
PayeeBankAccount Bank account number BANKN
CustomerName Name of Customer TEXT80
VATRegistration VAT Registration Number STCEG
StreetName Street and House Number TEXT35
CityName City TEXT35
PostalCode Postal Code PSTLZ
TelephoneNumber1 First telephone number TEXT16
TelephoneNumber2 Second telephone number TEXT16
FaxNumber Fax Number TEXT31
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
AuthorizationGroup Authorization Group BRGRU
BPBankAccountInternalID Customer Bank Details ID BVTYP
BankControlKey Bank Control Key BKONT
SearchTerm1 Search Term CHAR20
IBAN IBAN (International Bank Account Number) IBAN
BankAccountHolderName Account Holder Name KOINH
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • C_PAYMENTREQUESTCUSTOMERVH.BANKCOUNTRY == T005.LAND1
  • C_PAYMENTREQUESTCUSTOMERVH.MANDT == T005.MANDT
Company Code
  • Company Code
  • Client
  • C_PAYMENTREQUESTCUSTOMERVH.COMPANYCODE == T001.BUKRS
  • C_PAYMENTREQUESTCUSTOMERVH.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_PAYMENTREQUESTCUSTOMERVH.COUNTRY == T005.LAND1
  • C_PAYMENTREQUESTCUSTOMERVH.MANDT == T005.MANDT
Customer Account Group
  • Customer Account Group
  • Client
  • C_PAYMENTREQUESTCUSTOMERVH.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_PAYMENTREQUESTCUSTOMERVH.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • C_PAYMENTREQUESTCUSTOMERVH.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • C_PAYMENTREQUESTCUSTOMERVH.MANDT == TKUKL.MANDT
Industry key
  • Industry key
  • Client
  • C_PAYMENTREQUESTCUSTOMERVH.INDUSTRY == T016.BRSCH
  • C_PAYMENTREQUESTCUSTOMERVH.MANDT == T016.MANDT
Language Key C_PAYMENTREQUESTCUSTOMERVH.LANGUAGE == T002.SPRAS
Tax Jurisdiction
  • Tax Jurisdiction
  • ?
  • Client
  • C_PAYMENTREQUESTCUSTOMERVH.TAXJURISDICTION == TTXJ.TXJCD
  • C_PAYMENTREQUESTCUSTOMERVH.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • C_PAYMENTREQUESTCUSTOMERVH.MANDT == TTXJ.MANDT
J_1ATODC
  • Client
  • Tax Number Type
  • C_PAYMENTREQUESTCUSTOMERVH.MANDT == J_1ATODC.MANDT
  • C_PAYMENTREQUESTCUSTOMERVH.TAXNUMBERTYPE == J_1ATODC.J_1ATODC