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  | OIJNOMHVERS
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.0OIJNOMHVERS712Nomination Header Version TableTraders and Schedulers Workbench
SQL:  selectupdate insert create

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

SELECT MANDT, VERS_ID, NOMTK, BPRC, 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, 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 FROM OIJNOMHVERS
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VERS_IDNomination Version IDnvarchar200CHAR(N' ')NoOIJ_NOMVERS Allow NULL? 
3NOMTKNomination (technical) Keynvarchar200CHAR(N' ')NoOIJNOMHOIJ_NOMTK Allow NULL? 
4BPRCBusiness Process Codenvarchar100CHAR(N' ')YesTOIJNOM_ST02OIJ_NOMBPRC Allow NULL? 
5NOMCLNomination Classnvarchar20CHAR(N' ')YesOIJ_NOMCL Allow NULL? 
6NOMTYPNomination typenvarchar40CHAR(N' ')YesTOIJNOMTYPOIJ_NOMTYP Allow NULL? 
7BUSTYPBusiness typenvarchar40CHAR(N' ')YesOIRARNBTOIRA_RNBT Allow NULL? 
8NOMNRNomination numbernvarchar200CHAR(N' ')YesOIJ_NOMNR Allow NULL? 
9NOMSTNomination header statuschar10CHAR(N' ')YesOIJSTATOIJ_NOMST Allow NULL? 
10NMSHTYPETD shipment typenvarchar40CHAR(N' ')YesTOIGSOIG_TDSTYP Allow NULL? 
11NMBALCHBalance check indicator (default)char10CHAR(N' ')YesOIJ_BALCH Allow NULL? 
12STAGES_IDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220CHAR(N' ')Yes*GUID_22 Allow NULL? 
13WORKLISTWorklist entry indicatorchar10CHAR(N' ')YesOIJ_WORKLT Allow NULL? 
14SENTDATLast header action datenvarchar80DATS(N'00000000')YesOIJ_SENDAT Allow NULL? 
15SENTTIMELast header action timenvarchar60TIMS(N'000000')YesOIJ_SENTIM Allow NULL? 
16SENTNAMLast user who worked on objectnvarchar120CHAR(N' ')YesOIJ_SENNAM Allow NULL? 
17ITEMSNomination item counternvarchar40NUMC(N'0000')YesOIJ_ITEMCOUNTER Allow NULL? 
18COUNTER1Nomination planned item Counternvarchar40NUMC(N'0000')YesOIJ_PLANNEDITEMS Allow NULL? 
19COUNTER2Nomination scheduled Item Counternvarchar40NUMC(N'0000')YesOIJ_SCHEDULEDITEMS Allow NULL? 
20COUNTER3Nomination rejected Item Counternvarchar40NUMC(N'0000')YesOIJ_REJECTEDITEMS Allow NULL? 
21COUNTER4Nomination confirmed Item Counternvarchar40NUMC(N'0000')YesOIJ_CONFIRMEDITEMS Allow NULL? 
22COUNTER5Nomination partially complete Item Counternvarchar40NUMC(N'0000')YesOIJ_PARTCOMPLETEITEMS Allow NULL? 
23COUNTER6Nomination completed Item Counternvarchar40NUMC(N'0000')YesOIJ_COMPLETEDITEMS Allow NULL? 
24APO_SHIPMENT_IDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220CHAR(N' ')YesGUID_22 Allow NULL? 
25APO_SHIPMENT_NUMShipment Numbernvarchar100CHAR(N' ')Yes*TKNUM Allow NULL? 
26NMBLOCKBlocking indicatorchar10CHAR(N' ')YesOIJ_BLOIND Allow NULL? 
27NOMTYPDESCIS-Oil: Descriptive textnvarchar360CHAR(N' ')YesOI0_TEXT Allow NULL? 
28SHTYPShipment typenvarchar40CHAR(N' ')YesTVTKSHTYP Allow NULL? 
29TKNUMShipment Numbernvarchar100CHAR(N' ')YesVTTKTKNUM Allow NULL? 
30LOV_GLGain Loss LOV posting indicatorchar10CHAR(N' ')YesOIJ03_GLLOVPOST Allow NULL? 
31TSYSTTransport systemnvarchar100CHAR(N' ')YesOIJTSOIJ_TSYST Allow NULL? 
32NMSHIPPERShippernvarchar100CHAR(N' ')YesLFA1OIJ_SHIPNR Allow NULL? 
33NMCARRIERTransport system Carriernvarchar100CHAR(N' ')YesLFA1OIJ_CARRNR Allow NULL? 
34CYCLENomination Pipeline cycle IDnvarchar100CHAR(N' ')YesOIJ_CYCLE Allow NULL? 
35NMWERKTransport system In-transit Plantnvarchar40CHAR(N' ')YesT001WOIJ_WERK Allow NULL? 
36NMLGORTTransport system In-transit Storage Locationnvarchar40CHAR(N' ')YesT001LOIJ_LGORT Allow NULL? 
37NMVEHICLETD Vehicle Numbernvarchar100CHAR(N' ')YesOIGVOIG_VHLNMR Allow NULL? 
38NMVESSELTD vehicle identifiernvarchar180CHAR(N' ')YesOIG_VEHID Allow NULL? 
39NMTPLSTTransportation planning pointnvarchar40CHAR(N' ')YesTTDSTPLST Allow NULL? 
40ROUTERoutenvarchar60CHAR(N' ')YesTVROROUTE Allow NULL? 
41BOOKTSBook TS indicatorchar10CHAR(N' ')YesOIJ_BOOKTS Allow NULL? 
42EV_GROUPTD - event default groupnvarchar40CHAR(N' ')YesOIG_EVGRP Allow NULL? 
43VKTRAMode of transportnvarchar20CHAR(N' ')YesTVTRVKTRA Allow NULL? 
44QTYINQty received in TSdecimal133QUAN((0))YesOIJ_QTYIN
45QTYOUTQty delivered from TSdecimal133QUAN((0))YesOIJ_QTYOUT
46UNITNomination(pipe) UoMnvarchar30UNIT(N' ')Yes*OIJ_NMUNIT Allow NULL? 
47TST_FROM_MINScheduled / Acceptance / Pipe Batch Start Timestampdecimal150DEC((0))YesOIJ_SCHED_F
48TST_TO_MAXScheduled / Acceptance / Pipe Batch End Timestampdecimal150DEC((0))YesOIJ_SCHED_T
49EV_SEQ_UNITD Event sequence number (unique)char10CHAR(N' ')YesOIG_EVSEQU Allow NULL? 
50VSARTShipping typenvarchar20CHAR(N' ')YesT173VERSART Allow NULL? 
51SHTYPETD shipment typenvarchar40CHAR(N' ')YesTOIGSOIG_TDSTYP Allow NULL? 
52VEHIDDefault vehicle numbernvarchar100CHAR(N' ')YesOIGVOIJ_DEFVEH Allow NULL? 
53TSSUOMVTS standard volume UoMnvarchar30UNIT(N' ')YesT006OIJ_TSUOMV Allow NULL? 
54TSSUOMMTS standard weight UoMnvarchar30UNIT(N' ')YesT006OIJ_TSUOMM Allow NULL? 
55CYCPERDTS cycle durationdecimal100QUAN((0))YesOIJ_CYCDUR
56CYCPUOMTS cycle duration UoMnvarchar30UNIT(N' ')Yes*OIJ_CYDUOM Allow NULL? 
57CARRIERTransport system Carriernvarchar100CHAR(N' ')Yes*OIJ_CARRNR Allow NULL? 
58WERKTransport system In-transit Plantnvarchar40CHAR(N' ')Yes*OIJ_WERK Allow NULL? 
59LGORTTransport system In-transit Storage Locationnvarchar40CHAR(N' ')YesT001LOIJ_LGORT Allow NULL? 
60NOMMSKNomination masknvarchar100CHAR(N' ')YesOIJ_NOMMSK Allow NULL? 
61SHIPPERDefault TS shipper codenvarchar100CHAR(N' ')YesOIJ_SHPPER Allow NULL? 
62CONLTMCarrier lead timedecimal30QUAN((0))YesOIJ_CONLTM
63CONLUOMConfirmation lead time UoMnvarchar30UNIT(N' ')YesT006OIJ_CONTUM Allow NULL? 
64TPLSTTransportation planning pointnvarchar40CHAR(N' ')YesTTDSTPLST Allow NULL? 
65UNLIMITEDIndicator: Unlimited Overdelivery Allowedchar10CHAR(N' ')YesUEBTK Allow NULL? 
66BOTOLQuantity tolerance over (percentage)decimal41DEC((0))YesOIJ_BOTOL
67BUTOLQuantity tolerance under (%)decimal41DEC((0))YesOIJ_BUTOL
68BOTOLABSAbsolute tolerance qty overdecimal133QUAN((0))YesOIJ_TOLABO
69BUTOLABSAbsolute tolerance qty underdecimal133QUAN((0))YesOIJ_TOLABS
70BULTOLUOMAbsolute tolerance UoMnvarchar30UNIT(N' ')YesT006OIJ_TOLUOM Allow NULL? 
71BALCHBalance check indicator (default)char10CHAR(N' ')YesOIJ_BALCH Allow NULL? 
NamePrimaryUniqueTypeColumns
OIJNOMHVERS~0YesYesCLUSTEREDNOMTK, VERS_ID, MANDT
OIJNOMHVERS~BPRNoNoNONCLUSTEREDBPRC, NOMTK, 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