Transcript ISU_tables - SAP Alles

A selection of useful ISU tables
BILLING & INVOICING
DFKKZK
Payment lots
DFKKZP
Payment lot data
KEYZ1
FIKEY
KEYZ1
POSZA
OPBEL
DFKKZF
Payment lot,
reconciliaton key
KEYZ1
FIKEY
DFKKSUMC
Control details for
posting totals
FIKEY
DFKKRF
Returns lot,
reconciliaton key
FIKEY
KEYR1
DFKKRK
Returns lot
FIKEY
KEYR1
DFKKSUM
Posting totals
ERDO
Outsorting for
invoices
OPBEL
OUTCNSOL
ERDB
CA document for
print document
OPBEL
INVOPBEL
ERCHC
Invoicing /
reversal history
BELNR
OPBEL
ERDK
Print doc header
OPBEL
DFKKRAPT
Clearing / reversal
history lines
AUGBL
OPBEL
STBLG
FIKEY
DFKKRP
Returns lot data
KEYR1
POSRA
OPBEL
FKKMAZE
Dunning
items
LAUFD
LAUFI
OPBEL
FKKMAKO
Dunning
history
LAUFD
LAUFI
DFKKCOLLH
Collectiion
history
OPBEL
INKGP
TFK050B
Collectiion
agencies
INKGP
ERCHO
Outsorting for
billing doc
BELNR
OUTCNSOL
FKK_INSTPLN_HEAD
Installment plan
header
RPNUM
DFKKKO
CA document
header
FIKEY
OPBEL
DFKKMKO
Sample CA
document header
OPBEL
DFKKCOLL
Collectiion
DFKKOPK
CA document
G/L items
OPBEL
OPUPK
DFKKMOPK
Sample CA
document G/L items
OPBEL
OPUPK
OPBEL
INKGP
DFKKCRP
Creditworthiness
positions
GPART
KJAHR
CS
DFKKCRH
Creditworthiness
header
GPART
KJAHR
EKUN
IS-U Business
Partner data
PARTNER
BUSINESS MASTER DATA
BUT050
Business Partner
relationships
RELNR
PARTNER1
PARTNER2
RELTYP
BUT100
Business
Partner roles
PARTNER
RLTYP
BUT020
Business
Partner address
PARTNER
ADDRNUMBER
REGIONAL STRUCTURE
FI-CA
DFKKLOCKS
Business locks
VKONT
GPART
BUT000
Business
Partner
PARTNER
BUT0BK
Business partner
bank details
PARTNER
BANKS
BANKL
BANKN
ADRC
Addresses
ADDRNUMBER
COUNTRY
CITY_CODE
CITYP_CODE
STREET_CODE
ERCH
Billing doc header
DBERCHZ(1-8)
Billing doc lines
BELNR
GPARTNER
VKONT
VERTRAG
BELNR
BELZEILE
TARIFNR
TARIFTYP
EPREI
DBERDLB
Billing doc –
print doc line ref.
BILLDOC
BILLDOCLINE
PRINTDOCLINE
PRINTDOC
BILLING
MASTER DATA
ESCHS
Billing schema
steps
SCHEMANR
TARIFNR
EKDI
Rate facts
TARIFNR
OPERAND
DBERDL
Print doc lines
BELZEILE
OPBEL
TE221
Operands
OPERAND
FKK_INSTPLN_HIST
Installment plan
history
OPBEL
RPNUM
EPREIH
Price history
EPREI
Prices header
EPREI
EPREI
DFKKKOP
CA document
items
OPBEL
OPUPK
OPUPW
OPUPZ
DFKKOPW
CA document
rep. items
OPBEL
WHGRP
OPUPW
DFKKMOP
Sample CA
document items
OPBEL
OPUPK
OPUPW
OPUPZ
DFKKMOPW
Sample CA document
rep. items
OPBEL
WHGRP
OPUPW
EEIN/EAUS
Move in/out doc.
for contr. account
EIN/AUSZBELEG
VKONT
EEINV/EAUSV
Move in/out doc.
for contract
EIN/AUSZBELEG
VERTRAG
FKKVKP
Contract
account for partner
VKONT
GPART
FKKVK
Contract
account
VKONT
BCONT
Business
Contact
PARTNER
BCONT
ILOA
PM object loc.
ADRNR
TPLNR
ILOAN
ADRCITY
Cities
COUNTRY
CITY_CODE
ADRPSTCODE
Postal codes
ADRCITYPRT
Postal districts
ADRSTREET
Streets
COUNTRY
POST_CODE
COUNTRY
POST_CODE
CITY_CODE
CITYP_CODE
COUNTRY
STRT_CODE
CITY_CODE
CITYP_CODE
ESCH
Billing schema
header
SCHEMANR
EOUTL_CON
Outline contracts
EOUTL_CON
ETTAF
Rate category
facts
TARIFTYP
OPERAND
ETTIF / ETTIFN
/ ETTIFB
Installation facts
OPERAND
TARIFART
ANLAGE
BIS
ETRF
Rates
ETTA
Rate category
TARIFTYP
TE069
Rate types
EVBS
Premise
EHAUISU
Connection object
VSTELLE
HAUS
ANLAGE
VSTELLE
TECHNICAL
MASTER DATA
PM
IFLOT
Functional location
EABLG
Meter reading
reasons
ANLAGE
ABLBELNR
EGPLTX
Device locations
DEVLOC
TPLNR
ILOAN
ADRCITYKON
Franchise contracts
for cities
COUNTRY
CITY_CODE
ADRSTRTKON
Franchise contracts
for streets
COUNTRY
STRT_CODE
ADRCITYCCS
Division data
for cities
COUNTRY
CITY_CODE
ADRSTRTCCS
Division data
for streets
COUNTRY
STRT_CODE
ADRCITYMRU
Meter reading units
for cities
COUNTRY
CITY_CODE
ABLEINH
ADRSTRTMRU
Meter reading units
for streets
COUNTRY
STRT_CODE
ABLEINH
ERTFND
Rate
determination
TARIFNR
TARIFTYP
TARIFART
EASTS
Installation
- register
LOGIKZW
TARIFART
BIS
ANLAGE
EPROFASS
Registers profiles
PROFILE
PROFROLE
LOGIKZW
EASTI
Register relationships
LOGIKZW
INDEXNR
LOGIKZW
ZWNUMMER
EQUNR
EASTL
Installation
- device
LOGIKNR
BIS
TARIFART
ANLAGE
EANLH
Installation
time slice
TARIFTYP
BIS
ANLAGE
ABLEINH
ETYP
Device category
/ material data
MATNR
TE422
Meter reading units
ABLEINH
PORTION
ANLAGE
TERMSCHL
PORTION
TE417
Schedule records
for portions
TERMSCHL
EDISCDOC
Disconnection object
DISCNO
DISCOBJ
ANLAGE
DISCNO
FORMULA
FORMULA
INSTANCE_N...
EFORMULA
INSTPMO/I
Profiles– formula inst.
INSTANCE_N...
PROFILENR
EFORMULA
TRIGKMP/TMP
Formula triggers
INSTANCE_N...
EPROFVERSHEAD
Profile version
header
PROFVERSNO
PROFILE
EPROFVERSHEAD
Profile version
values
PROFVERSNO
EPROFASSROLE
Roles for
profile allocation
PROFROLE
EPROFVALxx
Profile values in
xx min intervals
PROFILE
EGERS
Master
device data
EQUNR
EGERR
Device Info
for PoD
EQUNR
LOGIKNR
GERAET
MATNR
EQUI
Equipment
EEDMSETTL
DOCRUN
Settlement doc run
SETTLDOC
SETTLDOCRUN
EEDMSETTLDOC
Settlement
document
SETTLDOC
SETTLPROCESS
SETTLDOCSEL..
EEDMSETTLPROC
Settlement
procedure
SETTLPROCESS
EEDMSETTLDOC
VARH Header
selection variant
INT_UI
SETTLDOCSEL..
EQUNR
PM
EUILNR
Device
- PoD
INT_UI
LOGIKNR
TE418
Schedule records
Meter reading units
TERMSCHL
TE420
Portions
DEVICE
MANAGEMENT
TERMSCHL
PARASATZ
LOGIKNR
LOGIKNR2
TERMSCHL
ESERVICE
PoD - Service
EUIHEAD
PoDs
EUITRANS
PoD Internal
to external IDs
INT_UI
EXT_UI
CUSTOMER
SERVICE
EGRID
Grids
GRID_ID
GRID_ID
EGRIDVL
Voltage level
of Grids
GRID_ID
SPEBENE
EGRIDH
Distributor - Grid
GRID_ID
DISTRIBUTOR
STRT_CODE
GRID_ID
© P. Johnston 2002-2006
PROFILE
STAT
EDM SETTLEMENT
EEDMSETTLDOC
VARI Selection
variant
SETTLDOCSEL..
LOW
HIGH
EEDM
SETTLUNIT
Settlement unit
SETTLUNIT
SETTLCOORD
SETTLTRANSCO
SETTLSUPPLIER
ESERVPROVP
Service provider
/vendor
SERVICEID
GPART
ESERVPROV
Service provider
SERVICEID
SERVICE
SERVICE
EDEXTASKWKFLOW
Work items for data
exchange tasks
DEXTASKID
DEXTASKWFLFDNR
EGRIDPOD
POD of grid
EDEXTASK
Data exchange tasks
GRID_ID
INT_UI
DEXTASKID
INT_UI
DEXPROC
EDEXPROC
Data exchange
processes
DEXPROC
DEXBASICPROC
Application data tables
VERTRAG
INT_UI
SERVICEID
SERVICE
EPROFVALSTAT
Profile value status
TECDE
Services
EUIGRID
Allocation of PoDs
to grid
INT_UI
GRID_ID
EGRIDL
Grid levels
EEDMSETTL
UNITPOD
POD of Settle. unit
SETTLUNIT
INT_UI
EEDMUISETTLUNIT
Allocation of PODs
to Settl. unit
INT_UI
SETTLUNIT
EZUG
Device alloc for
device
TE419
Parameter records
EADRCITYGRID
Grids to cities
EADRSTRTGRID
Grids to streets
FORMULA
PARNUMBER
INT_UI
EDISCOBJ
Disconnection object
COUNTRY
CITY_CODE
GRID_ID
EFORMULAINST
Formula instances
PROFILE
ZWGRUPPE
ZWNUMMER
EGERH
Historical
device data
ZWGRUPPE
EQUNR
LOGIKNR
SCHEDULING
ETRG
Billing orders
EUIINSTLN
Installation PoD
INT_UI
ANLAGE
EEDMFORMHEAD
Formulas
EPROFHEAD
Profiles
EUILZW
Register
- PoD
LOGIKZW
INT_UI
ETDZ
Registers
EEDMFORMPAR
Formula parameters
EZWG
Register group
LOGIKZW
LOGIKNR2
HAUS
EABL
Meter reading
document
ABLBELNR
ERTPIFACEINP
RTP interface
input parameters
RTPCOMP
RTPINTERFACE
PROFILE
PROFROLE
EADZ
Multiple inst. billing
data: registers
LOGIKZW
EZUZ
Dev alloc for register
OPBEL
VERTRAG
VERTRAG
ANLAGE
VKONTO
ERTPIFACECOMP
RTP interface
component
RTPCOMP
RTPINTERFACE
TARIFART
EOUTL_ASSIGN
Outline contract
assignment
EOUTL_CON
VERTRAG
EANL
Installation
RTPINTERFACE
FORMULA
RTPINTERFACE
TARIFNR
EABP
Budget billing plan
EVER
Contract
EDM PROFILES
ERTPIINTERFACE
RTP interface
EDEXBASICPROC
Data exchange
basic processes
DEXBASICPROC
Customizing data tables
EDEXTASKIDOC
IDOCs for data
exchange tasks
DEXTASKID
DEXTASKIDOC
EDEXTASKREF
Data exchange task
reference
DEXTASKID
DEXTASKREFVAL
EIDESWTDOCSTEP
Switch document
steps
SWITCHDOC
STEPKEY
Key fields
EDIDC
IDOC headers
DOCNUM
EDID4
IDOC data
DOCNUM
EIDESWTDOC
Switch document
SWITCHDOC
POD
INTERCOMPANY
Non Key fields