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  | OIJTS
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
Logistics - General
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIJTS602Transport system (IS-Oil TSW standard/core object )Logistics - General
SQL:  selectupdate insert create

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

SELECT MANDT, TSYST, TSNAM, BOOKTS, VSART, VKTRA, SHTYPE, VEHID, TSSUOMV, TSSUOMM, CYCPERD, CYCPUOM, CARRIER, WERK, LGORT, NOMMSK, SHIPPER, CONLTM, CONLUOM, TPLST, BOTOL, BUTOL, BOTOLABS, BUTOLABS, BULTOLUOM, UNLIMITED, BALCH, CLIPLGORT, SHTYP, ERDAT, ERZEIT, ERNAM, AEDAT, AEZEIT, AENAM, BLOIND, DELIND, KALSM, KAPPL, KSCHL, MAXRATE, MINRATE, OPERATE, RATEUOM, RATEPERD, SEQIND, MAXUSAGE, MINUSAGE, USAGEUOM, USAGEPERD, PIPE_BATCH, VEL_AVG, VEL_MAX, VEL_MIN, BUSTYP, VEL_UOM, VEL_UOMT, ROUTE_TOLERANCE, RDTSACT, ACT_SUBITEM FROM OIJTS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2TSYSTTransport systemnvarchar100CHAR(N' ')NoOIJ_TSYST Allow NULL? 
3TSNAMOIL-TSW: Transport system namenvarchar600CHAR(N' ')YesOIJ_TSNAM Allow NULL? 
4BOOKTSBook TS indicatorchar10CHAR(N' ')YesOIJ_BOOKTS Allow NULL? 
5VSARTShipping typenvarchar20CHAR(N' ')YesT173VERSART Allow NULL? 
6VKTRAMode of transportnvarchar20CHAR(N' ')YesTVTRVKTRA Allow NULL? 
7SHTYPETD shipment typenvarchar40CHAR(N' ')YesTOIGSOIG_TDSTYP Allow NULL? 
8VEHIDDefault vehicle numbernvarchar100CHAR(N' ')YesOIGVOIJ_DEFVEH Allow NULL? 
9TSSUOMVTS standard volume UoMnvarchar30UNIT(N' ')YesT006OIJ_TSUOMV Allow NULL? 
10TSSUOMMTS standard weight UoMnvarchar30UNIT(N' ')YesT006OIJ_TSUOMM Allow NULL? 
11CYCPERDTS cycle durationdecimal100QUAN((0))YesOIJ_CYCDUR
12CYCPUOMTS cycle duration UoMnvarchar30UNIT(N' ')YesT006OIJ_CYDUOM Allow NULL? 
13CARRIERTransport system Carriernvarchar100CHAR(N' ')YesLFA1OIJ_CARRNR Allow NULL? 
14WERKTransport system In-transit Plantnvarchar40CHAR(N' ')YesT001WOIJ_WERK Allow NULL? 
15LGORTTransport system In-transit Storage Locationnvarchar40CHAR(N' ')YesT001LOIJ_LGORT Allow NULL? 
16NOMMSKNomination masknvarchar100CHAR(N' ')YesOIJ_NOMMSK Allow NULL? 
17SHIPPERDefault TS shipper codenvarchar100CHAR(N' ')YesOIJ_SHPPER Allow NULL? 
18CONLTMCarrier lead timedecimal30QUAN((0))YesOIJ_CONLTM
19CONLUOMConfirmation lead time UoMnvarchar30UNIT(N' ')YesT006OIJ_CONTUM Allow NULL? 
20TPLSTTransportation planning pointnvarchar40CHAR(N' ')YesTTDSTPLST Allow NULL? 
21BOTOLQuantity tolerance over (percentage)decimal41DEC((0))YesOIJ_BOTOL
22BUTOLQuantity tolerance under (%)decimal41DEC((0))YesOIJ_BUTOL
23BOTOLABSAbsolute tolerance qty overdecimal133QUAN((0))YesOIJ_TOLABO
24BUTOLABSAbsolute tolerance qty underdecimal133QUAN((0))YesOIJ_TOLABS
25BULTOLUOMAbsolute tolerance UoMnvarchar30UNIT(N' ')YesT006OIJ_TOLUOM Allow NULL? 
26UNLIMITEDIndicator: Unlimited Overdelivery Allowedchar10CHAR(N' ')YesUEBTK Allow NULL? 
27BALCHBalance check indicator (default)char10CHAR(N' ')YesOIJ_BALCH Allow NULL? 
28CLIPLGORTTransport System In-transit Temporary Storage Locationnvarchar40CHAR(N' ')Yes*OIJ_CLIPLGORT Allow NULL? 
29SHTYPShipment typenvarchar40CHAR(N' ')YesTVTKSHTYP Allow NULL? 
30ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
31ERZEITTime of creationnvarchar60TIMS(N'000000')YesOI0_ERTIM Allow NULL? 
32ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
33AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
34AEZEITTime of day the record was changednvarchar60TIMS(N'000000')YesOI0_AETIM Allow NULL? 
35AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
36BLOINDBlocking indicatorchar10CHAR(N' ')YesOIJ_BLOIND Allow NULL? 
37DELINDDeletion indicatorchar10CHAR(N' ')YesOIJ_DELIND Allow NULL? 
38KALSMOutput determination procedure for nominationsnvarchar60CHAR(N' ')YesT683OIJ_KALSM Allow NULL? 
39KAPPLApplication in output determination for nominationsnvarchar20CHAR(N' ')YesT681AOIJ_KAPPL Allow NULL? 
40KSCHLOutput determination/output type for nominationsnvarchar40CHAR(N' ')YesT685OIJ_KSCHL Allow NULL? 
41MAXRATEMaximum rate per perioddecimal133QUAN((0))YesOIJ_MAXRATE
42MINRATEMinimum rate per perioddecimal133QUAN((0))YesOIJ_MINRATE
43OPERATEOperating rate per perioddecimal133QUAN((0))YesOIJ_OPERATE
44RATEUOMRate unitnvarchar30UNIT(N' ')YesT006OIJ_RATEUOM Allow NULL? 
45RATEPERDTtime unit of measurement for ratenvarchar30UNIT(N' ')YesT006OIJ_RATEPERD Allow NULL? 
46SEQINDLocation sequence indexchar10CHAR(N' ')YesOIJ_TSSEQIND Allow NULL? 
47MAXUSAGEMaximum volume per perioddecimal133QUAN((0))YesOIJ_MAXUSAGE
48MINUSAGEMinimum volume per perioddecimal133QUAN((0))YesOIJ_MINUSAGE
49USAGEUOMUsage unitnvarchar30UNIT(N' ')YesT006OIJ_USAGEUOM Allow NULL? 
50USAGEPERDTime unit of measument for usagenvarchar30UNIT(N' ')YesT006OIJ_USAGEPERD Allow NULL? 
51PIPE_BATCHPipeline Batching activechar10CHAR(N' ')YesOIJ_PIPE_BATCH Allow NULL? 
52VEL_AVGAverage Velocitydecimal133QUAN((0))YesOIJ_VEL_AVG
53VEL_MAXMaximum Velocitydecimal133QUAN((0))YesOIJ_VEL_MAX
54VEL_MINMinimum Velocitydecimal133QUAN((0))YesOIJ_VEL_MIN
55BUSTYPBusiness typenvarchar40CHAR(N' ')YesOIRARNBTOIRA_RNBT Allow NULL? 
56VEL_UOMVelocity UoMnvarchar30UNIT(N' ')YesT006OIJ_VEL_UOM Allow NULL? 
57VEL_UOMTVelocity - Timenvarchar30UNIT(N' ')Yes*OIJ_VEL_UOMT Allow NULL? 
58ROUTE_TOLERANCETolerance in percent for stage duration for timestamp checktinyint30INT1((0))YesOIJ_ROUTE_TOLERANCE
59RDTSACTStock Projection activation indicatorchar10CHAR(N' ')YesOIJ_RDACT Allow NULL? 
60ACT_SUBITEMTSW-Ticket Actualization at Subitem Indicatorchar10CHAR(N' ')YesOIJ_ACT_SUBITEM_FLAG Allow NULL? 
NamePrimaryUniqueTypeColumns
OIJTS~0YesYesCLUSTEREDTSYST, MANDT
OIJTS~WRKNoNoNONCLUSTEREDLGORT, WERK, 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