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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

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

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
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

89 columns | Print definition?ERP 6.0  | CONNID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPQUERY/T000Flight schedule3CONNIDFlight Connection Numbernvarchar40
2/SAPQUERY/T100Flight3CONNIDFlight Connection Numbernvarchar40
3/SAPQUERY/T101Flight cargo3CONNIDFlight Connection Numbernvarchar40
4/SAPQUERY/T200Single Flight Booking3CONNIDFlight Connection Numbernvarchar40
5/SAPQUERY/T211Single Container Flight Booking3CONNIDFlight Connection Numbernvarchar40
6/SMFND/DEMO_B_EXExchange Table - Demo Bookings5CONNIDFlight Connection Numbernvarchar40
7/SMFND/DEMO_F_EXExchange Table - Demo Flights5CONNIDFlight Connection Numbernvarchar40
8CNV_DEMO_FLSTTPLTemplate table for Z-Table with monthy flight statistics3CONNIDFlight Connection Numbernvarchar40
9DAAG_RT_SFLIGHTData Aging: Test Object DAAG_SFLIGHT for Residence Times3CONNIDFlight Connectionnvarchar40
10DAAG_SBOOKSingle Flight Booking3CONNIDFlight Connection Numbernvarchar40
11DAAG_SFLIGHTFlight3CONNIDFlight Connection Numbernvarchar40
12DAAG_SPFLIFlight Schedule3CONNIDFlight Connection Numbernvarchar40
13SADL_SFLIGHTFlight3CONNIDFlight Connection Numbernvarchar40
14SALV_IDA_SFLIGHTFlug3CONNIDCode der Einzelflugverbindungnvarchar40
15SDDLFLIGHTTSTFlight3CONNIDFlight Connection Numbernvarchar40
16SEATBOOKLinks a booking to a seat on the plane3CONNIDFlight Connection Numbernvarchar40
17TFW_SFLIGHT_MAKey Mapping Table for SFLIGHT Business Object3CONNIDFlight Connection Numbernvarchar40
18VERPFLIContext-Veri: Verbindungsangebote für Flüge3CONNIDCode der Einzelflugverbindungnvarchar40
19WDR_TEST_BADFlugplan3CONNIDCode der Einzelflugverbindungnvarchar40
20WDR_TEST_GOODFlugplan3CONNIDCode der Einzelflugverbindungnvarchar40
21WDR_TEST_SPFFlugplan3CONNIDCode der Einzelflugverbindungnvarchar40
22WDR_TEST_SPF_EFlugplan3CONNIDCode der Einzelflugverbindungnvarchar40
23YCHDBTAB_FLUEGEFlugverbindungen3CONNIDCode der Einzelflugverbindungnvarchar40
24YCHDBTAB_SPFLIFlugverbindungen3CONNIDCode der Einzelflugverbindungnvarchar40
25ZARIXBC1Archivinformationsstruktur ZZ_BC_SBOOK31_T3CONNIDCode der Einzelflugverbindungnvarchar40
26ZSFLIGHT99Demotabelle für D40AW Kurs (Suchhilfen...)3CONNIDCode der Einzelflugverbindungnvarchar40
TOPABAP Workbench, Java IDE and Infrastructure
27SBOOKSingle Flight Booking3CONNIDFlight Connection Numbernvarchar40
28SFLCONNPOSStage of a Flight Connection6CONNIDFlight Connection Numbernvarchar40
29SFLIGHTFlight3CONNIDFlight Connection Numbernvarchar40
30SFLIMEALFlight-Meal assignment4CONNIDFlight Connection Numbernvarchar40
31SNVOICEInvoice3CONNIDFlight Connection Numbernvarchar40
32SPFLIFlight schedule3CONNIDFlight Connection Numbernvarchar40
33STICKETFlight Ticket3CONNIDFlight Connection Numbernvarchar40
TOPArchiving Engine
34TARCHBOOKArchiving Example: Flight Bookings3CONNIDFlight Connection Numbernvarchar40
35TARCHFLIGHTArchiving Example: Flights3CONNIDFlight Connection Numbernvarchar40
36TARCHFLIGHTCONNArchiving Example: Flight Connections2CONNIDFlight Connection Numbernvarchar40
TOPCross-Application Components
37BC402_SBOOKIndividual Flight Booking3CONNIDFlight Connection Numbernvarchar40
38SBOOK_ADDSSingle Flight Booking3CONNIDFlight Connection Numbernvarchar40
39SCARGOManagement of freight orders (demo for BC430)3CONNIDFlight Connection Numbernvarchar40
40SFLCREWFlight crew: Starting Situation3CONNIDFlight Connection Numbernvarchar40
41SFLCREW_BUFFCrew of a flight: Buffer settings (3)3CONNIDFlight Connection Numbernvarchar40
42SFLCREW_CONVFlight crew: Starting Situation3CONNIDFlight Connection Numbernvarchar40
43SFLCREW_SEARCHFlight Crew: Search Help3CONNIDFlight Connection Numbernvarchar40
44SFLIGHT00Flight demo table3CONNIDFlight Connection Numbernvarchar40
45SFLIGHT01Flight demo table3CONNIDFlight Connection Numbernvarchar40
46SFLIGHT02Flight demo table3CONNIDFlight Connection Numbernvarchar40
47SFLIGHT03Flight demo table3CONNIDFlight Connection Numbernvarchar40
48SFLIGHT04Flight demo table3CONNIDFlight Connection Numbernvarchar40
49SFLIGHT05Flight demo table3CONNIDFlight Connection Numbernvarchar40
50SFLIGHT06Flight demo table3CONNIDFlight Connection Numbernvarchar40
51SFLIGHT07Flight demo table3CONNIDFlight Connection Numbernvarchar40
52SFLIGHT08Flight demo table3CONNIDFlight Connection Numbernvarchar40
53SFLIGHT09Flight demo table3CONNIDFlight Connection Numbernvarchar40
54SFLIGHT10Flight demo table3CONNIDFlight Connection Numbernvarchar40
55SFLIGHT11Flight demo table3CONNIDFlight Connection Numbernvarchar40
56SFLIGHT12Flight demo table3CONNIDFlight Connection Numbernvarchar40
57SFLIGHT13Flight demo table3CONNIDFlight Connection Numbernvarchar40
58SFLIGHT14Flight demo table3CONNIDFlight Connection Numbernvarchar40
59SFLIGHT15Flight demo table3CONNIDFlight Connection Numbernvarchar40
60SFLIGHT16Flight demo table3CONNIDFlight Connection Numbernvarchar40
61SFLIGHT17Flight demo table3CONNIDFlight Connection Numbernvarchar40
62SFLIGHT18Flight demo table3CONNIDFlight Connection Numbernvarchar40
63SFLIGHT19Flight3CONNIDFlight Connection Numbernvarchar40
64SFLIGHT20Flight demo table3CONNIDFlight Connection Numbernvarchar40
65SFLIGHT21Flight demo table3CONNIDFlight Connection Numbernvarchar40
66SFLIGHT22Flight demo table3CONNIDFlight Connection Numbernvarchar40
67SFLIGHT23Flight demo table3CONNIDFlight Connection Numbernvarchar40
68SFLIGHT24Flight demo table3CONNIDFlight Connection Numbernvarchar40
69SFLIGHT25Flight demo table3CONNIDFlight Connection Numbernvarchar40
70SFLIGHT26Flight demo table3CONNIDFlight Connection Numbernvarchar40
71SFLIGHT27Flight demo table3CONNIDFlight Connection Numbernvarchar40
72SFLIGHT28Flight demo table3CONNIDFlight Connection Numbernvarchar40
73SFLIGHT29Flight demo table3CONNIDFlight Connection Numbernvarchar40
74SFLIGHT30Flight demo table3CONNIDFlight Connection Numbernvarchar40
75SFLIGHT99Flight3CONNIDFlight Connection Numbernvarchar40
TOPDictionary Maintenance
76AUDDD_SFLIGHTTO (don't use/change it): Flight3CONNIDCode der Einzelflugverbindungnvarchar40
TOPeCATT Extended Computer Aided Test Tool
77ECATTTEST_DB1Test Table for eCATT3CONNIDFlight Connection Numbernvarchar40
TOPEnterprise Service Framework Layer
78SCOL_MAP_BOOKID<cool> Flight Example: Mapping for Persistent Booking IDs3CONNIDFlight Connection Numbernvarchar40
TOPExchange Infrastructure
79SFLBOPOSFlight Booking Order Item6CONNIDFlight Connection Numbernvarchar40
TOPSAP Business Workflow
80SWXTRABOOKFlight Bookings and Offers8CONNIDFlight Connection Numbernvarchar40
TOPSAP Desktop Office Integration
81OMD_SBOOK_TMPKEYFlight booking key store2CONNIDCode der Einzelflugverbindungnvarchar40
TOPSAP List Viewer
82ALV_CHCKCheck Table for ALV_T_T23CONNIDFlight Connection Numbernvarchar40
83ALV_T_T2Test Data for ALV3CONNIDFlight Connection Numbernvarchar40
TOPSyntax, Compiler, Runtime
84TPDA_SFLIGHTFlug3CONNIDCode der Einzelflugverbindungnvarchar40
TOPWeb Dynpro ABAP
85WDR_TEST_SPFLI3Flight Schedule3CONNIDFlight Connection Numbernvarchar40
TOPWebClient UI
86CRMD_UIF_SNOTETransparent Table Note for Flight3CONNIDFlight Connection Numbernvarchar40
TOPWorkbench Utilities
87ACTFLIABAP/4 book: Flights3CONNIDFlight Connection Numbernvarchar40
88BOOKINGSABAP book: Flight bookings3CONNIDFlight Connection Numbernvarchar40
89PLANFLIABAP/4 book: Connection offers for flights3CONNIDFlight Connection Numbernvarchar40