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_SCHED
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_SCHED1545Planned Schedule LinesTraders and Schedulers Workbench
SQL:  selectupdate insert create

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

SELECT MANDT, SIM_SCHED_ID, SIM_SCHED_LN, SIM_VERSION, SIM_SCHED_TYP, SCHED_STAT, SCHED_ACF, NOMTK, NOMIT, SCHED_COMM, NOMCL, NOMTYP, BUSTYP, NOMNR, NOMST, NMSHTYPE, NMBALCH, STAGES_ID, WORKLIST, SENTDAT, SENTTIME, SENTNAM, ITEMS, COUNTER1, COUNTER2, COUNTER3, COUNTER4, COUNTER5, COUNTER6, APO_SHIPMENT_ID, APO_SHIPMENT_NUM, NMBLOCK, NOMTYPDESC, SHTYP, TKNUM, LOV_GL, TSYST, NMSHIPPER, NMCARRIER, CYCLE, NMWERK, NMLGORT, NMVEHICLE, NMVESSEL, NMTPLST, ROUTE, BOOKTS, EV_GROUP, VKTRA, QTYIN, QTYOUT, UNIT, TST_FROM_MIN, TST_TO_MAX, 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, ERDAT, ERZEIT, ERNAM, AEDAT, AEZEIT, AENAM, FLTTNOMTK FROM OIJ_SCHED
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SIM_SCHED_IDTSW: Nomination Simulation IDnvarchar200CHAR(N' ')No*OIJ_SIMID Allow NULL? 
3SIM_SCHED_LNTSW: Nomination Simulation Line itemnvarchar100NUMC(N'0000000000')NoOIJ_SIMLN Allow NULL? 
4SIM_VERSIONTSW: Simulation Versionnvarchar30NUMC(N'000')NoOIJ_SIMVERS Allow NULL? 
5SIM_SCHED_TYPSimulation Schedule categorynvarchar20CHAR(N' ')YesOIJ_SIM_SCHED_TYP Allow NULL? 
6SCHED_STATTSW: Status of Simulated Schedule linechar10CHAR(N' ')YesOIJ_SIMSTAT Allow NULL? 
7SCHED_ACFTSW: Flag for automatically created entrieschar10CHAR(N' ')YesOIJ_SIM_AUTO_CREATE Allow NULL? 
8NOMTKNomination (technical) Keynvarchar200CHAR(N' ')Yes*OIJ_NOMTK Allow NULL? 
9NOMITNomination Key Itemnvarchar100NUMC(N'0000000000')Yes*OIJ_ITEM Allow NULL? 
10SCHED_COMMShort commentnvarchar800CHAR(N' ')YesOIJ_SIM_SC Allow NULL? 
11NOMCLNomination Classnvarchar20CHAR(N' ')YesOIJ_NOMCL Allow NULL? 
12NOMTYPNomination typenvarchar40CHAR(N' ')YesTOIJNOMTYPOIJ_NOMTYP Allow NULL? 
13BUSTYPBusiness typenvarchar40CHAR(N' ')YesOIRARNBTOIRA_RNBT Allow NULL? 
14NOMNRNomination numbernvarchar200CHAR(N' ')YesOIJ_NOMNR Allow NULL? 
15NOMSTNomination header statuschar10CHAR(N' ')Yes*OIJ_NOMST Allow NULL? 
16NMSHTYPETD shipment typenvarchar40CHAR(N' ')YesTOIGSOIG_TDSTYP Allow NULL? 
17NMBALCHBalance check indicator (default)char10CHAR(N' ')YesOIJ_BALCH Allow NULL? 
18STAGES_IDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220CHAR(N' ')YesGUID_22 Allow NULL? 
19WORKLISTWorklist entry indicatorchar10CHAR(N' ')YesOIJ_WORKLT Allow NULL? 
20SENTDATLast header action datenvarchar80DATS(N'00000000')YesOIJ_SENDAT Allow NULL? 
21SENTTIMELast header action timenvarchar60TIMS(N'000000')YesOIJ_SENTIM Allow NULL? 
22SENTNAMLast user who worked on objectnvarchar120CHAR(N' ')YesOIJ_SENNAM Allow NULL? 
23ITEMSNomination item counternvarchar40NUMC(N'0000')YesOIJ_ITEMCOUNTER Allow NULL? 
24COUNTER1Nomination planned item Counternvarchar40NUMC(N'0000')YesOIJ_PLANNEDITEMS Allow NULL? 
25COUNTER2Nomination scheduled Item Counternvarchar40NUMC(N'0000')YesOIJ_SCHEDULEDITEMS Allow NULL? 
26COUNTER3Nomination rejected Item Counternvarchar40NUMC(N'0000')YesOIJ_REJECTEDITEMS Allow NULL? 
27COUNTER4Nomination confirmed Item Counternvarchar40NUMC(N'0000')YesOIJ_CONFIRMEDITEMS Allow NULL? 
28COUNTER5Nomination partially complete Item Counternvarchar40NUMC(N'0000')YesOIJ_PARTCOMPLETEITEMS Allow NULL? 
29COUNTER6Nomination completed Item Counternvarchar40NUMC(N'0000')YesOIJ_COMPLETEDITEMS Allow NULL? 
30APO_SHIPMENT_IDGUID in 'CHAR' format with upper-/lowercase (!)nvarchar220CHAR(N' ')YesGUID_22 Allow NULL? 
31APO_SHIPMENT_NUMShipment Numbernvarchar100CHAR(N' ')Yes*TKNUM Allow NULL? 
32NMBLOCKBlocking indicatorchar10CHAR(N' ')YesOIJ_BLOIND Allow NULL? 
33NOMTYPDESCIS-Oil: Descriptive textnvarchar360CHAR(N' ')YesOI0_TEXT Allow NULL? 
34SHTYPShipment typenvarchar40CHAR(N' ')YesTVTKSHTYP Allow NULL? 
35TKNUMShipment Numbernvarchar100CHAR(N' ')YesVTTKTKNUM Allow NULL? 
36LOV_GLGain Loss LOV posting indicatorchar10CHAR(N' ')YesOIJ03_GLLOVPOST Allow NULL? 
37TSYSTTransport systemnvarchar100CHAR(N' ')YesOIJTSOIJ_TSYST Allow NULL? 
38NMSHIPPERShippernvarchar100CHAR(N' ')YesLFA1OIJ_SHIPNR Allow NULL? 
39NMCARRIERTransport system Carriernvarchar100CHAR(N' ')YesLFA1OIJ_CARRNR Allow NULL? 
40CYCLENomination Pipeline cycle IDnvarchar100CHAR(N' ')YesOIJ_CYCLE Allow NULL? 
41NMWERKTransport system In-transit Plantnvarchar40CHAR(N' ')YesT001WOIJ_WERK Allow NULL? 
42NMLGORTTransport system In-transit Storage Locationnvarchar40CHAR(N' ')YesT001LOIJ_LGORT Allow NULL? 
43NMVEHICLETD Vehicle Numbernvarchar100CHAR(N' ')YesOIGVOIG_VHLNMR Allow NULL? 
44NMVESSELTD vehicle identifiernvarchar180CHAR(N' ')YesOIG_VEHID Allow NULL? 
45NMTPLSTTransportation planning pointnvarchar40CHAR(N' ')YesTTDSTPLST Allow NULL? 
46ROUTERoutenvarchar60CHAR(N' ')YesTVROROUTE Allow NULL? 
47BOOKTSBook TS indicatorchar10CHAR(N' ')YesOIJ_BOOKTS Allow NULL? 
48EV_GROUPTD - event default groupnvarchar40CHAR(N' ')YesOIG_EVGRP Allow NULL? 
49VKTRAMode of transportnvarchar20CHAR(N' ')YesTVTRVKTRA Allow NULL? 
50QTYINQty received in TSdecimal133QUAN((0))YesOIJ_QTYIN
51QTYOUTQty delivered from TSdecimal133QUAN((0))YesOIJ_QTYOUT
52UNITNomination(pipe) UoMnvarchar30UNIT(N' ')Yes*OIJ_NMUNIT Allow NULL? 
53TST_FROM_MINScheduled / Acceptance / Pipe Batch Start Timestampdecimal150DEC((0))YesOIJ_SCHED_F
54TST_TO_MAXScheduled / Acceptance / Pipe Batch End Timestampdecimal150DEC((0))YesOIJ_SCHED_T
55SITYPSchedule typenvarchar20CHAR(N' ')YesTOIJ_EL_SITYPESOIJ_SITYP Allow NULL? 
56ISTATNomination Item statuschar10CHAR(N' ')YesOIJSTATOIJ_ISTAT Allow NULL? 
57ISUBSTATNomination Item sub-statuschar10CHAR(N' ')YesOIJSUBSTATOIJ_SSTAT Allow NULL? 
58IDATEScheduled datenvarchar80DATS(N'00000000')YesOIJ_IDATE Allow NULL? 
59SCHED_TST_FROMScheduled / Acceptance / Pipe Batch Start Timestampdecimal150DEC((0))YesOIJ_SCHED_F
60SCHED_TST_TOScheduled / Acceptance / Pipe Batch End Timestampdecimal150DEC((0))YesOIJ_SCHED_T
61LOCIDLocation IDnvarchar100CHAR(N' ')YesOIJLOCOIJ_LOCID Allow NULL? 
62S_MATNR_IScheduled materialnvarchar180CHAR(N' ')YesMARAOIJ_SMATNR Allow NULL? 
63MATNR_IDemand materialnvarchar180CHAR(N' ')YesMARAOIJ_MATNRI Allow NULL? 
64MENGEScheduled qtydecimal133QUAN((0))YesOIJ_MENGE
65UNIT_IScheduled UoMnvarchar30UNIT(N' ')YesT006OIJ_UNITI Allow NULL? 
66UNIT_I_TScheduled UoM Timenvarchar30UNIT(N' ')Yes*OIJ_UNITI_T Allow NULL? 
67DOCINDReference document indicator (PSX)char10CHAR(N' ')YesOIJ_DOCIND Allow NULL? 
68DOCNRNomination Reference Documentnvarchar100CHAR(N' ')YesOIJ_DOCNR Allow NULL? 
69DOCITMNomination Reference Document Itemnvarchar60NUMC(N'000000')YesOIJ_DOCITM Allow NULL? 
70DOCSCHEDLNNomination Reference Document Schedule linenvarchar40NUMC(N'0000')Yes*OIJ_DOCSCHEDLN Allow NULL? 
71QTYFCRFirst requested quantitydecimal133QUAN((0))YesOIJ_QTYFCR
72QTYFCR_UOMFirst Requested Quantity UoMnvarchar30UNIT(N' ')Yes*OIJ_QTYFCR_UOM Allow NULL? 
73WORKLIST_IWorklist entry indicatorchar10CHAR(N' ')YesOIJ_WORKLT Allow NULL? 
74TANKTankage Partnernvarchar100CHAR(N' ')YesOIJ_TANKAGE Allow NULL? 
75CONSConsignee Partnernvarchar100CHAR(N' ')YesOIJ_CONSIGNEE Allow NULL? 
76PARTNRLocation Partnernvarchar100CHAR(N' ')YesOIJ_PARTNR Allow NULL? 
77CONPATContract Partnernvarchar100CHAR(N' ')YesOIJ_CONPAT Allow NULL? 
78INSPEInspectornvarchar100CHAR(N' ')YesOIJ_INSPECTOR Allow NULL? 
79IMPOEXPOImport / Export Partnernvarchar100CHAR(N' ')YesLFA1OIJ_IMEXPO Allow NULL? 
80FLAG_IMEXImport / Export Partner Indicatornvarchar20CHAR(N' ')YesOIJIMEXOIJ_IMEXFL Allow NULL? 
81OWNERValuation Typenvarchar100CHAR(N' ')YesT149DBWTAR_D Allow NULL? 
82CHARG_OBatch origin Locationnvarchar100CHAR(N' ')Yes*OIJ_CHARGO Allow NULL? 
83CHARG_DBatch destination Locationnvarchar100CHAR(N' ')Yes*OIJ_CHARGD Allow NULL? 
84RVPRVP valuedecimal41DEC((0))YesOIJ_RVP
85VALUATIONTYPE_OValuation Type Origin Loc.nvarchar100CHAR(N' ')YesT149DOIJ_BWTAR_O Allow NULL? 
86VALUATIONTYPE_DValuation Type Destination Loc.nvarchar100CHAR(N' ')YesT149DOIJ_BWTAR_D Allow NULL? 
87SHNUMTD shipment numbernvarchar100CHAR(N' ')YesOIGSOIG_SHNUM Allow NULL? 
88SHITEMShipment itemnvarchar40NUMC(N'0000')YesOIGSIOIG_SHITM Allow NULL? 
89ILOCKNomination item complete flagchar10CHAR(N' ')YesOIJ_ILOCK Allow NULL? 
90PRORATEQTYProrated Quantitydecimal133QUAN((0))YesOIJ_PRRA_QTY
91ASSIGNEDQTYAssigned Quantitydecimal133QUAN((0))YesOIJ_ASSG_QTY
92ACTDATLast item action datenvarchar80DATS(N'00000000')YesOIJ_ACTDAT Allow NULL? 
93ACTTIMELast item action timenvarchar60TIMS(N'000000')YesOIJ_ACTIME Allow NULL? 
94ACTUALSNomination item partially completechar10CHAR(N' ')YesOIJ_ACTUAL Allow NULL? 
95ACTUALQTYActual posted quantitydecimal133QUAN((0))YesOIJ_ACTQTY
96ACTUALUOMActual posted quantity Unit of Measurenvarchar30UNIT(N' ')YesT006OIJ_ACTUOM Allow NULL? 
97ITBOTOLQuantity tolerance over (percentage)decimal41DEC((0))YesOIJ_BOTOL
98ITBUTOLQuantity tolerance under (%)decimal41DEC((0))YesOIJ_BUTOL
99ITBOTOLABSAbsolute tolerance qty overdecimal133QUAN((0))YesOIJ_TOLABO
100ITBUTOLABSAbsolute tolerance qty underdecimal133QUAN((0))YesOIJ_TOLABS
101ITTOLUNITAbsolute tolerance UoMnvarchar30UNIT(N' ')YesT006OIJ_TOLUOM Allow NULL? 
102UNLIMITEDIndicator: Unlimited Overdelivery Allowedchar10CHAR(N' ')YesUEBTK Allow NULL? 
103BLOINDBlocking indicatorchar10CHAR(N' ')YesOIJ_BLOIND Allow NULL? 
104DELINDDeletion indicatorchar10CHAR(N' ')YesOIJ_DELIND Allow NULL? 
105UPDATEXDOKUpdate external details failure flagchar10CHAR(N' ')YesOIJ_EXDOK Allow NULL? 
106INCOMPLETE_FLAGIncompletion Flagchar10CHAR(N' ')YesOIJ_INCOMPLETE_FLAG Allow NULL? 
107DOCTYPReference Document Typenvarchar40CHAR(N' ')YesOIJ_DOCTYP Allow NULL? 
108LDRATEPlanned load/discharge ratedecimal133QUAN((0))YesOIJ_EL_LDRATE
109LDQUOMPlanned load/discharge rate quantity UoMnvarchar30UNIT(N' ')Yes*OIJ_EL_LDQUOM Allow NULL? 
110LDTUOMPlanned load/discharge rate time UOMnvarchar30UNIT(N' ')Yes*OIJ_EL_LDTUOM Allow NULL? 
111THIRD_NOMNRPartner Nomination numbernvarchar200CHAR(N' ')YesOIJ_3RD_NOMNR Allow NULL? 
112UPMATPricing reference material of main itemnvarchar180CHAR(N' ')Yes*UPMAT Allow NULL? 
113REFITEMHigher-level item in bill of material structuresnvarchar100NUMC(N'0000000000')Yes*OIJ_REF_BOM_ITEM Allow NULL? 
114STLTYBOM categorychar10CHAR(N' ')YesSTLTY Allow NULL? 
115STLKNBOM item node numbernvarchar80NUMC(N'00000000')YesSTLKN Allow NULL? 
116CHARG_D_CREATEDestination Batch create new flagchar10CHAR(N' ')YesOIJ_CHARG_D_C Allow NULL? 
117CHARG_O_CREATEOrigin Batch create new flagchar10CHAR(N' ')YesOIJ_CHARG_O_C Allow NULL? 
118CO_CARRConnecting carriernvarchar100CHAR(N' ')Yes*OIJ_EL_CCA Allow NULL? 
119CO_SHIPConnecting shippernvarchar100CHAR(N' ')Yes*OIJ_EL_CSH Allow NULL? 
120CO_TSYSTConnecting Transport Systemnvarchar100CHAR(N' ')Yes*OIJ_EL_CTSYST Allow NULL? 
121COMMCTLNomination Communication Controlnvarchar20CHAR(N' ')YesOIJ_NOMCOMM Allow NULL? 
122SOLDTOCustomer Sold-to or Vendornvarchar100CHAR(N' ')YesOIJ_SOLDTO Allow NULL? 
123PRORATE_ROUTINEProrate Calculation Routine Typenvarchar60CHAR(N' ')YesTOIJ_EL_PR_RTOIJ_EL_DE_PR_RT Allow NULL? 
124CHARG_LBatch loadnvarchar100CHAR(N' ')Yes*OIJ_CHARGL Allow NULL? 
125CHARG_L_CREATELoad Batch create new flagchar10CHAR(N' ')YesOIJ_CHARG_L_C Allow NULL? 
126TCNUMTSW :Trading Contract numbernvarchar100CHAR(N' ')YesOIJ_TCNR Allow NULL? 
127TCITMTSW: Trading contract item numbernvarchar60NUMC(N'000000')YesOIJ_TCITM Allow NULL? 
128GA_NMSHIPPERShippernvarchar100CHAR(N' ')Yes*OIJ_SHIPNR Allow NULL? 
129GA_CONF_QTYConfirmed Quantitydecimal133QUAN((0))YesOIJ_CONFQTY
130GA_CONF_UOMUnit of Measure for Confirmed Quantity Fieldnvarchar30UNIT(N' ')Yes*OIJ_CONFUOM Allow NULL? 
131GA_TECHSCH_QTYTechnical Scheduled Quantity Fielddecimal133QUAN((0))YesOIJ_TECHSCHQTY
132GA_TECHSCH_UOMUnit of Measure for Technical Scheduled Quantity Fieldnvarchar30UNIT(N' ')Yes*OIJ_TECHSCHUOM Allow NULL? 
133GA_CONF_QTY_CALCalculated Values of Confirmed Quantity Fielddecimal133QUAN((0))YesOIJ_CONFQTY_CAL
134GA_TSCH_QTY_CALCalculated Values of Technical Scheduled Quantity Fielddecimal133QUAN((0))YesOIJ_TECHSCH_QTY_CAL
135GA_ALLOCATED_QTYAllocated Quantitydecimal133QUAN((0))YesOIJ_ALLOCATED_QTY
136GA_ALLOCATED_UOMUnit of Measure for Allocated Quantity Fieldnvarchar30UNIT(N' ')Yes*OIJ_ALLOCATED_UOM Allow NULL? 
137GA_RANKRanktinyint30INT1((0))YesOIJ_RANK
138CYCLE_ITEMNomination Pipeline cycle ID at Item Levelnvarchar100CHAR(N' ')YesOIJ_ITEMCYCLE Allow NULL? 
139LESSHNUMShipment Numbernvarchar100CHAR(N' ')YesVTTKTKNUM Allow NULL? 
140LESTPNUMShipment itemnvarchar40NUMC(N'0000')YesVTTPTPNUM Allow NULL? 
141ATL_DELV_NUMBERATL credit check delivery numbernvarchar100CHAR(N' ')Yes*OIJ_ATL_DELV Allow NULL? 
142ATL_DELV_ITMATL credit check delivery itemnvarchar60NUMC(N'000000')Yes*OIJ_ATL_DELV_ITM Allow NULL? 
143ATL_CRDT_QTYATL Credit Quantitydecimal133QUAN((0))YesOIJ_ATL_CREDIT_QTY
144ATL_CRDT_UOMBase Unit of Measurenvarchar30UNIT(N' ')Yes*MEINS Allow NULL? 
145ATL_CRDT_VALATL Credit Amountdecimal152CURR((0))YesOIJ_ATL_CREDIT_AMT
146ATL_CRDT_CURRATL Credit Currencynvarchar50CUKY(N' ')Yes*OIJ_ATL_CREDIT_CURR Allow NULL? 
147PRE_EXIST_INDATL Preexisting Delivery Indicatorchar10CHAR(N' ')YesOIJ_ATL_PREEXIST_IND Allow NULL? 
148ERDATDate on Which Record Was Creatednvarchar80DATS(N'00000000')YesERDAT Allow NULL? 
149ERZEITTime of creationnvarchar60TIMS(N'000000')YesOI0_ERTIM Allow NULL? 
150ERNAMName of Person who Created the Objectnvarchar120CHAR(N' ')YesERNAM Allow NULL? 
151AEDATChanged Onnvarchar80DATS(N'00000000')YesAEDAT Allow NULL? 
152AEZEITTime of day the record was changednvarchar60TIMS(N'000000')YesOI0_AETIM Allow NULL? 
153AENAMName of Person Who Changed Objectnvarchar120CHAR(N' ')YesAENAM Allow NULL? 
154FLTTNOMTKNomination (technical) Keynvarchar200CHAR(N' ')Yes*OIJ_NOMTK Allow NULL? 
NamePrimaryUniqueTypeColumns
OIJ_SCHED~0YesYesCLUSTEREDSIM_VERSION, SIM_SCHED_LN, SIM_SCHED_ID, MANDT
OIJ_SCHED~LOCNoNoNONCLUSTEREDSCHED_TST_FROM, SIM_SCHED_TYP, S_MATNR_I, LOCID, MANDT
OIJ_SCHED~NM1NoNoNONCLUSTEREDNOMTK, MANDT
OIJ_SCHED~RD1NoNoNONCLUSTEREDDOCITM, DOCNR, MANDT
OIJ_SCHED~SMANoNoNONCLUSTEREDSCHED_TST_FROM, SIM_SCHED_TYP, S_MATNR_I, 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