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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

55 columns | Print definition?ERP 6.0  | SITYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SMD/MD_____003QSID-Tabelle fuer Subitem category3SITYPSubitem categorynvarchar30
2/SMD/MD_____003RSID-Tabelle fuer Subitem3SITYPSubitem categorynvarchar30
3P2KW_SI_KWPayroll Result: PIFSS Data for Kuwait13SITYPPublic Institution of Social Security (PIFSS) Typenvarchar40
4PA3354HR Master Record: Infotype 335427SITYPPublic Institution of Social Security (PIFSS) Typenvarchar40
5PA3372HR Master Record: Infotype 337227SITYPPublic Authority for Social Insurance (PASI) Typenvarchar40
6PB3354Applicant data infotype 3354 (PIFSS)27SITYPPublic Institution of Social Security (PIFSS) Typenvarchar40
7T7KW01Kuwait PIFSS Type2SITYPPublic Institution of Social Security (PIFSS) Typenvarchar40
8T7KW01TKuwait PIFSS Type Text3SITYPPublic Institution of Social Security (PIFSS) Typenvarchar40
9T7OM02Oman PASI Type2SITYPPublic Authority for Social Insurance (PASI) Typenvarchar40
10T7OM02TOman PASI Type Text3SITYPPublic Authority for Social Insurance (PASI) Typenvarchar40
11T7QA29Serious Incident Type2SITYPSerious Incident Typenvarchar30
12T7QA29TSerious Incident Type Text3SITYPSerious Incident Typenvarchar30
TOPBasic Functions
13T884Currency translation20SITYPSubitem categorynvarchar30
14T884MCurrency translation methods used in Consolidation9SITYPSubitem categorynvarchar30
TOPConsolidation
15ECMCASAP Cons.: Journal Entry Table (Actual)22SITYPSubitem categorynvarchar30
16ECMCCSAP Cons.: Object Table Movement Attributes3SITYPSubitem categorynvarchar30
17ECMCTSAP Cons.: Totals Table21SITYPSubitem categorynvarchar30
18TF103Breakdown Categories4SITYPSubitem categorynvarchar30
19TF110Subitem Categories2SITYPSubitem categorynvarchar30
20TF111Subitem Categories: Description3SITYPSubitem categorynvarchar30
21TF115Subitems2SITYPSubitem categorynvarchar30
22TF116Subitems: Short and Medium Texts3SITYPSubitem categorynvarchar30
23TF117Subitems: Long Texts3SITYPSubitem categorynvarchar30
24TF410Currency Translation Methods: Entries20SITYPSubitem categorynvarchar30
25TF556Methods for IU Elimination: Item Set Assignments12SITYPSubitem categorynvarchar30
26TF620Changes in Investments14SITYPSubitem categorynvarchar30
27TF630Changes in Investee Equity13SITYPSubitem categorynvarchar30
28TF667Reported Items for Equity Holdings Adjustments5SITYPSubitem categorynvarchar30
29TF693Subitems for Equity Aging Report3SITYPSubitem categorynvarchar30
30TF696Posting Items for the Equity Method6SITYPSubitem categorynvarchar30
31TFMIG10Migration: Processing Options5SITYPSubitem categorynvarchar30
32TFMIG12Migration: Control for Subitem Categories2SITYPSubitem categorynvarchar30
TOPData Collection
33CF709Consolidation Basic20SITYPSubitem categorynvarchar30
TOPDefault Risk and Limit System
34KLSI01Collateral Provision (Header)5SITYPLevel of Collateralnvarchar20
35KLSI01_BAKBackup for Euro Changeover for Collateral Provision (Header)5SITYPLevel of Collateralnvarchar20
TOPKorea
36PA0543HR Master Record: Infotype 054324SITYPSocial insurance typenvarchar40
TOPSAP Business Partner
37TBZ3EBDT Views18SITYPCBP: View categorynvarchar10
38TBZ3WBDT Field Groups13SITYPCBP: View categorynvarchar10
TOPTraders and Schedulers Workbench
39OIJHCT01OIL-TSW: Ticket Holding Table (Draft version 1) - OBSOLETE13SITYPSchedule typenvarchar20
40OIJNOMCOIL-TSW: Nomination copy table4SITYPSchedule typenvarchar20
41OIJNOMINomination Item4SITYPSchedule typenvarchar20
42OIJNOMIVERSNomination Item Version Table6SITYPSchedule typenvarchar20
43OIJSDLOCOIL-TSW: Multiple sources/destinations of location9SITYPSchedule typenvarchar20
44OIJWLOIL-TSW: Worklist13SITYPSchedule typenvarchar20
45OIJ_EL_DOC_I_REFDocument item reference to nomination15SITYPSchedule typenvarchar20
46OIJ_EL_DOC_MOTOil TSW: TSW Relevance of order item43SITYPSchedule typenvarchar20
47OIJ_EL_TICKET_IUniversal ticket item table9SITYPSchedule typenvarchar20
48OIJ_SCHEDPlanned Schedule Lines55SITYPSchedule typenvarchar20
49OIJ_SIM_SCHEDobsolete table (will be cleaned up)11SITYPSchedule typenvarchar20
50S431PURCHIS: (OIL-TSW) Purchasing document stats by TSW object35SITYPSchedule typenvarchar20
51TOIJ_EL_MVSCENTSW: Define Movement scenarios3SITYPSchedule typenvarchar20
52TOIJ_EL_SITYPESTSW: Define valid sitypes2SITYPSchedule typenvarchar20
53TOIJ_EL_SITYPESTTSW: Description of SITYPES3SITYPSchedule typenvarchar20
54TOIJ_REF_DOC_UPDOIL-TSW: Update of scheduled documents - Technical settings4SITYPSchedule typenvarchar20
TOPTransaction Data Pool
55TJBD_CLL_RCH_CSTObject-Specific Customizing for COLL_ARCH2SITYPLevel of Collateralnvarchar20