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

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

B1 9.2: Top 10 requests

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

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINM101Whse Journal
4OINV268A/R Invoice
5OIVL77Whse Journal
6OVPM154Outgoing Payments
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Basis Components :: Basis Services Communication Interfaces :: SAP List Viewer
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ALV_T_T2331Test Data for ALVSAP List Viewer
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, CARRID, CONNID, FLDATE, CARRNAME, CARRID_CONV, PRICE, CURRENCY, PLANETYPE, SEATSMAX, SEATSOCC, PAYMENTSUM, COUNTRYFR, AIRPFROM, COUNTRYTO, AIRPTO, FLTIME, DEPTIME, ARRTIME, DISTANCE, DISTID, PERIOD, FLOAT_FI, STRING_F, XSTRING, INT_FIEL, HEX_FIEL, DROPDOWN, TAB_INDEX, TIMESTAMP_S, TIMESTAMP_L, TIME, CONV_INT FROM ALV_T_T2
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000S_MANDT Allow NULL? 
2CARRIDAirline Codenvarchar30CHAR(N' ')NoALV_TABS_CARRID_ALV Allow NULL? 
3CONNIDFlight Connection Numbernvarchar40NUMC(N'0000')NoALV_CHCKS_CONN_ID Allow NULL? 
4FLDATEData Element for Field FLDATE of Table ALV_T_T2nvarchar80DATS(N'00000000')No*S_FL_DATE Allow NULL? 
5CARRNAMEAirline namenvarchar200CHAR(N' ')NoS_CARRNAME Allow NULL? 
6CARRID_CONVAirline Codenvarchar30CHAR(N' ')No*S_CARRID_CONV Allow NULL? 
7PRICEAirfaredecimal152CURR((0))NoS_PRICE
8CURRENCYLocal currency of airlinenvarchar50CUKY(N' ')NoALV_CURS_CURRCODE Allow NULL? 
9PLANETYPEAircraft Typenvarchar100CHAR(N' ')No*S_PLANETYE Allow NULL? 
10SEATSMAXMaximum capacity in economy classint100INT4((0))NoS_SEATSMAX Allow NULL? 
11SEATSOCCOccupied seats in economy classint100INT4((0))NoS_SEATSOCC Allow NULL? 
12PAYMENTSUMTotal of current bookingsdecimal172CURR((0))NoS_SUM
13COUNTRYFRCountry Keynvarchar30CHAR(N' ')No*LAND1 Allow NULL? 
14AIRPFROMDeparture airportnvarchar30CHAR(N' ')No*S_FROMAIRP Allow NULL? 
15COUNTRYTOCountry Keynvarchar30CHAR(N' ')No*LAND1 Allow NULL? 
16AIRPTODestination airportnvarchar30CHAR(N' ')No*S_TOAIRP Allow NULL? 
17FLTIMEFlight timeint100INT4((0))NoS_FLTIME Allow NULL? 
18DEPTIMEDeparture timenvarchar60TIMS(N'000000')NoS_DEP_TIME Allow NULL? 
19ARRTIMEArrival timenvarchar60TIMS(N'000000')NoS_ARR_TIME Allow NULL? 
20DISTANCEDistancedecimal94QUAN((0))NoS_DISTANCE
21DISTIDData Element for Field DISTID of Table ALV_T_T2nvarchar30UNIT(N' ')NoT006S_DIST_ID Allow NULL? 
22PERIODArrival n day(s) latertinyint30INT1((0))NoS_PERIOD
23FLOAT_FITest Field of Type FLOATfloat1516FLTP((0))NoLVC_S_FTF
24STRING_FTest Field of Type STRINGntext10737418230NoLVC_S_STF
25XSTRINGTest Field of Type XSTRINGimage21474836470NoLVC_S_XSTF
26INT_FIELTest Field of Type INTEGERint100INT4((0))NoLVC_S_ITF Allow NULL? 
27HEX_FIELTest Field of Type HEXvarbinary20RAWNoLVC_S_HTF
28DROPDOWNNatural Numberint100INT4((0))NoINT4 Allow NULL? 
29TAB_INDEXNatural Numberint100INT4((0))NoINT4 Allow NULL? 
30TIMESTAMP_SUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))NoTIMESTAMP
31TIMESTAMP_LUTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)decimal217DEC((0))NoTZNTSTMPL
32TIMEField of type TIMSnvarchar60TIMS(N'000000')NoTIMS Allow NULL? 
33CONV_INTS_CONV_INTtinyint30INT1((0))NoS_CONV_INT
NamePrimaryUniqueTypeColumns
ALV_T_T2~0YesYesCLUSTEREDFLDATE, CONNID, CARRID, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy