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  | OIJNOMH
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
4OVPM154Outgoing Payments
5OIVL77Whse Journal
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Industry Specific :: Industry Solution Oil :: Downstream :: Traders and Schedulers Workbench
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIJNOMH994Nomination HeaderTraders and Schedulers Workbench
SQL:  selectupdate insert create

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

SELECT MANDT, NOMTK, NOMCL, NOMTYP, BUSTYP, NOMNR, NOMST, NMSHTYPE, NMBALCH, STAGES_ID, WORKLIST, SENTDAT, SENTTIME, SENTNAM, ITEMS, COUNTER1, COUNTER2, COUNTER3, COUNTER4, COUNTER5, COUNTER6, APO_SHIPMENT_ID, APO_SHIPMENT_NUM, NMBLOCK, NOMTYPDESC, SHTYP, TKNUM, LOV_GL, TSYST, NMSHIPPER, NMCARRIER, CYCLE, NMWERK, NMLGORT, NMVEHICLE, NMVESSEL, NMTPLST, ROUTE, BOOKTS, EV_GROUP, VKTRA, QTYIN, QTYOUT, UNIT, TST_FROM_MIN, TST_TO_MAX, BLOIND, DELIND, SHNUM, ERDAT, ERZEIT, ERNAM, AEDAT, AEZEIT, AENAM, EV_SEQ_UNI, VSART, SHTYPE, VEHID, TSSUOMV, TSSUOMM, CYCPERD, CYCPUOM, CARRIER, WERK, LGORT, NOMMSK, SHIPPER, CONLTM, CONLUOM, TPLST, UNLIMITED, BOTOL, BUTOL, BOTOLABS, BUTOLABS, BULTOLUOM, BALCH, FLTTNOMTK, EXTNOMNR, CHANGENR, NOMSTATUSRU, DISPATCHTYP, DISPATCHREC, CONNECTIONTYP, RAILCAROWN, TARIFFCOD, PAYERTYP, SENDCAT, SENDER, RECVCAT, RECEIVER, PYRCAT, PAYER, ROWNCAT, ROADOWNER, NOMNREGDATE, NOMNVALDFROM, NOMNVALDTO FROM OIJNOMH
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2NOMTKNomination (technical) Keynvarchar200CHAR(N' ')NoOIJ_NOMTK Allow NULL? 
3NOMCLNomination Classnvarchar20CHAR(N' ')YesOIJ_NOMCL Allow NULL? 
4NOMTYPNomination typenvarchar40CHAR(N' ')YesTOIJNOMTYPOIJ_NOMTYP Allow NULL? 
5BUSTYPBusiness typenvarchar40CHAR(N' ')YesOIRARNBTOIRA_RNBT Allow NULL? 
6NOMNRNomination numbernvarchar200CHAR(N' ')YesOIJ_NOMNR Allow NULL? 
7NOMSTNomination header statuschar10CHAR(N' ')YesOIJSTATOIJ_NOMST Allow NULL? 
8NMSHTYPETD shipment typenvarchar40CHAR(N' ')YesTOIGSOIG_TDSTYP Allow NULL? 
9NMBALCHBalance check indicator (default)char10CHAR(N' ')YesOIJ_BALCH Allow NULL? 
10STAGES_IDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220CHAR(N' ')Yes*GUID_22 Allow NULL? 
11WORKLISTWorklist entry indicatorchar10CHAR(N' ')YesOIJ_WORKLT Allow NULL? 
12SENTDATLast header action datenvarchar80DATS(N'00000000')YesOIJ_SENDAT Allow NULL? 
13SENTTIMELast header action timenvarchar60TIMS(N'000000')YesOIJ_SENTIM Allow NULL? 
14SENTNAMLast user who worked on objectnvarchar120CHAR(N' ')YesOIJ_SENNAM Allow NULL? 
15ITEMSNomination item counternvarchar40NUMC(N'0000')YesOIJ_ITEMCOUNTER Allow NULL? 
16COUNTER1Nomination planned item Counternvarchar40NUMC(N'0000')YesOIJ_PLANNEDITEMS Allow NULL? 
17COUNTER2Nomination scheduled Item Counternvarchar40NUMC(N'0000')YesOIJ_SCHEDULEDITEMS Allow NULL? 
18COUNTER3Nomination rejected Item Counternvarchar40NUMC(N'0000')YesOIJ_REJECTEDITEMS Allow NULL? 
19COUNTER4Nomination confirmed Item Counternvarchar40NUMC(N'0000')YesOIJ_CONFIRMEDITEMS Allow NULL? 
20COUNTER5Nomination partially complete Item Counternvarchar40NUMC(N'0000')YesOIJ_PARTCOMPLETEITEMS Allow NULL? 
21COUNTER6Nomination completed Item Counternvarchar40NUMC(N'0000')YesOIJ_COMPLETEDITEMS Allow NULL? 
22APO_SHIPMENT_IDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220CHAR(N' ')YesGUID_22 Allow NULL? 
23APO_SHIPMENT_NUMShipment Numbernvarchar100CHAR(N' ')Yes*TKNUM Allow NULL? 
24NMBLOCKBlocking indicatorchar10CHAR(N' ')YesOIJ_BLOIND Allow NULL? 
25NOMTYPDESCIS-Oil: Descriptive textnvarchar360CHAR(N' ')YesOI0_TEXT Allow NULL? 
26SHTYPShipment typenvarchar40CHAR(N' ')YesTVTKSHTYP Allow NULL? 
27TKNUMShipment Numbernvarchar100CHAR(N' ')YesVTTKTKNUM Allow NULL? 
28LOV_GLGain Loss LOV posting indicatorchar10CHAR(N' ')YesOIJ03_GLLOVPOST Allow NULL? 
29TSYSTTransport systemnvarchar100CHAR(N' ')Yes*OIJ_TSYST Allow NULL? 
30NMSHIPPERShippernvarchar100CHAR(N' ')Yes*OIJ_SHIPNR Allow NULL? 
31NMCARRIERTransport system Carriernvarchar100CHAR(N' ')Yes*OIJ_CARRNR Allow NULL? 
32CYCLENomination Pipeline cycle IDnvarchar100CHAR(N' ')YesOIJ_CYCLE Allow NULL? 
33NMWERKTransport system In-transit Plantnvarchar40CHAR(N' ')YesT001WOIJ_WERK Allow NULL? 
34NMLGORTTransport system In-transit Storage Locationnvarchar40CHAR(N' ')YesT001LOIJ_LGORT Allow NULL? 
35NMVEHICLETD Vehicle Numbernvarchar100CHAR(N' ')YesOIGVOIG_VHLNMR Allow NULL? 
36NMVESSELTD vehicle identifiernvarchar180CHAR(N' ')YesOIG_VEHID Allow NULL? 
37NMTPLSTTransportation planning pointnvarchar40CHAR(N' ')YesTTDSTPLST Allow NULL? 
38ROUTERoutenvarchar60CHAR(N' ')YesTVROROUTE Allow NULL? 
39BOOKTSBook TS indicatorchar10CHAR(N' ')YesOIJ_BOOKTS Allow NULL? 
40EV_GROUPTD - event default groupnvarchar40CHAR(N' ')YesOIG_EVGRP Allow NULL? 
41VKTRAMode of transportnvarchar20CHAR(N' ')YesTVTRVKTRA Allow NULL? 
42QTYINQty received in TSdecimal133QUAN((0))YesOIJ_QTYIN
43QTYOUTQty delivered from TSdecimal133QUAN((0))YesOIJ_QTYOUT
44UNITNomination(pipe) UoMnvarchar30UNIT(N' ')Yes*OIJ_NMUNIT Allow NULL? 
45TST_FROM_MINScheduled / Acceptance / Pipe Batch Start Timestampdecimal150DEC((0))YesOIJ_SCHED_F
46TST_TO_MAXScheduled / Acceptance / Pipe Batch End Timestampdecimal150DEC((0))YesOIJ_SCHED_T
47BLOINDBlocking indicatorchar10CHAR(N' ')YesOIJ_BLOIND Allow NULL? 
48DELINDDeletion indicatorchar10CHAR(N' ')YesOIJ_DELIND Allow NULL? 
49SHNUMTD shipment numbernvarchar100CHAR(N' ')YesOIGSOIG_SHNUM Allow NULL? 
50ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
51ERZEITTime of creationnvarchar60TIMS(N'000000')YesOI0_ERTIM Allow NULL? 
52ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
53AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
54AEZEITTime of day the record was changednvarchar60TIMS(N'000000')YesOI0_AETIM Allow NULL? 
55AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
56EV_SEQ_UNITD Event sequence number (unique)char10CHAR(N' ')YesOIG_EVSEQU Allow NULL? 
57VSARTShipping typenvarchar20CHAR(N' ')YesT173VERSART Allow NULL? 
58SHTYPETD shipment typenvarchar40CHAR(N' ')YesTOIGSOIG_TDSTYP Allow NULL? 
59VEHIDDefault vehicle numbernvarchar100CHAR(N' ')YesOIGVOIJ_DEFVEH Allow NULL? 
60TSSUOMVTS standard volume UoMnvarchar30UNIT(N' ')YesT006OIJ_TSUOMV Allow NULL? 
61TSSUOMMTS standard weight UoMnvarchar30UNIT(N' ')YesT006OIJ_TSUOMM Allow NULL? 
62CYCPERDTS cycle durationdecimal100QUAN((0))YesOIJ_CYCDUR
63CYCPUOMTS cycle duration UoMnvarchar30UNIT(N' ')YesT006OIJ_CYDUOM Allow NULL? 
64CARRIERTransport system Carriernvarchar100CHAR(N' ')YesLFA1OIJ_CARRNR Allow NULL? 
65WERKTransport system In-transit Plantnvarchar40CHAR(N' ')YesT001WOIJ_WERK Allow NULL? 
66LGORTTransport system In-transit Storage Locationnvarchar40CHAR(N' ')YesT001LOIJ_LGORT Allow NULL? 
67NOMMSKNomination masknvarchar100CHAR(N' ')YesOIJ_NOMMSK Allow NULL? 
68SHIPPERDefault TS shipper codenvarchar100CHAR(N' ')YesOIJ_SHPPER Allow NULL? 
69CONLTMCarrier lead timedecimal30QUAN((0))YesOIJ_CONLTM
70CONLUOMConfirmation lead time UoMnvarchar30UNIT(N' ')YesT006OIJ_CONTUM Allow NULL? 
71TPLSTTransportation planning pointnvarchar40CHAR(N' ')YesTTDSTPLST Allow NULL? 
72UNLIMITEDIndicator: Unlimited Overdelivery Allowedchar10CHAR(N' ')YesUEBTK Allow NULL? 
73BOTOLQuantity tolerance over (percentage)decimal41DEC((0))YesOIJ_BOTOL
74BUTOLQuantity tolerance under (%)decimal41DEC((0))YesOIJ_BUTOL
75BOTOLABSAbsolute tolerance qty overdecimal133QUAN((0))YesOIJ_TOLABO
76BUTOLABSAbsolute tolerance qty underdecimal133QUAN((0))YesOIJ_TOLABS
77BULTOLUOMAbsolute tolerance UoMnvarchar30UNIT(N' ')YesT006OIJ_TOLUOM Allow NULL? 
78BALCHBalance check indicator (default)char10CHAR(N' ')YesOIJ_BALCH Allow NULL? 
79FLTTNOMTKNomination (technical) Keynvarchar200CHAR(N' ')Yes*OIJ_NOMTK Allow NULL? 
80EXTNOMNRExternal Nomination Numbernvarchar100CHAR(N' ')YesOIJ_RU_EXTNOMNR Allow NULL? 
81CHANGENRChange Numbernvarchar40NUMC(N'0000')YesOIJ_RU_CHANGENR Allow NULL? 
82NOMSTATUSRUNomination Approval Statuschar10CHAR(N' ')YesOIJ_RU_NOM_STATUS Allow NULL? 
83DISPATCHTYPFreight Shipment Typenvarchar20CHAR(N' ')YesOIJ_RU_DISP_TYPOIJ_RU_DISPTYP Allow NULL? 
84DISPATCHRECDispatch Schedulingnvarchar20CHAR(N' ')YesOIJ_RU_DISP_RECOIJ_RU_DISPREC Allow NULL? 
85CONNECTIONTYPRoute Typenvarchar20CHAR(N' ')YesOIJ_RU_CONN_TYPOIJ_RU_CONNTYP Allow NULL? 
86RAILCAROWNRailcar Ownershipnvarchar20CHAR(N' ')YesOIJ_RU_RAIL_OWNOIJ_RU_RAILOWN Allow NULL? 
87TARIFFCODSpecial Tariff Codenvarchar50CHAR(N' ')YesOIJ_RU_TARIFFCOD Allow NULL? 
88PAYERTYPResponsible Party for Paymentnvarchar20CHAR(N' ')YesOIJ_RU_PYR_TYPOIJ_RU_PYRTYP Allow NULL? 
89SENDCATPartner Objectchar10CHAR(N' ')YesOIJ_RU_PAR_CAT Allow NULL? 
90SENDERSendernvarchar100CHAR(N' ')YesOIJ_RU_SEND Allow NULL? 
91RECVCATPartner Objectchar10CHAR(N' ')YesOIJ_RU_PAR_CAT Allow NULL? 
92RECEIVERReceivernvarchar100CHAR(N' ')YesOIJ_RU_RECV Allow NULL? 
93PYRCATPartner Objectchar10CHAR(N' ')YesOIJ_RU_PAR_CAT Allow NULL? 
94PAYERPayernvarchar100CHAR(N' ')YesOIJ_RU_PYR Allow NULL? 
95ROWNCATPartner Objectchar10CHAR(N' ')YesOIJ_RU_PAR_CAT Allow NULL? 
96ROADOWNERAccess Road Ownernvarchar100CHAR(N' ')YesOIJ_RU_ROWN Allow NULL? 
97NOMNREGDATENomination Registration Datenvarchar80DATS(N'00000000')YesOIJ_RU_NOMNREGDATE Allow NULL? 
98NOMNVALDFROMNomination Validity Period Fromnvarchar80DATS(N'00000000')YesOIJ_RU_NOMNVALPERIOD Allow NULL? 
99NOMNVALDTONomination Valid Period Tonvarchar80DATS(N'00000000')YesOIJ_RU_NOMNVALPERIODTO Allow NULL? 
NamePrimaryUniqueTypeColumns
OIJNOMH~0YesYesCLUSTEREDNOMTK, MANDT
OIJNOMH~A01NoNoNONCLUSTEREDAEDAT, NOMNR, MANDT
OIJNOMH~TSCNoNoNONCLUSTEREDNMCARRIER, TSYST, MANDT
OIJNOMH~VEHNoNoNONCLUSTEREDDELIND, NMVEHICLE, 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