SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5INV1265A/R Invoice - Rows
6OJDT100Journal Entry
7OPCH386A/P Invoice
8OVTG52Tax Definition
9OPOR386Purchase Order
10JDT1124Journal Entry - Rows

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

63 columns | Print definition?ERP 6.0  | INTNR

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNVTDMS_05_DFKOOI Extraction TDMS for ISU5INTNRPERBL für TDTIMnvarchar70
2ODTF_IDOC_LOG_PJLog for Project WBS Element Replication via IDOC to CfTE10INTNRnvarchar80
3P2NZ_LVAWEPayroll Result: Leave Entitlement LVAWE - NZ9INTNRWage Type Internal Number - NZnvarchar40
4TNRT3Test no.ranges:with,w/o subobj.;indep.grp; 2 no.range fields2INTNRNumber range numbernvarchar20
5TNRT6Test no.ranges:with,w/o subobj.;indep.grp; 2 no.range fields2INTNRNumber range numbernvarchar20
6TNRT8Test no.ranges:with subobject;dep.group;2 no.range fields3INTNRNumber range numbernvarchar20
7TNRT8ATest no.ranges:with subobject;dep.group;2 no.range fields3INTNRNumber range numbernvarchar20
8PIQDBAGM_INTTransfer Regulations: Internal Work and Qualifications3INTNRSequence Number of Internal Academic Achievementnvarchar30
TOPAustralia
9T5QLRLeave Accrual Rules Australia16INTNRInternal Number for Leave Type Assignmentnvarchar40
TOPBasic Functions
10EMMA_CASEClarification Case5INTNRNumber of Job Intervalint100
11EMMA_HDRPrepared Application Logs14INTNRNumber of Job Intervalint100
12EMMA_INTPrepared Intervals in Application Logs3INTNRNumber of Job Intervalint100
TOPCollectionsDisbursements
13VVKKISUMIOBBal. Interest Calc. Acc. to Ins. Obj.: Interest Total4INTNRNumber of interval within variantint100
TOPContract Accounts Receivable and Payable
14DFKKCIBWFICA: Extraction of Cleared Items4INTNRNumber of Interval within Variant (BW Extraction)nvarchar70
15DFKKCOLLP_IM_WBuffer: Coll. Agency Info File (Item Master Data Change)5INTNRInterval Numbernvarchar100
16DFKKCOLLP_IP_WBuffer: Collection Agency Info File (Item for Payments)5INTNRInterval Numbernvarchar100
17DFKKCOLLP_IR_WBuffer: Collection Agency Info File (Item for Callback)5INTNRInterval Numbernvarchar100
18DFKKDOUBTD_RET_WBuffer: Printout for Ind.Val.Ad - Return Values (User Event)4INTNRInterval Numbernvarchar100
19DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment4INTNRInterval Numbernvarchar100
20DFKKOPBWOI Extraction4INTNRNumber of Interval within Variant (BW Extraction)nvarchar70
21DFKKOP_REHExports of Open Items from FPO43INTNRNumber of interval within variantint100
22DFKKOP_REPOpen Items from FPO43INTNRNumber of interval within variantint100
23DFKKRPLLink from Mass Run Interval for Application Log5INTNRNumber of interval within variantint100
24DFKKSTATTable for Temporary Statistics Data, for Mass Activities5INTNRNumber of interval within variantint100
25DFKKZWFPTLog Table for Mass Activ. for Tfr Posting of Dbt Rec/IVAs4INTNRNumber of interval within variantint100
26DFKKZWPTLog Table for Mass Activ. for Tfr Posting of Dbt Rec/IVAs4INTNRNumber of interval within variantint100
27FKKDIPOSFI-CA: Distribution of intervals - items4INTNRNumber of interval within variantint100
28FKKDIPOTMPFI-CA: Distrib. of intervals - temporal copy of items4INTNRNumber of interval within variantint100
29FKKDIPOTMPCOUNTFI-CA: Counter for Each Entry from FKKDIPOTMP4INTNRNumber of interval within variantint100
TOPContract Billing
30ERCHV_GEN_PROTStructure Log of Consumption History5INTNRNumber of interval within variantint100
TOPEnergy Data Management
31EFORMULAINTERVALISU EDM Intervals of Hierarchy Level (DB table)5INTNRInterval numbernvarchar100
TOPInvoicing
32ERPLIS-U: Link of Mass Run Interval to Application Log5INTNRNumber of interval within variantint100
TOPLogistics - General
33HBSAUTHelper table for auto generation ...4INTNRCounternvarchar80
34HBSCMPCommunity Plan Data within Home Building Solution4INTNRNot More Closely Defined Area, Possibly Used for Patchlevelsnvarchar40
TOPMaintenance Orders
35IWOT_HEADAssignment of Header Data Screens for External Labels1INTNRScreen Areanvarchar30
36IWOT_HEADTAssignment of Header Data Screens for External Labels: Texts1INTNRScreen Areanvarchar30
37IWOT_SUBAssignment of Subscreens to External Labels1INTNRScreen Areanvarchar30
38IWOT_SUBTAssignment of Subscreens to External Labels: Texts1INTNRScreen Areanvarchar30
TOPNew Zealand
39T7NZLCLeave Payment Calculation Table - NZ8INTNRWage Type Internal Number - NZnvarchar40
40T7NZLLLeave Payment Calculation Table - NZ11INTNRWage Type Internal Number - NZnvarchar40
41T7NZLRLeave Rule Table - NZ8INTNRWage Type Internal Number - NZnvarchar40
TOPPayroll General Parts
42PA0165HR Master Record: Infotype 0165 (Limits Deductions)25INTNRInterval for Limitsnvarchar40
43T51D1Limits for Deductions8INTNRInterval for Limitsnvarchar40
44T51D6Interval Definitions3INTNRInterval for Limitsnvarchar40
45T51DSText for Time Intervals4INTNRInterval for Limitsnvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
46NWATINTENSIS-H AT: Intensivdokumentation - Patientenadministration5INTNRIS-H AT: interne laufende Nummer für Intensivdokumentationnvarchar30
47NWATPHYSIS-H AT: Intensivdokumentation - Physiologische Daten5INTNRIS-H AT: interne laufende Nummer für Intensivdokumentationnvarchar30
48NWATTISS28Intensivdoku. - Pflege- u. Therapiedoku. (TISS-28 / TISS-A )5INTNRIS-H AT: interne laufende Nummer für Intensivdokumentationnvarchar30
49NWATTRISSIS-H AT: Intensivdoku. - Erfass. traumatologischer Patienten5INTNRIS-H AT: interne laufende Nummer für Intensivdokumentationnvarchar30
50TNA40ZIS-H AT: Zeiten für Zuschlagsleistungen7INTNRIS-H AT: Interne Nummernvarchar40
51TNNLACTIVSorge Aktivität kode3INTNRIS-H: Alternative Identifikation einer Tarifpositionnvarchar120
52TNWAT_LEIKOM_HDRIS-H AT: Leistungskombinationen umschlüsseln - Header15INTNRInterne Nummernvarchar100
53TNWAT_LEIKOM_POSIS-H AT: Leistungskombinationen umschlüsseln - Position5INTNRInterne Nummernvarchar100
54TNWCHHONHEADFee Header Table for Released Breakdown Data4INTNRInternal Numbernvarchar100
55TNWCHHONHEADCDFee Header Table for Released Breakdown Codes4INTNRInternal Numbernvarchar100
56TNWCHHONPOS102Fee Item Data for Pools4INTNRInternal Numbernvarchar100
57TNWCHHONPOS98Fee Item Data for Codes - Limitations4INTNRInternal Numbernvarchar100
58TNWCHHONPOS98SFee Item Data for Codes - Limit Levels4INTNRInternal Numbernvarchar100
59TNWCHHONPOS99Fee Item Data for Codes - Breakdown Code4INTNRInternal Numbernvarchar100
60TNWCHHONPOS99SFee Item Data for Codes - Breakdown Code4INTNRInternal Numbernvarchar100
TOPSAP Utilities
61ESMON_MARUNIDINTMonitoring Mass Run: Buffer for Intervals6INTNRNumber of interval within variantint100
TOPTechnical Objects
62TITOBSUBTechnical Objects: Subscreens with Customizable Assignment2INTNRSequence Numbernvarchar30
63TITOBSUBTTechnical Objects: Texts for Subscreens from Table TITOBSUB2INTNRSequence Numbernvarchar30