P_ONETMEACCOUNTSUPLR

One time vendor payments to suppliers | view: PGRCDSMLTPLPAY | Extraction: Not supported | Component: Information System
Tables used: BSECBKPFBSEGT001T014
Column Name Description
Supplier FK Supplier
CompanyCode FK Company Code
JournalEntry Document Number of an Accounting Document
FiscalYear Fiscal Year
JournalEntryItem Number of Line Item Within Accounting Document
Column Name Description
Column Name Description
Column Name Description
JournalEntryCreationDate Accounting Document Entry Date
Column Name Description
IsNaturalPerson Business Partner Is a Natural Person Under the Tax Laws Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
Column Name Description Domain name
JournalEnrtyUniqueID null
BusinessPartnerName1 Name 1 TEXT40
BusinessPartnerName2 Name 2 TEXT40
BusinessPartnerName3 Name 3 TEXT40
BusinessPartnerName4 Name 4 TEXT40
CityName City TEXT40
POBox PO Box PFACH
POBoxPostalCode P.O. Box Postal Code PSTLZ
PostalCode Postal Code PSTLZ
TaxID1 Tax Number 1 STCD1
TaxID2 Tax Number 2 STCD2
TaxID3 Tax Number 3 CHAR18
TaxID4 Tax Number 4 CHAR18
TaxID5 Tax Number 5 CHAR60
StreetAddressName Street and House Number TEXT35
AddressID Address ADRNR
AccountingClerkInternetAddress Internet address of partner company clerk TXT130
AuthorizationGroup Authorization Group BEGRU
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_ONETMEACCOUNTSUPLR.COMPANYCODE == T001.BUKRS
  • P_ONETMEACCOUNTSUPLR.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • P_ONETMEACCOUNTSUPLR.COUNTRY == T005.LAND1
  • P_ONETMEACCOUNTSUPLR.MANDT == T005.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • P_ONETMEACCOUNTSUPLR.COUNTRY == T005S.LAND1
  • P_ONETMEACCOUNTSUPLR.REGION == T005S.BLAND
  • P_ONETMEACCOUNTSUPLR.MANDT == T005S.MANDT
Supplier
  • Supplier
  • Client
  • P_ONETMEACCOUNTSUPLR.SUPPLIER == LFA1.LIFNR
  • P_ONETMEACCOUNTSUPLR.MANDT == LFA1.MANDT
J_1ATODC
  • Tax Number Type
  • Client
  • P_ONETMEACCOUNTSUPLR.TAXNUMBERTYPE == J_1ATODC.J_1ATODC
  • P_ONETMEACCOUNTSUPLR.MANDT == J_1ATODC.MANDT