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  | OIGSV
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.0OIGSV721TD Vehicles in Transport/ShipmentTraders and Schedulers Workbench
SQL:  selectupdate insert create

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

SELECT CLIENT, SHNUMBER, VEH_NR, VEHICLE, COMP_GROUP, VEH_TYPE, VEH_ID, CARRIER, VEH_NRTUS, VOL_UOM, WGT_UOM, DIM_UOM, VEH_MAXWGT, VEH_UNLWGT, VEH_MAXVOL, EQUIP_NR, VEH_HEIGHT, VEH_WIDTH, VEH_LENGTH, ROUTE, TZONE, CALENDAR, DEPOT, VEH_SCREL, NAME_EFF_DATE, CLF_EFDT, REG_CNTRY, REG_DATE, OWNER, REG_OWNER, GRP_ID, OWN_FLAG, BALLCAP, FL_BNK_CAPA, DSL_BNK_CAPA, CAP_UOM, WT_UOM, CLASS_GRP, VHCLSIGN, STCMNR, SRFXNR, DRAFT, OIG_SSTSF, LDDATE, LDTIME, SHIFT, TRIP, RTDATE, RTTIME, PRINTFLG, DDCDAT, PSTDAT, MBLNRGL, MBLNR, MJAHR, VCLOSE, GLPST, VBALNC, REAS_CODE, CHK_OVL, CRE_DATE, CRE_NAME, CRE_TIME, CHA_DATE, CHA_NAME, CHA_TIME, TPPOINT, FBSTA, FBGST, ARSTA, ARGST, SKALSM FROM OIGSV
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1CLIENTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SHNUMBERTD shipment numbernvarchar100CHAR(N' ')NoOIGSOIG_SHNUM Allow NULL? 
3VEH_NRVehicle Sequence Number in Shipmentnvarchar30NUMC(N'000')NoOIG_VEHNR Allow NULL? 
4VEHICLETD Vehicle Numbernvarchar100CHAR(N' ')YesOIGVOIG_VHLNMR Allow NULL? 
5COMP_GROUPTD Vehicle Customer groupnvarchar80CHAR(N' ')YesTOIGBVOIG_VEHCUSTGRP Allow NULL? 
6VEH_TYPETD vehicle typenvarchar40CHAR(N' ')YesTOIGVOIG_VHLTYP Allow NULL? 
7VEH_IDTD vehicle identifiernvarchar180CHAR(N' ')YesOIG_VEHID Allow NULL? 
8CARRIERTD carrier (vendor account number)nvarchar100CHAR(N' ')YesLFA1OIG_LIFNR Allow NULL? 
9VEH_NRTUSNumber of transport units on vehicle (TD)nvarchar20NUMC(N'00')YesOIG_NMRTU Allow NULL? 
10VOL_UOMTD volume unit of measurenvarchar30UNIT(N' ')YesT006OIG_VOLUOM Allow NULL? 
11WGT_UOMTD weight unit of measurenvarchar30UNIT(N' ')YesT006OIG_WGTUOM Allow NULL? 
12DIM_UOMTD dimension unit of measurenvarchar30UNIT(N' ')YesT006OIG_DIMUOM Allow NULL? 
13VEH_MAXWGTTD vehicle maximum weightfloat1516FLTP((0))YesOIG_VEHMWT
14VEH_UNLWGTTD vehicle unladen weightfloat1516FLTP((0))YesOIG_VEHUWT
15VEH_MAXVOLTD vehicle maximum volumefloat1516FLTP((0))YesOIG_VEHMVL
16EQUIP_NREquipment Numbernvarchar180CHAR(N' ')YesEQUIEQUNR Allow NULL? 
17VEH_HEIGHTVehicle heightdecimal133QUAN((0))YesOIG_VEHHEI
18VEH_WIDTHTD widthdecimal133QUAN((0))YesOIG_VEHWID
19VEH_LENGTHVehicle lengthdecimal133QUAN((0))YesOIG_VEHLEN
20ROUTETD-F vehicle routenvarchar60CHAR(N' ')YesTVROOIG_ROUTEV Allow NULL? 
21TZONETime Zonenvarchar60CHAR(N' ')YesTTZZTZNZONE Allow NULL? 
22CALENDARFactory calendar IDnvarchar20CHAR(N' ')YesTFACDCR_WFCID Allow NULL? 
23DEPOTPlantnvarchar40CHAR(N' ')YesT001WWERKS_D Allow NULL? 
24VEH_SCRELFreight cost relevant vehiclenvarchar100CHAR(N' ')YesOIGVOIG_VHSCREL Allow NULL? 
25NAME_EFF_DATEName Effective Datenvarchar80DATS(N'00000000')Yes*OIG_NMEFFDT Allow NULL? 
26CLF_EFDTVehicle Classification Effective Datenvarchar80DATS(N'00000000')Yes*OIG_CLFEFFDT Allow NULL? 
27REG_CNTRYVehicle Registered Countrynvarchar30CHAR(N' ')YesT005OIG_REG_CNTR Allow NULL? 
28REG_DATETD-Vehicle Registered Datenvarchar80DATS(N'00000000')Yes*OIG_REGDT Allow NULL? 
29OWNERTD-Vehicle Ownernvarchar200CHAR(N' ')YesOIG_VEH_OWNER Allow NULL? 
30REG_OWNERTD-Vehicle Registered Ownernvarchar200CHAR(N' ')YesOIG_VEH_REG_OWN Allow NULL? 
31GRP_IDTD-Vehicle Berth Compatibility Group IDnvarchar100CHAR(N' ')YesTOI0_CP_GRPOIG_BR_CP_GRP_ID Allow NULL? 
32OWN_FLAGTD-Vehicle Own Flagchar10CHAR(N' ')YesOIG_VOWNFL Allow NULL? 
33BALLCAPTD-Vehicle Ballast Capacitydecimal133QUAN((0))YesOIG_BALLCAP
34FL_BNK_CAPATD-Vehicle Fuel Bunker Capacitydecimal133QUAN((0))YesOIG_FL_BNK_CAPA
35DSL_BNK_CAPATD-Vehicle Diesel Bunker Capacitydecimal133QUAN((0))YesOIG_DSL_BNK_CAPA
36CAP_UOMUoM of TD-Vehicle Bunker Capacitynvarchar30UNIT(N' ')YesT006OIG_CAP_UOM Allow NULL? 
37WT_UOMUoM of TD-Vehicle(For Draft)nvarchar30UNIT(N' ')YesT006OIG_WT_UOM Allow NULL? 
38CLASS_GRPTD-Vehicle Classification Groupnvarchar100CHAR(N' ')YesTOIGVCLGROIG_CL_GRP Allow NULL? 
39VHCLSIGNTD-Vehicle Call Signnvarchar100CHAR(N' ')YesOIG_VHCLSIGN Allow NULL? 
40STCMNRTD-Vehicle Telex Numbernvarchar300CHAR(N' ')YesOIG_STCMNR Allow NULL? 
41SRFXNRTD-Vehicle Fax Numbernvarchar300CHAR(N' ')YesOIG_STFXNR Allow NULL? 
42DRAFTMaximum Vehicle Draftdecimal133QUAN((0))YesOIG_VEH_DRAFT
43OIG_SSTSFTD Shipment Status (Functional)char10CHAR(N' ')YesOIG_SSTSF Allow NULL? 
44LDDATELoading Datenvarchar80DATS(N'00000000')YesOIG_LDDATE Allow NULL? 
45LDTIMELoading timenvarchar60TIMS(N'000000')YesOIG_LDTIME Allow NULL? 
46SHIFTTD driver shiftchar10CHAR(N' ')YesTOIGHOIG_SHIFT Allow NULL? 
47TRIPTrip Numbernvarchar50NUMC(N'00000')YesOIG_TRIP Allow NULL? 
48RTDATEDate of returnnvarchar80DATS(N'00000000')YesOIG_RTDATE Allow NULL? 
49RTTIMETime of returnnvarchar60TIMS(N'000000')YesOIG_RTTIME Allow NULL? 
50PRINTFLGOutput selection flag (indicates print required)char10CHAR(N' ')YesOIG_PRNTFL Allow NULL? 
51DDCDATDocument date in delivery confirmationnvarchar80DATS(N'00000000')YesOIG_DDCDAT Allow NULL? 
52PSTDATPosting date in delivery confirmationnvarchar80DATS(N'00000000')YesOIG_PSTDAT Allow NULL? 
53MBLNRGLNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
54MBLNRNumber of Material Documentnvarchar100CHAR(N' ')YesMBLNR Allow NULL? 
55MJAHRMaterial Document Yearnvarchar40NUMC(N'0000')YesMJAHR Allow NULL? 
56VCLOSEVehicle close flag; set confirmation to complete (status=6)char10CHAR(N' ')NoOIG_VCLOSE Allow NULL? 
57GLPSTTD gain/loss postings at vehicle closechar10CHAR(N' ')NoOIG_GLPST Allow NULL? 
58VBALNCTD vehicle balance check against tolerance table (TOIGS5)char10CHAR(N' ')YesOIG_VBALNC Allow NULL? 
59REAS_CODEReason code - to group quantities in shipment processnvarchar20CHAR(N' ')YesTOIGS4OIG_REASCD Allow NULL? 
60CHK_OVLTD check overloadingchar10CHAR(N' ')NoOIG_CHKOVL Allow NULL? 
61CRE_DATECreated Onnvarchar80DATS(N'00000000')YesERSDA Allow NULL? 
62CRE_NAMEName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
63CRE_TIMETime, at Which Record Was Addednvarchar60TIMS(N'000000')YesERZEIT Allow NULL? 
64CHA_DATEDate of Last Changenvarchar80DATS(N'00000000')YesLAEDA Allow NULL? 
65CHA_NAMEName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
66CHA_TIMETime of Changenvarchar60TIMS(N'000000')YesAEZEIT Allow NULL? 
67TPPOINTTransportation planning pointnvarchar40CHAR(N' ')YesTTDSTPLST Allow NULL? 
68FBSTAStatus of shipment costing vehicle levelchar10CHAR(N' ')YesOIG_VFBSTA Allow NULL? 
69FBGSTOverall status of shipment costing vehicle levelchar10CHAR(N' ')YesOIG_VFBGST Allow NULL? 
70ARSTAStatus of shipment cost settlement vehicle levelchar10CHAR(N' ')YesOIG_VARSTA Allow NULL? 
71ARGSTOverall status of shipment cost settlement vehicle levelchar10CHAR(N' ')YesOIG_VARGST Allow NULL? 
72SKALSMPricing procedure in vehicle of shipmentnvarchar60CHAR(N' ')YesT683OIG_KALSM_V Allow NULL? 
NamePrimaryUniqueTypeColumns
OIGSV~0YesYesCLUSTEREDVEH_NR, SHNUMBER, CLIENT

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