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  | ORF5CUST
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 :: Aerospace Defence Industry Solution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ORF5CUST561Customising Profils for Optimal Rotable Float ORF5,6Aerospace Defence Industry Solution
SQL:  selectupdate insert create

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

SELECT MANDT, PROFL_ID, TC_Q1, TC_Q2, TC_DEF, MTBE_Q1, MTBE_Q2, MTBE_DEF_OH, MTBE_DEF_LC, MTBE_DEF_OC, TAT_REP_Q1, TAT_REP_Q2, TAT_REP_DEF, TAT_TRP_Q1, TAT_TRP_Q2, TAT_TRP_DEF, EC_Q1, EC_Q2, EC_DEF, HS_Q1, HS_Q2, HS_DEF, PRICE_Q1, PRICE_Q2, PRICE_DEF, CURR_DEF, NFL_Q1, NFL_Q2, NFL_DEF, NEQ_Q1, NEQ_Q2, NEQ_DEF, TAU_Q1, TAU_Q2, TAU_DEF_OH, TAU_DEF_LC, TAU_DEF_OC, DD_DEF, SAVE_TYPE, CALC_TYPE2, ROT_EXP_TYPE, MAD_TYPE, BATCH_DUM1, BATCH_DUM2, BATCH_DUM3, SUPPL1, WERKS, BWTAR, FLAG_NUM_BATCH, IP_MATNR_ASSIGN, DUMMY1, DUMMY2, DUMMY3, DUMMY4, DUMMY5, DUMMY6 FROM ORF5CUST
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2PROFL_IDCustomizing Profile for Single Item Stock Calculationnvarchar60CHAR(N' ')NoPROFL1_NAME Allow NULL? 
3TC_Q1Source for Operation Time Unitnvarchar20CHAR(N' ')YesTC_Q1 Allow NULL? 
4TC_Q2Source for Operation Time Unitnvarchar20CHAR(N' ')YesTC_Q1 Allow NULL? 
5TC_DEFTime Cycle Code for URRchar10CHAR(N' ')YesADSPC_URRTCC Allow NULL? 
6MTBE_Q1Source for MTBEnvarchar20CHAR(N' ')YesMTBE_Q1 Allow NULL? 
7MTBE_Q2Source for MTBEnvarchar20CHAR(N' ')YesMTBE_Q1 Allow NULL? 
8MTBE_DEF_OHDefault Value for MTBEdecimal166DEC((0))YesMTBE_DEF
9MTBE_DEF_LCDefault Value for MTBEdecimal166DEC((0))YesMTBE_DEF
10MTBE_DEF_OCDefault Value for MTBEdecimal166DEC((0))YesMTBE_DEF
11TAT_REP_Q1Source for Repair Time / Provision Periodnvarchar20CHAR(N' ')YesTAT_REP_Q1 Allow NULL? 
12TAT_REP_Q2Source for Repair Time / Provision Periodnvarchar20CHAR(N' ')YesTAT_REP_Q1 Allow NULL? 
13TAT_REP_DEFDefault Value for Repair Time / Provision Perioddecimal166DEC((0))YesTAT_REP_DEF
14TAT_TRP_Q1Source for Transport Timenvarchar20CHAR(N' ')YesTAT_TRP_Q2 Allow NULL? 
15TAT_TRP_Q2Source for Transport Timenvarchar20CHAR(N' ')YesTAT_TRP_Q2 Allow NULL? 
16TAT_TRP_DEFDefault Value for Transport Timedecimal166DEC((0))YesTAT_TRP_DEF
17EC_Q1Source for Essentiality Codenvarchar20CHAR(N' ')YesEC_Q1 Allow NULL? 
18EC_Q2Source for Essentiality Codenvarchar20CHAR(N' ')YesEC_Q1 Allow NULL? 
19EC_DEFEssentiality Codechar10NUMC(N'0')YesEC_DEF Allow NULL? 
20HS_Q1Source for Workshopnvarchar20CHAR(N' ')YesHS_Q1 Allow NULL? 
21HS_Q2Source for Workshopnvarchar20CHAR(N' ')YesHS_Q1 Allow NULL? 
22HS_DEFDefault Value for Workshopnvarchar30CHAR(N' ')YesT024LHS_DEF Allow NULL? 
23PRICE_Q1Source for Pricenvarchar20CHAR(N' ')YesPRICE_Q1 Allow NULL? 
24PRICE_Q2Source for Pricenvarchar20CHAR(N' ')YesPRICE_Q1 Allow NULL? 
25PRICE_DEFDefault Value for Pricedecimal112CURR((0))YesPRICE_DEF
26CURR_DEFCurrency Keynvarchar50CUKY(N' ')YesTCURCWAERS Allow NULL? 
27NFL_Q1Source for Number of Aircraftnvarchar20CHAR(N' ')YesNFL_Q1 Allow NULL? 
28NFL_Q2Source for Number of Aircraftnvarchar20CHAR(N' ')YesNFL_Q1 Allow NULL? 
29NFL_DEFDefault Value for Number of Aircraftdecimal166DEC((0))YesNFL_DEF
30NEQ_Q1Source of Number of Parts per Aircraftnvarchar20CHAR(N' ')YesNEQ_Q1 Allow NULL? 
31NEQ_Q2Source of Number of Parts per Aircraftnvarchar20CHAR(N' ')YesNEQ_Q1 Allow NULL? 
32NEQ_DEFDefault Value for Parts per Aircraftdecimal166DEC((0))YesNEQ_DEF
33TAU_Q1Source for Operation Timenvarchar20CHAR(N' ')YesTAU_Q1 Allow NULL? 
34TAU_Q2Source for Operation Timenvarchar20CHAR(N' ')YesTAU_Q1 Allow NULL? 
35TAU_DEF_OHDefault Value for Operation Timedecimal166DEC((0))YesTAU_DEF
36TAU_DEF_LCDefault Value for Operation Timedecimal166DEC((0))YesTAU_DEF
37TAU_DEF_OCDefault Value for Operation Timedecimal166DEC((0))YesTAU_DEF
38DD_DEFAnnual Demanddecimal166DEC((0))YesDD_DEF
39SAVE_TYPESaving Typechar10CHAR(N' ')YesSAVE_TYPE Allow NULL? 
40CALC_TYPE2Type of calculationchar10CHAR(N' ')YesCALC_TYPE2 Allow NULL? 
41ROT_EXP_TYPERotable / Expendablechar10CHAR(N' ')YesROT_EXP_TYPE Allow NULL? 
42MAD_TYPEMinimum Annual Demand: regard or not by calculationchar10CHAR(N' ')YesMAD_TYPE Allow NULL? 
43BATCH_DUM1BATCH_DUM1nvarchar20CHAR(N' ')YesBATCH_DUM1 Allow NULL? 
44BATCH_DUM2BATCH_DUM2nvarchar20CHAR(N' ')YesBATCH_DUM2 Allow NULL? 
45BATCH_DUM3BATCH_DUM3nvarchar150CHAR(N' ')YesBATCH_DUM3 Allow NULL? 
46SUPPL1Supplier Codenvarchar50CHAR(N' ')YesADSPC_SPL Allow NULL? 
47WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
48BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
49FLAG_NUM_BATCHNumerical schemechar10CHAR(N' ')YesFLAG_NUMERIC Allow NULL? 
50IP_MATNR_ASSIGNAssignment IP - Materialchar10CHAR(N' ')YesIP_MATNR_ASSIGN Allow NULL? 
51DUMMY1Char 15nvarchar150CHAR(N' ')YesCHAR15 Allow NULL? 
52DUMMY2Char 15nvarchar150CHAR(N' ')YesCHAR15 Allow NULL? 
53DUMMY3Char 15nvarchar150CHAR(N' ')YesCHAR15 Allow NULL? 
54DUMMY4Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
55DUMMY5Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
56DUMMY6Single-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
NamePrimaryUniqueTypeColumns
ORF5CUST~0YesYesCLUSTEREDPROFL_ID, 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