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  | OIJNOMIVERS
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)
8BSEG345Accounting Document Segment
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
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Industry Specific :: Industry Solution Oil :: Downstream :: Traders and Schedulers Workbench
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIJNOMIVERS1052Nomination Item 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, NOMIT, BPRC, SITYP, ISTAT, ISUBSTAT, IDATE, SCHED_TST_FROM, SCHED_TST_TO, LOCID, S_MATNR_I, MATNR_I, MENGE, UNIT_I, UNIT_I_T, DOCIND, DOCNR, DOCITM, DOCSCHEDLN, QTYFCR, QTYFCR_UOM, WORKLIST_I, TANK, CONS, PARTNR, CONPAT, INSPE, IMPOEXPO, FLAG_IMEX, OWNER, CHARG_O, CHARG_D, RVP, VALUATIONTYPE_O, VALUATIONTYPE_D, SHNUM, SHITEM, ILOCK, PRORATEQTY, ASSIGNEDQTY, ACTDAT, ACTTIME, ACTUALS, ACTUALQTY, ACTUALUOM, ITBOTOL, ITBUTOL, ITBOTOLABS, ITBUTOLABS, ITTOLUNIT, UNLIMITED, BLOIND, DELIND, UPDATEXDOK, INCOMPLETE_FLAG, DOCTYP, LDRATE, LDQUOM, LDTUOM, THIRD_NOMNR, UPMAT, REFITEM, STLTY, STLKN, CHARG_D_CREATE, CHARG_O_CREATE, CO_CARR, CO_SHIP, CO_TSYST, COMMCTL, SOLDTO, PRORATE_ROUTINE, CHARG_L, CHARG_L_CREATE, TCNUM, TCITM, GA_NMSHIPPER, GA_CONF_QTY, GA_CONF_UOM, GA_TECHSCH_QTY, GA_TECHSCH_UOM, GA_CONF_QTY_CAL, GA_TSCH_QTY_CAL, GA_ALLOCATED_QTY, GA_ALLOCATED_UOM, GA_RANK, CYCLE_ITEM, LESSHNUM, LESTPNUM, ATL_DELV_NUMBER, ATL_DELV_ITM, ATL_CRDT_QTY, ATL_CRDT_UOM, ATL_CRDT_VAL, ATL_CRDT_CURR, PRE_EXIST_IND, PLANIND, LOCPT, LOCSL, QUICKCONF, LOCNAM, VBELN, POSNR FROM OIJNOMIVERS
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? 
4NOMITNomination Key Itemnvarchar100NUMC(N'0000000000')No*OIJ_ITEM Allow NULL? 
5BPRCBusiness Process Codenvarchar100CHAR(N' ')YesTOIJNOM_ST02OIJ_NOMBPRC Allow NULL? 
6SITYPSchedule typenvarchar20CHAR(N' ')YesTOIJ_EL_SITYPESOIJ_SITYP Allow NULL? 
7ISTATNomination Item statuschar10CHAR(N' ')YesOIJSTATOIJ_ISTAT Allow NULL? 
8ISUBSTATNomination Item sub-statuschar10CHAR(N' ')YesOIJSUBSTATOIJ_SSTAT Allow NULL? 
9IDATEScheduled datenvarchar80DATS(N'00000000')YesOIJ_IDATE Allow NULL? 
10SCHED_TST_FROMScheduled / Acceptance / Pipe Batch Start Timestampdecimal150DEC((0))YesOIJ_SCHED_F
11SCHED_TST_TOScheduled / Acceptance / Pipe Batch End Timestampdecimal150DEC((0))YesOIJ_SCHED_T
12LOCIDLocation IDnvarchar100CHAR(N' ')YesOIJLOCOIJ_LOCID Allow NULL? 
13S_MATNR_IScheduled materialnvarchar180CHAR(N' ')YesMARAOIJ_SMATNR Allow NULL? 
14MATNR_IDemand materialnvarchar180CHAR(N' ')YesMARAOIJ_MATNRI Allow NULL? 
15MENGEScheduled qtydecimal133QUAN((0))YesOIJ_MENGE
16UNIT_IScheduled UoMnvarchar30UNIT(N' ')YesT006OIJ_UNITI Allow NULL? 
17UNIT_I_TScheduled UoM Timenvarchar30UNIT(N' ')Yes*OIJ_UNITI_T Allow NULL? 
18DOCINDReference document indicator (PSX)char10CHAR(N' ')YesOIJ_DOCIND Allow NULL? 
19DOCNRNomination Reference Documentnvarchar100CHAR(N' ')YesOIJ_DOCNR Allow NULL? 
20DOCITMNomination Reference Document Itemnvarchar60NUMC(N'000000')YesOIJ_DOCITM Allow NULL? 
21DOCSCHEDLNNomination Reference Document Schedule linenvarchar40NUMC(N'0000')Yes*OIJ_DOCSCHEDLN Allow NULL? 
22QTYFCRFirst requested quantitydecimal133QUAN((0))YesOIJ_QTYFCR
23QTYFCR_UOMFirst Requested Quantity UoMnvarchar30UNIT(N' ')Yes*OIJ_QTYFCR_UOM Allow NULL? 
24WORKLIST_IWorklist entry indicatorchar10CHAR(N' ')YesOIJ_WORKLT Allow NULL? 
25TANKTankage Partnernvarchar100CHAR(N' ')YesOIJ_TANKAGE Allow NULL? 
26CONSConsignee Partnernvarchar100CHAR(N' ')YesOIJ_CONSIGNEE Allow NULL? 
27PARTNRLocation Partnernvarchar100CHAR(N' ')YesOIJ_PARTNR Allow NULL? 
28CONPATContract Partnernvarchar100CHAR(N' ')YesOIJ_CONPAT Allow NULL? 
29INSPEInspectornvarchar100CHAR(N' ')YesOIJ_INSPECTOR Allow NULL? 
30IMPOEXPOImport / Export Partnernvarchar100CHAR(N' ')YesLFA1OIJ_IMEXPO Allow NULL? 
31FLAG_IMEXImport / Export Partner Indicatornvarchar20CHAR(N' ')YesOIJIMEXOIJ_IMEXFL Allow NULL? 
32OWNERValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
33CHARG_OBatch origin Locationnvarchar100CHAR(N' ')Yes*OIJ_CHARGO Allow NULL? 
34CHARG_DBatch destination Locationnvarchar100CHAR(N' ')Yes*OIJ_CHARGD Allow NULL? 
35RVPRVP valuedecimal41DEC((0))YesOIJ_RVP
36VALUATIONTYPE_OValuation Type Origin Loc.nvarchar100CHAR(N' ')YesT149DOIJ_BWTAR_O Allow NULL? 
37VALUATIONTYPE_DValuation Type Destination Loc.nvarchar100CHAR(N' ')YesT149DOIJ_BWTAR_D Allow NULL? 
38SHNUMTD shipment numbernvarchar100CHAR(N' ')YesOIGSOIG_SHNUM Allow NULL? 
39SHITEMShipment itemnvarchar40NUMC(N'0000')YesOIGSIOIG_SHITM Allow NULL? 
40ILOCKNomination item complete flagchar10CHAR(N' ')YesOIJ_ILOCK Allow NULL? 
41PRORATEQTYProrated Quantitydecimal133QUAN((0))YesOIJ_PRRA_QTY
42ASSIGNEDQTYAssigned Quantitydecimal133QUAN((0))YesOIJ_ASSG_QTY
43ACTDATLast item action datenvarchar80DATS(N'00000000')YesOIJ_ACTDAT Allow NULL? 
44ACTTIMELast item action timenvarchar60TIMS(N'000000')YesOIJ_ACTIME Allow NULL? 
45ACTUALSNomination item partially completechar10CHAR(N' ')YesOIJ_ACTUAL Allow NULL? 
46ACTUALQTYActual posted quantitydecimal133QUAN((0))YesOIJ_ACTQTY
47ACTUALUOMActual posted quantity Unit of Measurenvarchar30UNIT(N' ')YesT006OIJ_ACTUOM Allow NULL? 
48ITBOTOLQuantity tolerance over (percentage)decimal41DEC((0))YesOIJ_BOTOL
49ITBUTOLQuantity tolerance under (%)decimal41DEC((0))YesOIJ_BUTOL
50ITBOTOLABSAbsolute tolerance qty overdecimal133QUAN((0))YesOIJ_TOLABO
51ITBUTOLABSAbsolute tolerance qty underdecimal133QUAN((0))YesOIJ_TOLABS
52ITTOLUNITAbsolute tolerance UoMnvarchar30UNIT(N' ')YesT006OIJ_TOLUOM Allow NULL? 
53UNLIMITEDIndicator: Unlimited Overdelivery Allowedchar10CHAR(N' ')YesUEBTK Allow NULL? 
54BLOINDBlocking indicatorchar10CHAR(N' ')YesOIJ_BLOIND Allow NULL? 
55DELINDDeletion indicatorchar10CHAR(N' ')YesOIJ_DELIND Allow NULL? 
56UPDATEXDOKUpdate external details failure flagchar10CHAR(N' ')YesOIJ_EXDOK Allow NULL? 
57INCOMPLETE_FLAGIncompletion Flagchar10CHAR(N' ')YesOIJ_INCOMPLETE_FLAG Allow NULL? 
58DOCTYPReference Document Typenvarchar40CHAR(N' ')YesOIJ_DOCTYP Allow NULL? 
59LDRATEPlanned load/discharge ratedecimal133QUAN((0))YesOIJ_EL_LDRATE
60LDQUOMPlanned load/discharge rate quantity UoMnvarchar30UNIT(N' ')Yes*OIJ_EL_LDQUOM Allow NULL? 
61LDTUOMPlanned load/discharge rate time UOMnvarchar30UNIT(N' ')Yes*OIJ_EL_LDTUOM Allow NULL? 
62THIRD_NOMNRPartner Nomination numbernvarchar200CHAR(N' ')YesOIJ_3RD_NOMNR Allow NULL? 
63UPMATPricing reference material of main itemnvarchar180CHAR(N' ')Yes*UPMAT Allow NULL? 
64REFITEMHigher-level item in bill of material structuresnvarchar100NUMC(N'0000000000')Yes*OIJ_REF_BOM_ITEM Allow NULL? 
65STLTYBOM categorychar10CHAR(N' ')YesSTLTY Allow NULL? 
66STLKNBOM item node numbernvarchar80NUMC(N'00000000')YesSTLKN Allow NULL? 
67CHARG_D_CREATEDestination Batch create new flagchar10CHAR(N' ')YesOIJ_CHARG_D_C Allow NULL? 
68CHARG_O_CREATEOrigin Batch create new flagchar10CHAR(N' ')YesOIJ_CHARG_O_C Allow NULL? 
69CO_CARRConnecting carriernvarchar100CHAR(N' ')Yes*OIJ_EL_CCA Allow NULL? 
70CO_SHIPConnecting shippernvarchar100CHAR(N' ')Yes*OIJ_EL_CSH Allow NULL? 
71CO_TSYSTConnecting Transport Systemnvarchar100CHAR(N' ')Yes*OIJ_EL_CTSYST Allow NULL? 
72COMMCTLNomination Communication Controlnvarchar20CHAR(N' ')YesOIJ_NOMCOMM Allow NULL? 
73SOLDTOCustomer Sold-to or Vendornvarchar100CHAR(N' ')YesOIJ_SOLDTO Allow NULL? 
74PRORATE_ROUTINEProrate Calculation Routine Typenvarchar60CHAR(N' ')YesTOIJ_EL_PR_RTOIJ_EL_DE_PR_RT Allow NULL? 
75CHARG_LBatch loadnvarchar100CHAR(N' ')Yes*OIJ_CHARGL Allow NULL? 
76CHARG_L_CREATELoad Batch create new flagchar10CHAR(N' ')YesOIJ_CHARG_L_C Allow NULL? 
77TCNUMTSW :Trading Contract numbernvarchar100CHAR(N' ')YesOIJ_TCNR Allow NULL? 
78TCITMTSW: Trading contract item numbernvarchar60NUMC(N'000000')YesOIJ_TCITM Allow NULL? 
79GA_NMSHIPPERShippernvarchar100CHAR(N' ')Yes*OIJ_SHIPNR Allow NULL? 
80GA_CONF_QTYConfirmed Quantitydecimal133QUAN((0))YesOIJ_CONFQTY
81GA_CONF_UOMUnit of Measure for Confirmed Quantity Fieldnvarchar30UNIT(N' ')Yes*OIJ_CONFUOM Allow NULL? 
82GA_TECHSCH_QTYTechnical Scheduled Quantity Fielddecimal133QUAN((0))YesOIJ_TECHSCHQTY
83GA_TECHSCH_UOMUnit of Measure for Technical Scheduled Quantity Fieldnvarchar30UNIT(N' ')Yes*OIJ_TECHSCHUOM Allow NULL? 
84GA_CONF_QTY_CALCalculated Values of Confirmed Quantity Fielddecimal133QUAN((0))YesOIJ_CONFQTY_CAL
85GA_TSCH_QTY_CALCalculated Values of Technical Scheduled Quantity Fielddecimal133QUAN((0))YesOIJ_TECHSCH_QTY_CAL
86GA_ALLOCATED_QTYAllocated Quantitydecimal133QUAN((0))YesOIJ_ALLOCATED_QTY
87GA_ALLOCATED_UOMUnit of Measure for Allocated Quantity Fieldnvarchar30UNIT(N' ')Yes*OIJ_ALLOCATED_UOM Allow NULL? 
88GA_RANKRanktinyint30INT1((0))YesOIJ_RANK
89CYCLE_ITEMNomination Pipeline cycle ID at Item Levelnvarchar100CHAR(N' ')YesOIJ_ITEMCYCLE Allow NULL? 
90LESSHNUMShipment Numbernvarchar100CHAR(N' ')YesVTTKTKNUM Allow NULL? 
91LESTPNUMShipment itemnvarchar40NUMC(N'0000')YesVTTPTPNUM Allow NULL? 
92ATL_DELV_NUMBERATL credit check delivery numbernvarchar100CHAR(N' ')Yes*OIJ_ATL_DELV Allow NULL? 
93ATL_DELV_ITMATL credit check delivery itemnvarchar60NUMC(N'000000')Yes*OIJ_ATL_DELV_ITM Allow NULL? 
94ATL_CRDT_QTYATL Credit Quantitydecimal133QUAN((0))YesOIJ_ATL_CREDIT_QTY
95ATL_CRDT_UOMBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
96ATL_CRDT_VALATL Credit Amountdecimal152CURR((0))YesOIJ_ATL_CREDIT_AMT
97ATL_CRDT_CURRATL Credit Currencynvarchar50CUKY(N' ')Yes*OIJ_ATL_CREDIT_CURR Allow NULL? 
98PRE_EXIST_INDATL Preexisting Delivery Indicatorchar10CHAR(N' ')YesOIJ_ATL_PREEXIST_IND Allow NULL? 
99PLANINDPlanning location flagchar10CHAR(N' ')YesOIJ_PLANIN Allow NULL? 
100LOCPTLocation Partner Plantnvarchar40CHAR(N' ')YesT001WOIJ_LOCPT Allow NULL? 
101LOCSLLocation Partner Storage Locationnvarchar40CHAR(N' ')YesT001LOIJ_LOCSL Allow NULL? 
102QUICKCONFQuick Confirm check boxchar10CHAR(N' ')YesOIJ_QC Allow NULL? 
103LOCNAMLocation name (used by system owner)nvarchar600CHAR(N' ')YesOIJ_LOCNAM Allow NULL? 
104VBELNDeliverynvarchar100CHAR(N' ')YesVBUKVBELN_VL Allow NULL? 
105POSNRDelivery Itemnvarchar60NUMC(N'000000')YesVBUPPOSNR_VL Allow NULL? 
NamePrimaryUniqueTypeColumns
OIJNOMIVERS~0YesYesCLUSTEREDNOMIT, NOMTK, VERS_ID, MANDT
OIJNOMIVERS~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