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  | OIJX
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)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data
Industry Specific :: Industry Solution Oil :: Downstream :: Traders and Schedulers Workbench
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0OIJX631TSW control recordTraders and Schedulers Workbench
SQL:  selectupdate insert create

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

SELECT MANDT, TSWACT, PLSQCH, ERDAT, ERZEIT, ERNAM, AEDAT, AEZEIT, AENAM, BLOIND, DELIND, CLSHIP, RDREAL, EXTDET, RDLOGIC, RDFCL, RDPAST, RDNOMDAT, RDDISAG, SCHEDREL, LOCCONTROL, NOMICU, NOMHCU, MMOTCHK, LOCMATCU, TSMATCU, TSWDCHK, EXDETMOT, NOMDATCHK, PLLOCFLAG, RDPLMICO, RDMULT, RDDECS, RDPHYS, RDSTART, HEEL, RDAUTOWL, RDREP, CONSIDER_ROUTE, RDTREE, SPFLTVAL, SPDOCWHIF, ETA_EV_TYPE, PS_SITYP_DMD, PS_DOCIND_DMD, PS_SITYP_SUP, PS_DOCIND_SUP, BFDEPTH, START_SEQ, INCRE_SEQ, PRF_GRUPPE, PRF_NAME, PRF_INDEX, AMEND_MIN_QTY, AMEND_MIN_QTY_U, LB_ROUTE_CHK_OBJ, LB_ROUTE_PUB, DOCCO, SPAUTOFC, UPD_REFDOC, GTS, METER_RECON_FLAG, LATELCK_3WP FROM OIJX
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2TSWACTOIL-TSW: TSW is activechar10CHAR(N' ')YesOIJ_TSWACT Allow NULL? 
3PLSQCHTSW: Flag to indicate changes in planning rel. datachar10CHAR(N' ')YesOIJ_PLSQCH Allow NULL? 
4ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
5ERZEITTime of creationnvarchar60TIMS(N'000000')YesOI0_ERTIM Allow NULL? 
6ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
7AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
8AEZEITTime of day the record was changednvarchar60TIMS(N'000000')YesOI0_AETIM Allow NULL? 
9AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
10BLOINDBlocking indicatorchar10CHAR(N' ')YesOIJ_BLOIND Allow NULL? 
11DELINDDeletion indicatorchar10CHAR(N' ')YesOIJ_DELIND Allow NULL? 
12CLSHIPOIL TSW : Automatically close shipment flagchar10CHAR(N' ')YesOIJ_CLSHIP Allow NULL? 
13RDREALReal-time Stock Projection indicatorchar10CHAR(N' ')YesOIJ_REALTIME Allow NULL? 
14EXTDETExternal Detailschar10CHAR(N' ')YesOIJ_EXTDET Allow NULL? 
15RDLOGICStock Projection calculation logic identifierchar10CHAR(N' ')YesOIJ_RDLOGIC Allow NULL? 
16RDFCLOIL-TSW: Corrective Rack forecast issue logic indicatorchar10CHAR(N' ')YesOIJ_RDFCL Allow NULL? 
17RDPASTStock Projection Worksheet past days' inventory indicatorchar10CHAR(N' ')YesOIJ_RDPAST Allow NULL? 
18RDNOMDATNomination Stock Projection date indicatorchar10CHAR(N' ')YesOIJ_RDNOMDAT Allow NULL? 
19RDDISAGStock Projection disaggregation specifierchar10CHAR(N' ')YesOIJ_RDDISAG Allow NULL? 
20SCHEDRELOIL-TSW: Scheduling relevance check flagchar10CHAR(N' ')YesOIJ_SCHEDREL Allow NULL? 
21LOCCONTROLOIL-TSW: Scheduling TSW Details location check flagchar10CHAR(N' ')YesOIJ_LOCCONTROL Allow NULL? 
22NOMICUOIL-TSW: Nomination item additional fields pop-up activationchar10CHAR(N' ')YesOIJ_NOMICU Allow NULL? 
23NOMHCUOIL-TSW: Nomination header add. fields pop-up activationchar10CHAR(N' ')YesOIJ_NOMHCU Allow NULL? 
24MMOTCHKOIL-TSW: Scheduling multiple MOT checkchar10CHAR(N' ')YesOIJ_MMOTCHK Allow NULL? 
25LOCMATCUOIL-TSW: Location/material add. fields screen activationchar10CHAR(N' ')YesOIJ_LOCMATCU Allow NULL? 
26TSMATCUOIL-TSW: TransportSys/material add. fields screen activationchar10CHAR(N' ')YesOIJ_TSMATCU Allow NULL? 
27TSWDCHKTSW check in SD / MM document transactionschar10CHAR(N' ')YesOIJ_TSWDCHK Allow NULL? 
28EXDETMOTTransfer external details MoT to TSW multiple MoTschar10CHAR(N' ')YesOIJ_EXDETMOT Allow NULL? 
29NOMDATCHKCheck scheduled date against the TSW Details date rangechar10CHAR(N' ')YesOIJ_NOMDATCHK Allow NULL? 
30PLLOCFLAGOIL TSW: Location valid on all assigned planning locationschar10CHAR(N' ')YesOIJ_PLANFLAG Allow NULL? 
31RDPLMICOPlus/minus combined in the SPWchar10CHAR(N' ')YesOIJ_RDPLMICO Allow NULL? 
32RDMULTAll 'Multiple' items in the SPW drilled down/upchar10CHAR(N' ')YesOIJ_RDMULT Allow NULL? 
33RDDECSNumber of decimals in the SPWchar10NUMC(N'0')YesOIJ_RDDECS Allow NULL? 
34RDPHYSOIL-TSW: Physical inventory in both columnschar10CHAR(N' ')YesOIJ_RDPHYS Allow NULL? 
35RDSTARTStock Projection start day flagchar10CHAR(N' ')YesOIJ_RDSTART Allow NULL? 
36HEELHeel field namenvarchar300CHAR(N' ')YesOIJ_HEEL Allow NULL? 
37RDAUTOWLGenerate Stock Projection worklist automaticallychar10CHAR(N' ')YesOIJ_RDAUTOWL Allow NULL? 
38RDREPUse 'Report into inventory' functionalitychar10CHAR(N' ')YesOIJ_RDREP Allow NULL? 
39CONSIDER_ROUTEConsider Routechar10CHAR(N' ')YesOIJ_CONS_ROUTE Allow NULL? 
40RDTREEStock Projection object selection is based on ALV treechar10CHAR(N' ')YesOIJ_RDTREE Allow NULL? 
41SPFLTVALStock projection filter value for BADInvarchar60CHAR(N' ')YesOIJ_SP_FLTVALOIJ_SPFLTVAL Allow NULL? 
42SPDOCWHIFIndicator: Ability to view/maintain documents in what-if popchar10CHAR(N' ')YesOIJ_SPDOCWHIF Allow NULL? 
43ETA_EV_TYPEEvent Type for ETAnvarchar40CHAR(N' ')YesTOIGEOIJ_ETA_EV_TYPE Allow NULL? 
44PS_SITYP_DMDDefault Schedule type for Pegging to Stock of Demand Itemsnvarchar20CHAR(N' ')YesTOIJ_EL_SITYPESOIJ_PS_SITYP Allow NULL? 
45PS_DOCIND_DMDReference document indicator for Pegging to Stock of Demandchar10CHAR(N' ')YesOIJ_PS_DOCIND Allow NULL? 
46PS_SITYP_SUPDefault Schedule type for Pegging to Stock of Supply Availsnvarchar20CHAR(N' ')YesTOIJ_EL_SITYPESOIJ_PS_SITYP_SUP Allow NULL? 
47PS_DOCIND_SUPReference document indicator for Pegging to Stock of Supplychar10CHAR(N' ')YesOIJ_PS_DOCIND_SUP Allow NULL? 
48BFDEPTHBifurcation Depthtinyint30INT1((0))YesOIJ_BFDEPTH
49START_SEQStart of Sequence Numbernvarchar50NUMC(N'00000')YesOIJ_SESTART Allow NULL? 
50INCRE_SEQIncrement of Sequence Numbernvarchar50NUMC(N'00000')YesOIJ_SEINCRE Allow NULL? 
51PRF_GRUPPEProfile group (sort graphics profiles)nvarchar40CHAR(N' ')YesTBCGBCPRFGROUP Allow NULL? 
52PRF_NAMEName of graphics profilenvarchar120CHAR(N' ')YesTBCGBCPRFNAME Allow NULL? 
53PRF_INDEXProfile index for the graphics profilechar10CHAR(N' ')YesTBCGBCPRFINDEX Allow NULL? 
54AMEND_MIN_QTYAmendment quantity minimumdecimal133QUAN((0))YesOIJ_AMEND_MIN_QTY
55AMEND_MIN_QTY_UAmendment minimum quantity UOMnvarchar30UNIT(N' ')YesT006OIJ_AMEND_MIN_QTY_U Allow NULL? 
56LB_ROUTE_CHK_OBJLB Route check objects (Location / Transport system)nvarchar20CHAR(N' ')YesOIJ_LB_ROUTE_CHK_OBJ Allow NULL? 
57LB_ROUTE_PUBLB Publish with / without routechar10CHAR(N' ')YesOIJ_LB_ROUTE_PUB Allow NULL? 
58DOCCODocuments in TSW-SPW Are Consumed by Goods Movementschar10CHAR(N' ')YesOIJ_DOCCO Allow NULL? 
59SPAUTOFCGenerate Rack Forecast Automatically in Stock Projectionchar10CHAR(N' ')YesOIJ_SPAUTOFC Allow NULL? 
60UPD_REFDOCReference Document Updatechar10CHAR(N' ')YesOIJ_UPD_SCHED_IND Allow NULL? 
61GTSCheck on GTS (Global Trade Services) valid partnerschar10CHAR(N' ')YesOIJ_GTS Allow NULL? 
62METER_RECON_FLAGTSW-TD meter reconciliation flagchar10CHAR(N' ')YesOIJ_METER_RECON_FLAG Allow NULL? 
63LATELCK_3WP3WP LOCK STRATEGYchar10CHAR(N' ')YesOIJ_3WP_LOCKSTRATEGY Allow NULL? 
NamePrimaryUniqueTypeColumns
OIJX~0YesYesCLUSTEREDMANDT

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