I_SAFTGenLedgerOneTimeSupplier

SAF-T Gen Ledger OneTimeSupplier | view: ISAFTGLOTSUP | Extraction: Not supported | Component: SAF-T Reporting (Generic Part)
Tables used: BSECACDOCABSEGADCPADRCT001TKA02LFB1T001T014FINSC_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
AddressID Address ADRNR
VATRegistration null
CompanyName null
StreetAddressName 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
Master Data Relations Join Conditions
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_SAFTGENLEDGERONETIMESUPPLIER.MANDT == T004.MANDT
  • I_SAFTGENLEDGERONETIMESUPPLIER.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Company Code
  • Client
  • I_SAFTGENLEDGERONETIMESUPPLIER.COMPANYCODE == T001.BUKRS
  • I_SAFTGENLEDGERONETIMESUPPLIER.MANDT == T001.MANDT
Company Code Currency
  • Company Code Currency
  • Client
  • I_SAFTGENLEDGERONETIMESUPPLIER.COMPANYCODECURRENCY == TCURC.WAERS
  • I_SAFTGENLEDGERONETIMESUPPLIER.MANDT == TCURC.MANDT
Country/Region Key
  • Client
  • Country/Region Key
  • I_SAFTGENLEDGERONETIMESUPPLIER.MANDT == T005.MANDT
  • I_SAFTGENLEDGERONETIMESUPPLIER.COUNTRY == T005.LAND1
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_SAFTGENLEDGERONETIMESUPPLIER.GLACCOUNT == SKB1.SAKNR
  • I_SAFTGENLEDGERONETIMESUPPLIER.COMPANYCODE == SKB1.BUKRS
  • I_SAFTGENLEDGERONETIMESUPPLIER.MANDT == SKB1.MANDT
Ledger in General Ledger Accounting
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_SAFTGENLEDGERONETIMESUPPLIER.MANDT == FINSC_LEDGER.MANDT
  • I_SAFTGENLEDGERONETIMESUPPLIER.LEDGER == FINSC_LEDGER.RLDNR
  • I_SAFTGENLEDGERONETIMESUPPLIER.SOURCELEDGER == FINSC_LEDGER.RLDNR
Reconciliation Account in General Ledger
  • Reconciliation Account in General Ledger
  • Client
  • ?
  • I_SAFTGENLEDGERONETIMESUPPLIER.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • I_SAFTGENLEDGERONETIMESUPPLIER.MANDT == SKB1.MANDT
  • I_SAFTGENLEDGERONETIMESUPPLIER.[column in domain "BUKRS"] == SKB1.BUKRS
Region (State, Province, County)
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_SAFTGENLEDGERONETIMESUPPLIER.MANDT == T005S.MANDT
  • I_SAFTGENLEDGERONETIMESUPPLIER.REGION == T005S.BLAND
  • I_SAFTGENLEDGERONETIMESUPPLIER.COUNTRY == T005S.LAND1
Source Ledger
  • Client
  • Ledger in General Ledger Accounting
  • Source Ledger
  • I_SAFTGENLEDGERONETIMESUPPLIER.MANDT == FINSC_LEDGER.MANDT
  • I_SAFTGENLEDGERONETIMESUPPLIER.LEDGER == FINSC_LEDGER.RLDNR
  • I_SAFTGENLEDGERONETIMESUPPLIER.SOURCELEDGER == FINSC_LEDGER.RLDNR
Supplier
  • Client
  • Supplier
  • I_SAFTGENLEDGERONETIMESUPPLIER.MANDT == LFA1.MANDT
  • I_SAFTGENLEDGERONETIMESUPPLIER.SUPPLIER == LFA1.LIFNR