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  | OIJ_EL_CP_LAYT
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.0OIJ_EL_CP_LAYT761Charter party and laytime and demurrage agreementTraders and Schedulers Workbench
SQL:  selectupdate insert create

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

SELECT MANDT, VBELN, VBTYP, POSNR, VAL_FROM, VAL_TO, SINGLE_VOY, VEHICLE, VEH_TYPE, LD_START, LD_END, RD_START, RD_END, GRADES_NO, ROUTE, SPEED, MIN_SPEED, MAX_SPEED, SP_UOM, MIN_QUAN, QUAN_UOM, CAPACITY, CAP_UOM, TOL_MIN, TOL_MAX, PRESSURE, PRES_UOM, BUNKER_L, CL_UOM, CLT_UOM, BUNKER_B, ST_F_CONS, ST_D_CONS, FUEL_MG, DIES_MG, DECL, DECL_QU, LPA, DPA, CONS_PERC, WP_EVENT, LC_EVENT, LAY_TOTAL, DIS_TOTAL, LAY_UOM, LAY_QUAN, L_QU_UOM, LAY_MIN, LM_UOM, TIMEBAR, TB_UOM, TB_EVENT, COND_TYPE, DESP_CTYPE, FACT_TYPE, RATE_DATE, ERDAT, ERZEIT, ERNAM, AEDAT, AEZEIT, AENAM, BLOIND, DELIND, SERVTYPE, TRANTYP, PRIORITY, SHIPPER, TSYST, RLOCID, DLOCID, MDQ_QUAN, MDQ_UOM, MDQB, FUEL_PERC, FUELB FROM OIJ_EL_CP_LAYT
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2VBELNFreight contract numbernvarchar100CHAR(N' ')No*OIJ_EL_CPNO Allow NULL? 
3VBTYPTSW Details document typechar10CHAR(N' ')NoOIJ_EL_VBTYP Allow NULL? 
4POSNRContract item numbernvarchar60NUMC(N'000000')No*OIJ_EL_POSNR Allow NULL? 
5VAL_FROMValidity period start datenvarchar80DATS(N'00000000')YesOIJ_EL_VALF Allow NULL? 
6VAL_TOValidity period end datenvarchar80DATS(N'00000000')YesOIJ_EL_VALT Allow NULL? 
7SINGLE_VOYSingle voyage flagchar10CHAR(N' ')YesOIJ_EL_SV Allow NULL? 
8VEHICLETD Vehicle Numbernvarchar100CHAR(N' ')YesOIGVOIG_VHLNMR Allow NULL? 
9VEH_TYPETD vehicle typenvarchar40CHAR(N' ')YesTOIGVOIG_VHLTYP Allow NULL? 
10LD_STARTCharter laydays start datenvarchar80DATS(N'00000000')YesOIJ_EL_LDS Allow NULL? 
11LD_ENDCharter laydays end datenvarchar80DATS(N'00000000')YesOIJ_EL_LDE Allow NULL? 
12RD_STARTRedelivery time start datenvarchar80DATS(N'00000000')YesOIJ_EL_RDS Allow NULL? 
13RD_ENDRedelivery time end datenvarchar80DATS(N'00000000')YesOIJ_EL_RDE Allow NULL? 
14GRADES_NONumber of product gradesnvarchar20NUMC(N'00')YesOIJ_EL_GNO Allow NULL? 
15ROUTERoute agreed in charter contractnvarchar60CHAR(N' ')YesTVROOIJ_EL_ROUTE Allow NULL? 
16SPEEDCharter contract: base speed for voyagedecimal61QUAN((0))YesOIJ_EL_SPEED
17MIN_SPEEDCharter contract: Minimum speeddecimal61QUAN((0))YesOIJ_EL_MINSP
18MAX_SPEEDCharter contract: Maximum speeddecimal61QUAN((0))YesOIJ_EL_MAXSP
19SP_UOMSpeed unit of measurementnvarchar30UNIT(N' ')YesT006OIJ_EL_SPUOM Allow NULL? 
20MIN_QUANCharter contract: Minimum transport quantitydecimal133QUAN((0))YesOIJ_EL_MINQU
21QUAN_UOMUnit of measurement for quantitynvarchar30UNIT(N' ')YesT006OIJ_EL_QUUOM Allow NULL? 
22CAPACITYCharter contract: cargo sizedecimal133QUAN((0))YesOIJ_EL_CAP
23CAP_UOMUnit of measurement for capacitynvarchar30UNIT(N' ')YesT006OIJ_EL_CAPUOM Allow NULL? 
24TOL_MINCargo size tolerance - minimumdecimal31DEC((0))YesOIJ_EL_TMIN
25TOL_MAXCargo size tolerance - maximumdecimal31DEC((0))YesOIJ_EL_TMAX
26PRESSUREManifold pressuredecimal61QUAN((0))YesOIJ_EL_PRESS
27PRES_UOMUnit of measurement for pressurenvarchar30UNIT(N' ')YesT006OIJ_EL_PRUOM Allow NULL? 
28BUNKER_LBunker consumption ladendecimal133QUAN((0))YesOIJ_EL_BUL
29CL_UOMQuantity UoM for consumptionnvarchar30UNIT(N' ')YesT006OIJ_EL_CSUOM Allow NULL? 
30CLT_UOMTime UoM for consumptionnvarchar30UNIT(N' ')YesT006OIJ_EL_CLTUOM Allow NULL? 
31BUNKER_BBunker consumption under ballastdecimal133QUAN((0))YesOIJ_EL_BUB
32ST_F_CONSStandby bunker fuel consumptiondecimal133QUAN((0))YesOIJ_EL_STFC
33ST_D_CONSStandby bunker diesel consumptiondecimal133QUAN((0))YesOIJ_EL_STDC
34FUEL_MGBunker fuel material groupnvarchar90CHAR(N' ')YesT023OIJ_EL_BFUEL Allow NULL? 
35DIES_MGBunker diesel material groupnvarchar90CHAR(N' ')YesT023OIJ_EL_BDIES Allow NULL? 
36DECLDeclare flag: charterer or owner drivenchar10CHAR(N' ')YesOIJ_EL_DECL Allow NULL? 
37DECL_QUDeclare flag: charterers or owners optionchar10CHAR(N' ')YesOIJ_EL_DEQU Allow NULL? 
38LPAOwner's or charterer's load port agentchar10CHAR(N' ')YesOIJ_EL_LPA Allow NULL? 
39DPAOwner's or charterer's discharge port agentchar10CHAR(N' ')YesOIJ_EL_DPA Allow NULL? 
40CONS_PERCOIL-TSW: Bunker Consumption Percentage for a Transp. Systemdecimal42DEC((0))YesOIJ_CONS_PERC
41WP_EVENTWindow period eventnvarchar40CHAR(N' ')YesTOIGEOIJ_EL_WPEV Allow NULL? 
42LC_EVENTLightering commencement eventnvarchar40CHAR(N' ')YesTOIGEOIJ_EL_LCEV Allow NULL? 
43LAY_TOTALTotal allowed laytimedecimal30QUAN((0))YesOIJ_EL_LAYTT
44DIS_TOTALTotal allowed discharge laytimedecimal30QUAN((0))YesOIJ_EL_DIST
45LAY_UOMUnit of measurement for laytimenvarchar30UNIT(N' ')YesT006OIJ_EL_LAYTUOM Allow NULL? 
46LAY_QUANQuantity to which laytime is relateddecimal133QUAN((0))YesOIJ_EL_LAYQU
47L_QU_UOMUnit of measurement for quantitynvarchar30UNIT(N' ')YesT006OIJ_EL_QUUOM Allow NULL? 
48LAY_MINMinimum laytimedecimal30QUAN((0))YesOIJ_EL_LAYMIN
49LM_UOMUnit of measurement for laytimenvarchar30UNIT(N' ')YesT006OIJ_EL_LAYTUOM Allow NULL? 
50TIMEBARTimebar limitdecimal30QUAN((0))YesOIJ_EL_TB
51TB_UOMUnit of measurement for timebar limitnvarchar30UNIT(N' ')YesT006OIJ_EL_TBUOM Allow NULL? 
52TB_EVENTTimebar start eventnvarchar40CHAR(N' ')YesTOIGEOIJ_EL_TBEV Allow NULL? 
53COND_TYPEDemurrage rate condition typenvarchar40CHAR(N' ')YesT685OIJ_EL_DERA Allow NULL? 
54DESP_CTYPEDespatch rate condition typenvarchar40CHAR(N' ')YesT685OIJ_EL_DSRA Allow NULL? 
55FACT_TYPECalculation factor condition typenvarchar40CHAR(N' ')YesT685OIJ_EL_DEFA Allow NULL? 
56RATE_DATECondition rate date determinationnvarchar60CHAR(N' ')YesTOIJ_DET_DATEOIJ_EL_RADATE Allow NULL? 
57ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
58ERZEITTime of creationnvarchar60TIMS(N'000000')YesOI0_ERTIM Allow NULL? 
59ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
60AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
61AEZEITTime of day the record was changednvarchar60TIMS(N'000000')YesOI0_AETIM Allow NULL? 
62AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
63BLOINDBlocking indicatorchar10CHAR(N' ')YesOIJ_BLOIND Allow NULL? 
64DELINDDeletion indicatorchar10CHAR(N' ')YesOIJ_DELIND Allow NULL? 
65SERVTYPEField - Service Typenvarchar150CHAR(N' ')YesOIJ_SERVTYPE Allow NULL? 
66TRANTYPTransaction Typenvarchar50CHAR(N' ')YesOIJ_TRANTYP Allow NULL? 
67PRIORITYCapacitynvarchar50CHAR(N' ')YesOIJ_CAPACITY Allow NULL? 
68SHIPPERConnecting shippernvarchar100CHAR(N' ')Yes*OIJ_EL_CSH Allow NULL? 
69TSYSTTransport systemnvarchar100CHAR(N' ')Yes*OIJ_TSYST Allow NULL? 
70RLOCIDLocation IDnvarchar100CHAR(N' ')Yes*OIJ_LOCID Allow NULL? 
71DLOCIDLocation IDnvarchar100CHAR(N' ')Yes*OIJ_LOCID Allow NULL? 
72MDQ_QUANQuantity to which laytime is relateddecimal133QUAN((0))YesOIJ_EL_LAYQU
73MDQ_UOMUnit of measurement for quantitynvarchar30UNIT(N' ')YesT006OIJ_EL_QUUOM Allow NULL? 
74MDQBField - Maximum Daily Quantitychar10CHAR(N' ')YesOIJ_EL_MDQB Allow NULL? 
75FUEL_PERCOIL-TSW: Bunker Consumption Percentage for a Transp. Systemdecimal42DEC((0))YesOIJ_CONS_PERC
76FUELBFuel Basischar10CHAR(N' ')YesOIJ_EL_FUELB Allow NULL? 
NamePrimaryUniqueTypeColumns
OIJ_EL_CP_LAYT~0YesYesCLUSTEREDPOSNR, VBTYP, VBELN, 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