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  | OIJNOMC
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.0OIJNOMC1091OIL-TSW: Nomination copy tableTraders and Schedulers Workbench
SQL:  selectupdate insert create

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

SELECT MANDT, NOMTK, NOMIT, 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, ERDAT, ERZEIT, ERNAM, AEDAT, AEZEIT, AENAM, LOCNAM, VBELN, POSNR FROM OIJNOMC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2NOMTKNomination (technical) Keynvarchar200CHAR(N' ')NoOIJNOMHOIJ_NOMTK Allow NULL? 
3NOMITNomination Key Itemnvarchar100NUMC(N'0000000000')NoOIJNOMIOIJ_ITEM Allow NULL? 
4SITYPSchedule typenvarchar20CHAR(N' ')YesTOIJ_EL_SITYPESOIJ_SITYP Allow NULL? 
5ISTATNomination Item statuschar10CHAR(N' ')YesOIJSTATOIJ_ISTAT Allow NULL? 
6ISUBSTATNomination Item sub-statuschar10CHAR(N' ')YesOIJSUBSTATOIJ_SSTAT Allow NULL? 
7IDATEScheduled datenvarchar80DATS(N'00000000')YesOIJ_IDATE Allow NULL? 
8SCHED_TST_FROMScheduled / Acceptance / Pipe Batch Start Timestampdecimal150DEC((0))YesOIJ_SCHED_F
9SCHED_TST_TOScheduled / Acceptance / Pipe Batch End Timestampdecimal150DEC((0))YesOIJ_SCHED_T
10LOCIDLocation IDnvarchar100CHAR(N' ')YesOIJLOCOIJ_LOCID Allow NULL? 
11S_MATNR_IScheduled materialnvarchar180CHAR(N' ')YesMARAOIJ_SMATNR Allow NULL? 
12MATNR_IDemand materialnvarchar180CHAR(N' ')YesMARAOIJ_MATNRI Allow NULL? 
13MENGEScheduled qtydecimal133QUAN((0))YesOIJ_MENGE
14UNIT_IScheduled UoMnvarchar30UNIT(N' ')YesT006OIJ_UNITI Allow NULL? 
15UNIT_I_TScheduled UoM Timenvarchar30UNIT(N' ')Yes*OIJ_UNITI_T Allow NULL? 
16DOCINDReference document indicator (PSX)char10CHAR(N' ')YesOIJ_DOCIND Allow NULL? 
17DOCNRNomination Reference Documentnvarchar100CHAR(N' ')YesOIJ_DOCNR Allow NULL? 
18DOCITMNomination Reference Document Itemnvarchar60NUMC(N'000000')YesOIJ_DOCITM Allow NULL? 
19DOCSCHEDLNNomination Reference Document Schedule linenvarchar40NUMC(N'0000')Yes*OIJ_DOCSCHEDLN Allow NULL? 
20QTYFCRFirst requested quantitydecimal133QUAN((0))YesOIJ_QTYFCR
21QTYFCR_UOMFirst Requested Quantity UoMnvarchar30UNIT(N' ')Yes*OIJ_QTYFCR_UOM Allow NULL? 
22WORKLIST_IWorklist entry indicatorchar10CHAR(N' ')YesOIJ_WORKLT Allow NULL? 
23TANKTankage Partnernvarchar100CHAR(N' ')YesOIJ_TANKAGE Allow NULL? 
24CONSConsignee Partnernvarchar100CHAR(N' ')YesOIJ_CONSIGNEE Allow NULL? 
25PARTNRLocation Partnernvarchar100CHAR(N' ')YesOIJ_PARTNR Allow NULL? 
26CONPATContract Partnernvarchar100CHAR(N' ')YesOIJ_CONPAT Allow NULL? 
27INSPEInspectornvarchar100CHAR(N' ')YesOIJ_INSPECTOR Allow NULL? 
28IMPOEXPOImport / Export Partnernvarchar100CHAR(N' ')YesLFA1OIJ_IMEXPO Allow NULL? 
29FLAG_IMEXImport / Export Partner Indicatornvarchar20CHAR(N' ')YesOIJIMEXOIJ_IMEXFL Allow NULL? 
30OWNERValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
31CHARG_OBatch origin Locationnvarchar100CHAR(N' ')YesMCH1OIJ_CHARGO Allow NULL? 
32CHARG_DBatch destination Locationnvarchar100CHAR(N' ')YesMCH1OIJ_CHARGD Allow NULL? 
33RVPRVP valuedecimal41DEC((0))YesOIJ_RVP
34VALUATIONTYPE_OValuation Type Origin Loc.nvarchar100CHAR(N' ')YesT149DOIJ_BWTAR_O Allow NULL? 
35VALUATIONTYPE_DValuation Type Destination Loc.nvarchar100CHAR(N' ')YesT149DOIJ_BWTAR_D Allow NULL? 
36SHNUMTD shipment numbernvarchar100CHAR(N' ')YesOIGSOIG_SHNUM Allow NULL? 
37SHITEMShipment itemnvarchar40NUMC(N'0000')YesOIGSIOIG_SHITM Allow NULL? 
38ILOCKNomination item complete flagchar10CHAR(N' ')YesOIJ_ILOCK Allow NULL? 
39PRORATEQTYProrated Quantitydecimal133QUAN((0))YesOIJ_PRRA_QTY
40ASSIGNEDQTYAssigned Quantitydecimal133QUAN((0))YesOIJ_ASSG_QTY
41ACTDATLast item action datenvarchar80DATS(N'00000000')YesOIJ_ACTDAT Allow NULL? 
42ACTTIMELast item action timenvarchar60TIMS(N'000000')YesOIJ_ACTIME Allow NULL? 
43ACTUALSNomination item partially completechar10CHAR(N' ')YesOIJ_ACTUAL Allow NULL? 
44ACTUALQTYActual posted quantitydecimal133QUAN((0))YesOIJ_ACTQTY
45ACTUALUOMActual posted quantity Unit of Measurenvarchar30UNIT(N' ')YesT006OIJ_ACTUOM Allow NULL? 
46ITBOTOLQuantity tolerance over (percentage)decimal41DEC((0))YesOIJ_BOTOL
47ITBUTOLQuantity tolerance under (%)decimal41DEC((0))YesOIJ_BUTOL
48ITBOTOLABSAbsolute tolerance qty overdecimal133QUAN((0))YesOIJ_TOLABO
49ITBUTOLABSAbsolute tolerance qty underdecimal133QUAN((0))YesOIJ_TOLABS
50ITTOLUNITAbsolute tolerance UoMnvarchar30UNIT(N' ')YesT006OIJ_TOLUOM Allow NULL? 
51UNLIMITEDIndicator: Unlimited Overdelivery Allowedchar10CHAR(N' ')YesUEBTK Allow NULL? 
52BLOINDBlocking indicatorchar10CHAR(N' ')YesOIJ_BLOIND Allow NULL? 
53DELINDDeletion indicatorchar10CHAR(N' ')YesOIJ_DELIND Allow NULL? 
54UPDATEXDOKUpdate external details failure flagchar10CHAR(N' ')YesOIJ_EXDOK Allow NULL? 
55INCOMPLETE_FLAGIncompletion Flagchar10CHAR(N' ')YesOIJ_INCOMPLETE_FLAG Allow NULL? 
56DOCTYPReference Document Typenvarchar40CHAR(N' ')YesOIJ_DOCTYP Allow NULL? 
57LDRATEPlanned load/discharge ratedecimal133QUAN((0))YesOIJ_EL_LDRATE
58LDQUOMPlanned load/discharge rate quantity UoMnvarchar30UNIT(N' ')Yes*OIJ_EL_LDQUOM Allow NULL? 
59LDTUOMPlanned load/discharge rate time UOMnvarchar30UNIT(N' ')Yes*OIJ_EL_LDTUOM Allow NULL? 
60THIRD_NOMNRPartner Nomination numbernvarchar200CHAR(N' ')YesOIJ_3RD_NOMNR Allow NULL? 
61UPMATPricing reference material of main itemnvarchar180CHAR(N' ')Yes*UPMAT Allow NULL? 
62REFITEMHigher-level item in bill of material structuresnvarchar100NUMC(N'0000000000')Yes*OIJ_REF_BOM_ITEM Allow NULL? 
63STLTYBOM categorychar10CHAR(N' ')YesSTLTY Allow NULL? 
64STLKNBOM item node numbernvarchar80NUMC(N'00000000')YesSTLKN Allow NULL? 
65CHARG_D_CREATEDestination Batch create new flagchar10CHAR(N' ')YesOIJ_CHARG_D_C Allow NULL? 
66CHARG_O_CREATEOrigin Batch create new flagchar10CHAR(N' ')YesOIJ_CHARG_O_C Allow NULL? 
67CO_CARRConnecting carriernvarchar100CHAR(N' ')Yes*OIJ_EL_CCA Allow NULL? 
68CO_SHIPConnecting shippernvarchar100CHAR(N' ')Yes*OIJ_EL_CSH Allow NULL? 
69CO_TSYSTConnecting Transport Systemnvarchar100CHAR(N' ')Yes*OIJ_EL_CTSYST Allow NULL? 
70COMMCTLNomination Communication Controlnvarchar20CHAR(N' ')YesOIJ_NOMCOMM Allow NULL? 
71SOLDTOCustomer Sold-to or Vendornvarchar100CHAR(N' ')YesOIJ_SOLDTO Allow NULL? 
72PRORATE_ROUTINEProrate Calculation Routine Typenvarchar60CHAR(N' ')YesTOIJ_EL_PR_RTOIJ_EL_DE_PR_RT Allow NULL? 
73CHARG_LBatch loadnvarchar100CHAR(N' ')Yes*OIJ_CHARGL Allow NULL? 
74CHARG_L_CREATELoad Batch create new flagchar10CHAR(N' ')YesOIJ_CHARG_L_C Allow NULL? 
75TCNUMTSW :Trading Contract numbernvarchar100CHAR(N' ')YesOIJ_TCNR Allow NULL? 
76TCITMTSW: Trading contract item numbernvarchar60NUMC(N'000000')YesOIJ_TCITM Allow NULL? 
77GA_NMSHIPPERShippernvarchar100CHAR(N' ')Yes*OIJ_SHIPNR Allow NULL? 
78GA_CONF_QTYConfirmed Quantitydecimal133QUAN((0))YesOIJ_CONFQTY
79GA_CONF_UOMUnit of Measure for Confirmed Quantity Fieldnvarchar30UNIT(N' ')Yes*OIJ_CONFUOM Allow NULL? 
80GA_TECHSCH_QTYTechnical Scheduled Quantity Fielddecimal133QUAN((0))YesOIJ_TECHSCHQTY
81GA_TECHSCH_UOMUnit of Measure for Technical Scheduled Quantity Fieldnvarchar30UNIT(N' ')Yes*OIJ_TECHSCHUOM Allow NULL? 
82GA_CONF_QTY_CALCalculated Values of Confirmed Quantity Fielddecimal133QUAN((0))YesOIJ_CONFQTY_CAL
83GA_TSCH_QTY_CALCalculated Values of Technical Scheduled Quantity Fielddecimal133QUAN((0))YesOIJ_TECHSCH_QTY_CAL
84GA_ALLOCATED_QTYAllocated Quantitydecimal133QUAN((0))YesOIJ_ALLOCATED_QTY
85GA_ALLOCATED_UOMUnit of Measure for Allocated Quantity Fieldnvarchar30UNIT(N' ')Yes*OIJ_ALLOCATED_UOM Allow NULL? 
86GA_RANKRanktinyint30INT1((0))YesOIJ_RANK
87CYCLE_ITEMNomination Pipeline cycle ID at Item Levelnvarchar100CHAR(N' ')YesOIJ_ITEMCYCLE Allow NULL? 
88LESSHNUMShipment Numbernvarchar100CHAR(N' ')YesVTTKTKNUM Allow NULL? 
89LESTPNUMShipment itemnvarchar40NUMC(N'0000')YesVTTPTPNUM Allow NULL? 
90ATL_DELV_NUMBERATL credit check delivery numbernvarchar100CHAR(N' ')Yes*OIJ_ATL_DELV Allow NULL? 
91ATL_DELV_ITMATL credit check delivery itemnvarchar60NUMC(N'000000')Yes*OIJ_ATL_DELV_ITM Allow NULL? 
92ATL_CRDT_QTYATL Credit Quantitydecimal133QUAN((0))YesOIJ_ATL_CREDIT_QTY
93ATL_CRDT_UOMBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
94ATL_CRDT_VALATL Credit Amountdecimal152CURR((0))YesOIJ_ATL_CREDIT_AMT
95ATL_CRDT_CURRATL Credit Currencynvarchar50CUKY(N' ')Yes*OIJ_ATL_CREDIT_CURR Allow NULL? 
96PRE_EXIST_INDATL Preexisting Delivery Indicatorchar10CHAR(N' ')YesOIJ_ATL_PREEXIST_IND Allow NULL? 
97PLANINDPlanning location flagchar10CHAR(N' ')YesOIJ_PLANIN Allow NULL? 
98LOCPTLocation Partner Plantnvarchar40CHAR(N' ')YesT001WOIJ_LOCPT Allow NULL? 
99LOCSLLocation Partner Storage Locationnvarchar40CHAR(N' ')YesT001LOIJ_LOCSL Allow NULL? 
100QUICKCONFQuick Confirm check boxchar10CHAR(N' ')YesOIJ_QC Allow NULL? 
101ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
102ERZEITTime of creationnvarchar60TIMS(N'000000')YesOI0_ERTIM Allow NULL? 
103ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
104AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
105AEZEITTime of day the record was changednvarchar60TIMS(N'000000')YesOI0_AETIM Allow NULL? 
106AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
107LOCNAMLocation name (used by system owner)nvarchar600CHAR(N' ')YesOIJ_LOCNAM Allow NULL? 
108VBELNDeliverynvarchar100CHAR(N' ')YesVBUKVBELN_VL Allow NULL? 
109POSNRDelivery Itemnvarchar60NUMC(N'000000')YesVBUPPOSNR_VL Allow NULL? 
NamePrimaryUniqueTypeColumns
OIJNOMC~0YesYesCLUSTEREDNOMIT, 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