C_PaymentRequestSupplierVH

Supplier Value Help for Payment Request | view: CPAYREQSUPPVH | Extraction: Not supported | Component: Fiori FXU Accounts Payable FI-FIO-AP
Tables used: BUT000T001TKA02TIBANLFA1LFBKLFB1CVI_VEND_LINK
Column Name Description
Supplier Account Number of Supplier
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
SupplierName Name of Supplier TEXT80
VATRegistration VAT Registration Number STCEG
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
CityName City TEXT35
PostalCode Postal Code PSTLZ
StreetName Street and House Number TEXT35
PhoneNumber1 First telephone number TEXT16
PhoneNumber2 Second telephone number TEXT16
FaxNumber Fax Number TEXT31
AuthorizationGroup Authorization Group BRGRU
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
BankControlKey Bank Control Key BKONT
IBAN IBAN (International Bank Account Number) IBAN
BankAccountHolderName Account Holder Name KOINH
SearchTerm1 Search Term CHAR20
Master Data Relations Join Conditions
Country/Region Key of Bank
  • Client
  • Country/Region Key of Bank
  • C_PAYMENTREQUESTSUPPLIERVH.MANDT == T005.MANDT
  • C_PAYMENTREQUESTSUPPLIERVH.BANKCOUNTRY == T005.LAND1
Company Code
  • Client
  • Company Code
  • C_PAYMENTREQUESTSUPPLIERVH.MANDT == T001.MANDT
  • C_PAYMENTREQUESTSUPPLIERVH.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • C_PAYMENTREQUESTSUPPLIERVH.COUNTRY == T005.LAND1
  • C_PAYMENTREQUESTSUPPLIERVH.MANDT == T005.MANDT
Industry key
  • Client
  • Industry key
  • C_PAYMENTREQUESTSUPPLIERVH.MANDT == T016.MANDT
  • C_PAYMENTREQUESTSUPPLIERVH.INDUSTRY == T016.BRSCH
Vendor account group
  • Client
  • Vendor account group
  • C_PAYMENTREQUESTSUPPLIERVH.MANDT == T077K.MANDT
  • C_PAYMENTREQUESTSUPPLIERVH.SUPPLIERACCOUNTGROUP == T077K.KTOKK
Language Key C_PAYMENTREQUESTSUPPLIERVH.SUPPLIERLANGUAGE == T002.SPRAS
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • C_PAYMENTREQUESTSUPPLIERVH.MANDT == TTXJ.MANDT
  • C_PAYMENTREQUESTSUPPLIERVH.TAXJURISDICTION == TTXJ.TXJCD
  • C_PAYMENTREQUESTSUPPLIERVH.[column in domain "TAX_KALSM"] == TTXJ.KALSM
Possible Checks for Tax Number 1
  • Client
  • Tax Number Type
  • C_PAYMENTREQUESTSUPPLIERVH.MANDT == J_1ATODC.MANDT
  • C_PAYMENTREQUESTSUPPLIERVH.TAXNUMBERTYPE == J_1ATODC.J_1ATODC