I_SAFTAccountingCustomer

SAF-T Regular Accounting Customers | view: ISAFTACCTGCUST | Extraction: Not supported | Component: SAF-T Reporting (Generic Part)
Tables used: BSEGADRPKNVKKNA1KNB1KNB5T001T014
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
IsOneTimeAccount Indicator: Is the account a one-time account? Show values
Column Name Description Domain name
VATRegistration VAT Registration Number STCEG
TaxNumber1 Tax Number 1 STCD1
TaxNumber2 Tax Number 2 STCD2
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
CityName City TEXT35
PostalCode Postal Code PSTLZ
StreetName Street and House Number TEXT35
AddressID Address ADRNR
CustomerNum Customer Number KUNNR
AuthorizationGroup Authorization Group BRGRU
PartnerFirstName null
PartnerLastName null
DelivOfGoodsDestCountry null
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_SAFTACCOUNTINGCUSTOMER.MANDT == T003.MANDT
  • I_SAFTACCOUNTINGCUSTOMER.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Company Code
  • Company Code
  • Client
  • I_SAFTACCOUNTINGCUSTOMER.COMPANYCODE == T001.BUKRS
  • I_SAFTACCOUNTINGCUSTOMER.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_SAFTACCOUNTINGCUSTOMER.COUNTRY == T005.LAND1
  • I_SAFTACCOUNTINGCUSTOMER.MANDT == T005.MANDT
Customer Number
  • Customer Number
  • Customer Number
  • Client
  • I_SAFTACCOUNTINGCUSTOMER.CUSTOMERNUM == KNA1.KUNNR
  • I_SAFTACCOUNTINGCUSTOMER.CUSTOMER == KNA1.KUNNR
  • I_SAFTACCOUNTINGCUSTOMER.MANDT == KNA1.MANDT
Reconciliation Account in General Ledger
  • Reconciliation Account in General Ledger
  • Company Code
  • Client
  • I_SAFTACCOUNTINGCUSTOMER.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • I_SAFTACCOUNTINGCUSTOMER.COMPANYCODE == SKB1.BUKRS
  • I_SAFTACCOUNTINGCUSTOMER.MANDT == SKB1.MANDT