en EN de DE
topbar test
en EN de DE
Search site...
Wie können wir Ihnen helfen?
< Zurück
Drucken

UnusedGLAccountNumber

Veröffentlicht18. April 2023
Geändert14. May 2024
VonAlexandra Klettenhofer

To search for free numbers via tables T077S or SKA1.

Attention:
Only numeric number ranges are supported.

 

AttributeRequiredDescription
NewColumnNameYesName of the new column with the free G/L account number
KTOPLYesColumn containing the accounting plan for the new search
KTOKSYesColumn containing the account group for the search

 

Beispiel

This example searches for free G/L account numbers for the first 3 numeric number ranges.

--- !SapQuery
Id: AccountGroups
Select:
  T077S~KTOPL
  T077S~KTOKS
  T077S~BISNR
From: T077S
ResultMapping:
  - T077S~KTOPL~AccountingPlan
  - T077S~KTOKS~AccountGroup
  - T077S~BISNR~NrUntil
 
--- !ClientQuery
Id: Numerische
DependsOn: AccountGroups
Statement: Select * FROM AccountGroups Where NrUntil / NrUntil = 1 Limit 3
ResultFilters:
  - UnusedGLAccountNumber:
        NewColumnName: FreeGLNumber
        KTOPL: AccountingPlan
        KTOKS: AccountGroup

Result (excerpt):

AccountingPlanAccountGroupNrUntilFreeGLNumber
CACNANL.001899999916000000
GKRFILC007100000010000000
INTANL.0999999999307
Tags:
Inhaltsverzeichnis