A selection of useful ISU tables DFKKZK Payment
A selection of useful ISU tables DFKKZK Payment lots KEYZ 1 FIKEY DFKKZF Payment lot, reconciliaton key KEYZ 1 FIKEY DFKKRF Returns lot, reconciliaton key FIKEY KEYR 1 DFKKZP Payment lot data KEYZ 1 POSZA OPBEL DFKKSUMC Control details for posting totals FIKEY DFKKSUM Posting totals FIKEY DFKKRK Returns lot FIKEY KEYR 1 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 BUT 050 Business Partner relationships RELNR PARTNER 1 PARTNER 2 RELTYP BUT 100 Business Partner roles PARTNER RLTYP BUT 020 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 KEYR 1 POSRA OPBEL FKKMAKO Dunning header OPBEL TFK 050 B 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. BILLDOCLINE PRINTDOC DFKKRAPT Clearing / reversal history lines OPBEL STBLG AUGBL DFKKLOCKS Business locks VKONT GPART BUT 000 Business Partner PARTNER BUT 0 BK Business partner bank details BANKS BANKL BANKN PARTNER ADRC Addresses EPREI EABP Budget billing plan OPBEL VERTRAG VKONT EKDI Rate facts ETTAF Rate category facts TE 221 Operands OPERAND EPREI Prices header 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 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 CITYP_CODE Non Key fields ETRF Rates RTPINTERFACE TARIFNR ETTA Rate category TARIFTYP ERTFND Rate determination TARIFNR TARIFTYP TARIFART EASTS Installation - register ETTIF / ETTIFN / ETTIFB Installation facts LOGIKZW TARIFART BIS ANLAGE TE 069 Rate types TARIFART EZUZ Dev alloc for register EPREI EOUTL_CON Outline contracts LOGIKZW LOGIKNR 2 EOUTL_ASSIGN Outline contract assignment EASTL Installation - device EOUTL_CON VERTRAG EVER Contract EANL Installation VERTRAG ANLAGE VKONTO 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 TECHNICAL MASTER DATA VSTELLE HAUS EABLG Meter reading document HAUS ABLBELNR ANLAGE ABLEINH PORTION ERTPIFACEINP RTP interface input parameters RTPCOMP RTPINTERFACE PROFROLE EADZ Multiple inst. billing data: registers TE 422 Meter reading units TE 417 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 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. . . EFORMULAINST Formula instances PROFVERSNO ETDZ Registers EUILZW Register - Po. D 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 EQUNR EQUI Equipment EGERR Device Info for Po. D PROFILE PROFROLE LOGIKZW EZUG Device alloc for device TERMSCHL LOGIKNR 2 TE 419 Parameter records TERMSCHL PARASATZ TERMSCHL EGRID Grids GRID_ID EPROFHEAD Profiles EPROFASSROLE Roles for profile allocation EGRIDPOD of grid GRID_ID INT_UI EGRIDH Distributor - Grid EDEXPROC Data exchange processes GRID_ID DISTRIBUTOR DEXPROC DEXBASICPROC © P. Johnston 2002 - EPROFVALSTAT Profile status PROFILE STAT EPROFVALxx Profile values in xx min intervals PROFILE EEDMSETTL DOCRUN Settlement doc run SETTLDOCRUN EEDMSETTLPROC Settlement procedure SETTLPROCESS EEDMSETTLDOCEDM SETTLEMENT Settlement document SETTLDOC SETTLPROCESS SETTLDOCSEL. . EEDMSETTLDOC VARI Selection VARH Header variant selection variant SETTLDOCSEL. . INT_UI LOW SETTLDOCSEL. . HIGH EEDMSETTL UNITPOD of Settle. unit SETTLUNIT INT_UI DEVICE MANAGEMENT EUITRANS Po. D Internal to external IDs EXT_UI INT_UI EUIHEAD Po. Ds EEDM SETTLUNIT Settlement unit SETTLUNIT SETTLCOORD SETTLTRANSCO EEDMUISETTLUNIT SETTLSUPPLIER Allocation of PODs ESERVPROVP to Settl. unit Service provider INT_UI /vendor SETTLUNIT SERVICEID GPART ESERVICE Po. D - Service VERTRAG INT_UI SERVICEID SERVICE ESERVPROV Service provider SERVICEID SERVICE TECDE Services SERVICE EUIGRID Allocation of Po. Ds EDEXTASKWKFLOW EDEXTASKIDOC to grid Work items for data IDOCs for data INT_UI exchange tasks GRID_ID DEXTASKID DEXTASKWFLFDNR DEXTASKIDOC EGRIDVL Voltage level of Grids GRID_ID SPEBENE PROFVERSNO PROFILE PROFROLE EUILNR Device - Po. D TE 418 Schedule records Meter reading units TE 420 Portions EPROFASS Registers profiles EQUNR LOGIKNR MATNR GERAET EEDMFORMHEAD Formulas FORMULA INSTANCE_N. . . EFORMULA INSTPMO/I Profiles– formula inst. EPROFVERSHEAD Profile version INSTANCE_N. . . values header PROFILENR INT_UI EGRIDL Grid levels GRID_ID EDM PROFILES LOGIKZW INT_UI LOGIKNR TERMSCHL PORTION EUIINSTLN Installation Po. D ERTPIFACECOMP RTP interface component INT_UI ANLAGE IFLOT Functional location REGIONAL STRUCTURE ETRG Billing orders EABL Meter reading reasons PM ILOA PM object loc. BILLING MASTER DATA TARIFTYP OPERAND TARIFART ANLAGE BIS EOUTL_CON EEIN/EAUS Move in/out doc. for contr. account EIN/AUSZBELEG VKONT COUNTRY CITY_CODE Key fields SCHEMANR BELZEILE 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 EDIDC IDOC headers DOCNUM EDID 4 IDOC data EDEXTASKREF DOCNUM EDEXTASK Data exchange tasks reference DEXTASKID EIDESWTDOC INT_UI DEXTASKREFVAL Switch document DEXPROC EIDESWTDOCSTEP SWITCHDOC EDEXBASICPROC Switch document POD Data exchange steps basic processes SWITCHDOCINTERCOMPANY DEXBASICPROC STEPKEY DATA EXCHANGE
- Slides: 1