I_OneTimeAccountSupplier

One-Time Account Data for Supplier Items | view: IONETIMESUPPLIER | ATTR | Extraction: Not supported | Component: Information System
Tables used: BSECBSEGT001T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Document Number of an Accounting Document
FiscalYear Fiscal Year
AccountingDocumentItem Number of Line Item Within Accounting Document
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsNaturalPerson Business Partner Is a Natural Person Under the Tax Laws Show values
Column Name Description Domain name
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
  • I_ONETIMEACCOUNTSUPPLIER.COMPANYCODE == T001.BUKRS
  • I_ONETIMEACCOUNTSUPPLIER.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • I_ONETIMEACCOUNTSUPPLIER.MANDT == T005.MANDT
  • I_ONETIMEACCOUNTSUPPLIER.COUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_ONETIMEACCOUNTSUPPLIER.MANDT == T005S.MANDT
  • I_ONETIMEACCOUNTSUPPLIER.REGION == T005S.BLAND
  • I_ONETIMEACCOUNTSUPPLIER.COUNTRY == T005S.LAND1
Supplier
  • Supplier
  • Client
  • I_ONETIMEACCOUNTSUPPLIER.SUPPLIER == LFA1.LIFNR
  • I_ONETIMEACCOUNTSUPPLIER.MANDT == LFA1.MANDT
J_1ATODC
  • Client
  • Tax Number Type
  • I_ONETIMEACCOUNTSUPPLIER.MANDT == J_1ATODC.MANDT
  • I_ONETIMEACCOUNTSUPPLIER.TAXNUMBERTYPE == J_1ATODC.J_1ATODC