I_SAFTAcctgOneTimeCustomer

SAF-T Accounting OneTimeCustomers | view: ISAFTACCTGOTC | TRAN | Extraction: Not supported | Component: SAF-T Reporting (Generic Part)
Tables used: BSECBSEGADCPADRCADR6ADR3ADR12ADR2KNB1KNB5T001T014
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
Column Name Description Domain name
CustomerVATRegistration null
CompanyName null
StreetName Street TEXT60
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
HouseNumber House Number TEXT10
CityName City TEXT40
PostalCode Postal Code PSTLZ
AddressID Address ADRNR
PhoneNumber Telephone no.: dialling code+number CHAR30
FaxNumber Fax number: dialling code+number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
WebsiteURL URI address search field CHAR50
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_SAFTACCTGONETIMECUSTOMER.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_SAFTACCTGONETIMECUSTOMER.MANDT == T003.MANDT
Company Code
  • Company Code
  • Client
  • I_SAFTACCTGONETIMECUSTOMER.COMPANYCODE == T001.BUKRS
  • I_SAFTACCTGONETIMECUSTOMER.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • I_SAFTACCTGONETIMECUSTOMER.MANDT == T005.MANDT
  • I_SAFTACCTGONETIMECUSTOMER.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • I_SAFTACCTGONETIMECUSTOMER.MANDT == KNA1.MANDT
  • I_SAFTACCTGONETIMECUSTOMER.CUSTOMER == KNA1.KUNNR
Reconciliation Account in General Ledger
  • Company Code
  • Client
  • Reconciliation Account in General Ledger
  • I_SAFTACCTGONETIMECUSTOMER.COMPANYCODE == SKB1.BUKRS
  • I_SAFTACCTGONETIMECUSTOMER.MANDT == SKB1.MANDT
  • I_SAFTACCTGONETIMECUSTOMER.RECONCILIATIONACCOUNT == SKB1.SAKNR
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_SAFTACCTGONETIMECUSTOMER.MANDT == T005S.MANDT
  • I_SAFTACCTGONETIMECUSTOMER.REGION == T005S.BLAND
  • I_SAFTACCTGONETIMECUSTOMER.COUNTRY == T005S.LAND1