Transcript PowerPoint-presentatie

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