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

112 columns | Print definition?ERP 6.0  | CARRID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/SCARR_MRMedia Resource Table (based on SFLIGHT table SCARR)2CARRIDAirline Codenvarchar30
2/SAPQUERY/T000Flight schedule2CARRIDAirline Codenvarchar30
3/SAPQUERY/T100Flight2CARRIDAirline Codenvarchar30
4/SAPQUERY/T101Flight cargo2CARRIDAirline Codenvarchar30
5/SAPQUERY/T102Airline2CARRIDAirline Codenvarchar30
6/SAPQUERY/T200Single Flight Booking2CARRIDAirline Codenvarchar30
7/SAPQUERY/T211Single Container Flight Booking2CARRIDAirline Codenvarchar30
8/SAPQUERY/TA00Airline2CARRIDAirline Codenvarchar30
9/SAPQUERY/TA06Sales counter2CARRIDAirline Codenvarchar30
10/SMFND/DEMO_B_EXExchange Table - Demo Bookings4CARRIDAirline Codenvarchar30
11/SMFND/DEMO_F_EXExchange Table - Demo Flights4CARRIDAirline Codenvarchar30
12CNV_DEMO_FLSTTPLTemplate table for Z-Table with monthy flight statistics2CARRIDAirline Codenvarchar30
13CNV_DEMO_STABTPLTemplate table for Z-Table in the demo package2CARRIDAirline Codenvarchar30
14DAAG_RT_SFLIGHTData Aging: Test Object DAAG_SFLIGHT for Residence Times2CARRIDAirline Codenvarchar30
15DAAG_SBOOKSingle Flight Booking2CARRIDAirline Codenvarchar30
16DAAG_SFLIGHTFlight2CARRIDAirline Codenvarchar30
17DAAG_SPFLIFlight Schedule2CARRIDAirline Codenvarchar30
18DSH_MEALMeal Table for Dictionary Search Helps2CARRIDAirline Codenvarchar30
19DSH_MEALTDictionary Search Helps: Text Table for Meals2CARRIDAirline Codenvarchar30
20SADL_SFLIGHTFlight2CARRIDAirline Codenvarchar30
21SALV_IDA_SFLIGHTFlug2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
22SDDLFLIGHTTSTFlight2CARRIDAirline Codenvarchar30
23SEATBOOKLinks a booking to a seat on the plane2CARRIDAirline Codenvarchar30
24TFW_SFLIGHT_MAKey Mapping Table for SFLIGHT Business Object2CARRIDAirline Codenvarchar30
25VERCARRContext-Veri: Fluggesellschaft2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
26VERPFLIContext-Veri: Verbindungsangebote für Flüge2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
27WDR_TEST_BADFlugplan2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
28WDR_TEST_GOODFlugplan2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
29WDR_TEST_SPFFlugplan2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
30WDR_TEST_SPF_EFlugplan2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
31YCHDBTAB_FLUEGEFlugverbindungen2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
32YCHDBTAB_SPFLIFlugverbindungen2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
33ZARIXBC1Archivinformationsstruktur ZZ_BC_SBOOK31_T2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
34ZSFLIGHT99Demotabelle für D40AW Kurs (Suchhilfen...)2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
35ZSMATMaterialschlüssel der Fluggesellschaften2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
TOPABAP Workbench, Java IDE and Infrastructure
36SBOOKSingle Flight Booking2CARRIDAirline Codenvarchar30
37SCARPLANPlane-airline assignment2CARRIDAirline Codenvarchar30
38SCARRAirline2CARRIDAirline Codenvarchar30
39SCOUNTERSales counter2CARRIDAirline Codenvarchar30
40SDESSERTInflight meal/Dessert2CARRIDAirline Codenvarchar30
41SFLCONNPOSStage of a Flight Connection5CARRIDAirline Codenvarchar30
42SFLIGHTFlight2CARRIDAirline Codenvarchar30
43SFLIMEALFlight-Meal assignment2CARRIDAirline Codenvarchar30
44SFLTRIPBOKIndividual Flight Bookings for a Flight Trip5CARRIDAirline Codenvarchar30
45SMACOURSEInflight meal/Main course2CARRIDAirline Codenvarchar30
46SMEALInflight Meal2CARRIDAirline Codenvarchar30
47SMEALTInflight meal/Description2CARRIDAirline Codenvarchar30
48SMENUMenu2CARRIDAirline Codenvarchar30
49SNVOICEInvoice2CARRIDAirline Codenvarchar30
50SPFLIFlight schedule2CARRIDAirline Codenvarchar30
51SSTARTERInflight meal/Appetizer2CARRIDAirline Codenvarchar30
52STICKETFlight Ticket2CARRIDAirline Codenvarchar30
TOPArchiving Engine
53TARCHBOOKArchiving Example: Flight Bookings2CARRIDAirline Codenvarchar30
54TARCHFLIGHTArchiving Example: Flights2CARRIDAirline Codenvarchar30
TOPCross-Application Components
55BC402_SBOOKIndividual Flight Booking2CARRIDAirline Codenvarchar30
56SBOOK_ADDSSingle Flight Booking2CARRIDAirline Codenvarchar30
57SCARGOManagement of freight orders (demo for BC430)2CARRIDAirline Codenvarchar30
58SFLCREWFlight crew: Starting Situation2CARRIDAirline Codenvarchar30
59SFLCREW_BUFFCrew of a flight: Buffer settings (3)2CARRIDAirline Codenvarchar30
60SFLCREW_CONVFlight crew: Starting Situation2CARRIDAirline Codenvarchar30
61SFLCREW_SEARCHFlight Crew: Search Help2CARRIDAirline Codenvarchar30
62SFLIGHT00Flight demo table2CARRIDAirline Codenvarchar30
63SFLIGHT01Flight demo table2CARRIDAirline Codenvarchar30
64SFLIGHT02Flight demo table2CARRIDAirline Codenvarchar30
65SFLIGHT03Flight demo table2CARRIDAirline Codenvarchar30
66SFLIGHT04Flight demo table2CARRIDAirline Codenvarchar30
67SFLIGHT05Flight demo table2CARRIDAirline Codenvarchar30
68SFLIGHT06Flight demo table2CARRIDAirline Codenvarchar30
69SFLIGHT07Flight demo table2CARRIDAirline Codenvarchar30
70SFLIGHT08Flight demo table2CARRIDAirline Codenvarchar30
71SFLIGHT09Flight demo table2CARRIDAirline Codenvarchar30
72SFLIGHT10Flight demo table2CARRIDAirline Codenvarchar30
73SFLIGHT11Flight demo table2CARRIDAirline Codenvarchar30
74SFLIGHT12Flight demo table2CARRIDAirline Codenvarchar30
75SFLIGHT13Flight demo table2CARRIDAirline Codenvarchar30
76SFLIGHT14Flight demo table2CARRIDAirline Codenvarchar30
77SFLIGHT15Flight demo table2CARRIDAirline Codenvarchar30
78SFLIGHT16Flight demo table2CARRIDAirline Codenvarchar30
79SFLIGHT17Flight demo table2CARRIDAirline Codenvarchar30
80SFLIGHT18Flight demo table2CARRIDAirline Codenvarchar30
81SFLIGHT19Flight2CARRIDAirline Codenvarchar30
82SFLIGHT20Flight demo table2CARRIDAirline Codenvarchar30
83SFLIGHT21Flight demo table2CARRIDAirline Codenvarchar30
84SFLIGHT22Flight demo table2CARRIDAirline Codenvarchar30
85SFLIGHT23Flight demo table2CARRIDAirline Codenvarchar30
86SFLIGHT24Flight demo table2CARRIDAirline Codenvarchar30
87SFLIGHT25Flight demo table2CARRIDAirline Codenvarchar30
88SFLIGHT26Flight demo table2CARRIDAirline Codenvarchar30
89SFLIGHT27Flight demo table2CARRIDAirline Codenvarchar30
90SFLIGHT28Flight demo table2CARRIDAirline Codenvarchar30
91SFLIGHT29Flight demo table2CARRIDAirline Codenvarchar30
92SFLIGHT30Flight demo table2CARRIDAirline Codenvarchar30
93SFLIGHT99Flight2CARRIDAirline Codenvarchar30
94SPECIALS_ASSIGNSpecial Requests / Additional Data for Flight Bookings3CARRIDAirline Codenvarchar30
TOPDictionary Maintenance
95AUDDD_SFLIGHTTO (don't use/change it): Flight2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
TOPeCATT Extended Computer Aided Test Tool
96ECATTTEST_DB1Test Table for eCATT2CARRIDAirline Codenvarchar30
TOPEnterprise Service Framework Layer
97ESI_GUID_MEALSMEAL GUID table3CARRIDAirline Codenvarchar30
98SCOL_MAP_BOOKID<cool> Flight Example: Mapping for Persistent Booking IDs2CARRIDAirline Codenvarchar30
TOPExchange Infrastructure
99SFLBOPOSFlight Booking Order Item5CARRIDAirline Codenvarchar30
TOPFinancials Basis
100UGMDDEMO04CAirline Carrier2CARRIDFIN Master Data: Demo Characteristic over Data Elementnvarchar30
TOPSAP Business Workflow
101SWXTRABOOKFlight Bookings and Offers7CARRIDAirline Codenvarchar30
TOPSAP Desktop Office Integration
102OMD_SBOOK_TMPKEYFlight booking key store1CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
TOPSAP List Viewer
103ALV_CHCKCheck Table for ALV_T_T22CARRIDAirline Codenvarchar30
104ALV_TABCheck Table for ALV_T_T22CARRIDAirline Codenvarchar30
105ALV_T_T2Test Data for ALV2CARRIDAirline Codenvarchar30
TOPSyntax, Compiler, Runtime
106TPDA_SFLIGHTFlug2CARRIDKurzbezeichnung der Fluggesellschaftnvarchar30
TOPWeb Dynpro ABAP
107WDR_TEST_SPFLI3Flight Schedule2CARRIDAirline Codenvarchar30
TOPWebClient UI
108CRMD_UIF_SNOTETransparent Table Note for Flight2CARRIDAirline Codenvarchar30
TOPWorkbench Utilities
109ACTFLIABAP/4 book: Flights2CARRIDAirline Codenvarchar30
110BOOKINGSABAP book: Flight bookings2CARRIDAirline Codenvarchar30
111CARRIERSABAP/4 book: Airlines2CARRIDAirline Codenvarchar30
112PLANFLIABAP/4 book: Connection offers for flights2CARRIDAirline Codenvarchar30