I_SAFTGenLedgerCustomer

SAF-T Gen Ledger Customer | view: ISAFTGENLEDCUST | Extraction: Not supported | Component: SAF-T Reporting (Generic Part)
Tables used: ACDOCABKPFBSEGADCPADRCADRPKNVKKNA1KNB1KNB5T001T014FINSC_LEDGER_REP
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Ledger FK Ledger in General Ledger Accounting
Column Name Description
Column Name Description
Column Name Description
PostingDate Posting Date
Column Name Description
AccountingDocumentCategory Journal Entry Category Show values
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
AddressID Address ADRNR
CustomerNum Customer Number KUNNR
AuthorizationGroup Authorization Group BRGRU
StreetName Street TEXT60
StreetPrefixName Street 2 TEXT40
AdditionalStreetPrefixName Street 3 TEXT40
StreetSuffixName Street 4 TEXT40
AdditionalStreetSuffixName Street 5 TEXT40
HouseNumber House Number TEXT10
PartnerFirstName null
PartnerLastName null
DelivOfGoodsDestCountry null
Master Data Relations Join Conditions
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_SAFTGENLEDGERCUSTOMER.CHARTOFACCOUNTS == T004.KTOPL
  • I_SAFTGENLEDGERCUSTOMER.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_SAFTGENLEDGERCUSTOMER.COMPANYCODE == T001.BUKRS
  • I_SAFTGENLEDGERCUSTOMER.MANDT == T001.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • I_SAFTGENLEDGERCUSTOMER.MANDT == T005.MANDT
  • I_SAFTGENLEDGERCUSTOMER.COUNTRY == T005.LAND1
Customer Number
  • Client
  • Customer Number
  • Customer Number
  • I_SAFTGENLEDGERCUSTOMER.MANDT == KNA1.MANDT
  • I_SAFTGENLEDGERCUSTOMER.CUSTOMER == KNA1.KUNNR
  • I_SAFTGENLEDGERCUSTOMER.CUSTOMERNUM == KNA1.KUNNR
G/L Account
  • Company Code
  • Client
  • G/L Account
  • I_SAFTGENLEDGERCUSTOMER.COMPANYCODE == SKB1.BUKRS
  • I_SAFTGENLEDGERCUSTOMER.MANDT == SKB1.MANDT
  • I_SAFTGENLEDGERCUSTOMER.GLACCOUNT == SKB1.SAKNR
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
Reconciliation Account in General Ledger
  • ?
  • Client
  • Reconciliation Account in General Ledger
  • I_SAFTGENLEDGERCUSTOMER.[column in domain "BUKRS"] == SKB1.BUKRS
  • I_SAFTGENLEDGERCUSTOMER.MANDT == SKB1.MANDT
  • I_SAFTGENLEDGERCUSTOMER.RECONCILIATIONACCOUNT == SKB1.SAKNR
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_SAFTGENLEDGERCUSTOMER.MANDT == T005S.MANDT
  • I_SAFTGENLEDGERCUSTOMER.REGION == T005S.BLAND
  • I_SAFTGENLEDGERCUSTOMER.COUNTRY == T005S.LAND1
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger