I_SAFTGenLedgerOneTimeCustomer

SAF-T Gen Ledger One Time Customer | view: ISAFTGENLEDOTC | Extraction: Not supported | Component: SAF-T Reporting (Generic Part)
Tables used: BSECACDOCABSEGADCPADRCADR6ADR3ADR12ADR2KNB1KNB5T001T014FINSC_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
Column Name Description Domain name
AccountingDocumentItem Journal Entry Posting View Item BUZEI
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
POBox PO Box PFACH
POBoxPostalCode P.O. Box 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
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_SAFTGENLEDGERONETIMECUSTOMER.CHARTOFACCOUNTS == T004.KTOPL
  • I_SAFTGENLEDGERONETIMECUSTOMER.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_SAFTGENLEDGERONETIMECUSTOMER.COMPANYCODE == T001.BUKRS
  • I_SAFTGENLEDGERONETIMECUSTOMER.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • I_SAFTGENLEDGERONETIMECUSTOMER.MANDT == TCURC.MANDT
  • I_SAFTGENLEDGERONETIMECUSTOMER.COMPANYCODECURRENCY == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Client
  • I_SAFTGENLEDGERONETIMECUSTOMER.COUNTRY == T005.LAND1
  • I_SAFTGENLEDGERONETIMECUSTOMER.MANDT == T005.MANDT
Customer Number
  • Customer Number
  • Client
  • I_SAFTGENLEDGERONETIMECUSTOMER.CUSTOMER == KNA1.KUNNR
  • I_SAFTGENLEDGERONETIMECUSTOMER.MANDT == KNA1.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_SAFTGENLEDGERONETIMECUSTOMER.GLACCOUNT == SKB1.SAKNR
  • I_SAFTGENLEDGERONETIMECUSTOMER.COMPANYCODE == SKB1.BUKRS
  • I_SAFTGENLEDGERONETIMECUSTOMER.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_SAFTGENLEDGERONETIMECUSTOMER.MANDT == FINSC_LEDGER.MANDT
  • I_SAFTGENLEDGERONETIMECUSTOMER.LEDGER == FINSC_LEDGER.RLDNR
  • I_SAFTGENLEDGERONETIMECUSTOMER.SOURCELEDGER == FINSC_LEDGER.RLDNR
Reconciliation Account in General Ledger
  • ?
  • Reconciliation Account in General Ledger
  • Client
  • I_SAFTGENLEDGERONETIMECUSTOMER.[column in domain "BUKRS"] == SKB1.BUKRS
  • I_SAFTGENLEDGERONETIMECUSTOMER.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • I_SAFTGENLEDGERONETIMECUSTOMER.MANDT == SKB1.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • I_SAFTGENLEDGERONETIMECUSTOMER.COUNTRY == T005S.LAND1
  • I_SAFTGENLEDGERONETIMECUSTOMER.REGION == T005S.BLAND
  • I_SAFTGENLEDGERONETIMECUSTOMER.MANDT == T005S.MANDT
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_SAFTGENLEDGERONETIMECUSTOMER.MANDT == FINSC_LEDGER.MANDT
  • I_SAFTGENLEDGERONETIMECUSTOMER.LEDGER == FINSC_LEDGER.RLDNR
  • I_SAFTGENLEDGERONETIMECUSTOMER.SOURCELEDGER == FINSC_LEDGER.RLDNR