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  | ORFCALC
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)
8BSEG345Accounting Document Segment
9/1RA/0SD010MI170Items for Class SD01 - Raw Data
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 :: Aerospace Defence Industry Solution
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0ORFCALC1331Data Record ORF Calculation, ATTENTION: MOVE-CORR!Aerospace Defence Industry Solution
SQL:  selectupdate insert create

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

SELECT MANDT, SQNBR, PNR, MFR, EIP, EIM, MATNR, CALCNR, MOA, CUS, FLAG_ACTUAL, CREATED_ON_TIME, CREATED_ON_DATE, CREATED_BY, PROFL_ID, TEXT, NEQ_SYST, NEQ_MANUF, MTBE_SYST, MTBE_MANUF, TAT_REP_SYSTEM, TAT_TRP_SYSTEM, TAT_REP_MANUF, EC_SYSTEM, EC_MANUF, HOMESHOP_SYSTEM, PRICE_SYSTEM, PRICE_MANUF, CURR_SYSTEM, CURR_MANUF, MOA_USER, CUS_USER, MAKTX, SPC_MANUF, REC_MANUF, SPEC2_DUM1, SPEC2_DUM2, SPEC2_DUM3, SPEC2_DUM4, N_TP, N_EQ, TAU, MTBR, TAT_TOT, CL, MAD, ALGIN_DUM1, EC_EX, HOMESHOP_EX, DD_EX, N_TP_EX, N_EQ_EX, TAU_EX, MTBR_EX, TAT_REWORK_EX, TAT_TRANSP_EX, CL_EX, PRICE_EX, MAD_EX, ALGEX_DUM1, ALGEX_DUM2, ALGEX_DUM3, DD, ASL, RF, ALGOUT_DUM1, FLAG_BATCH, FLAG_NO_CALC, FLAG_MAD_TYPE, TCC_BATCH2, TCC_SRC, TCC_TRC, MTBE_SRC, MTBE_TRC, NTP_SRC, NTP_TRC, TAU_SRC, TAU_TRC, NEQ_SRC, NEQ_TRC, TAT_REP_SRC, TAT_REP_TRC, TAT_TRP_SRC, TAT_TRP_TRC, EC_SRC, EC_TRC, HS_SRC, HS_TRC, PRICE_SRC, PRICE_TRC, BATCH2_DUM1, BATCH2_DUM2, BATCH2_DUM3, EXTERN_CALC, INVERSION_CALC, EXPEND_PART, BANF_CREATED, NO_MM_DATA, NO_IP_DATA, NO_EX_DATA, MTBE_SEARCH, MTBE_LENGHT, MTBE_DATETO, FLAG_NUMERIC, FLAG_NUM_BATCH, FLAG_NUM_N, SUPPL1, WERKS, BWTAR, FLAG_VPRSV, IP_MATNR_ASSIGN, WRONG_ASSIGN, MTBE_SY_SRC, TAT_REP_SY_SRC, TAT_TRP_SY_SRC, EC_SY_SRC, HS_SY_SRC, PRICE_SY_SRC, CURR_SY_SRC, MATNR_SY_SRC, CUS_SY_SRC, SY_SRC_DUM1, CHANGE_MAT, FLAG_DUM1, FLAG_DUM2, FLAG_DUM3, FLAG_DUM4, FLAG_DUM5, FLAG_DUM6, FLAG_DUM7, FLAG_DUM8, FLAG_DUM9, RADIO200 FROM ORFCALC
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2SQNBRSequence Numbernvarchar50NUMC(N'00000')NoADSPC_SQNBR Allow NULL? 
3PNRPart Numbernvarchar150CHAR(N' ')NoADSPC_PNR Allow NULL? 
4MFRManufacturer Codenvarchar50CHAR(N' ')NoADSPC_MFR Allow NULL? 
5EIPEnd Item Part Numbernvarchar150CHAR(N' ')NoADSPC_EIP Allow NULL? 
6EIMEnd Item Manufacturer Codenvarchar50CHAR(N' ')NoADSPC_EIM Allow NULL? 
7MATNRMaterial Numbernvarchar180CHAR(N' ')No*MATNR Allow NULL? 
8CALCNRNumber of the Stock Calculationint100INT4((0))NoCALCNR Allow NULL? 
9MOAModel of Applicability Codenvarchar40CHAR(N' ')YesADSPC_MOA Allow NULL? 
10CUSCustomer Codenvarchar50CHAR(N' ')YesADSPC_CUS Allow NULL? 
11FLAG_ACTUALStatus of the Calculation: Current, Previous, Simulationchar10CHAR(N' ')YesFLAG_ACTUAL Allow NULL? 
12CREATED_ON_TIMESPEC2000: Created on Timenvarchar60TIMS(N'000000')YesADSPC_CREATED_ON_TIME Allow NULL? 
13CREATED_ON_DATESPEC2000: Created on Datenvarchar80DATS(N'00000000')YesADSPC_CREATED_ON_DATE Allow NULL? 
14CREATED_BYUser Namenvarchar120CHAR(N' ')YesSYUNAME Allow NULL? 
15PROFL_IDCustomizing Profile for Single Item Stock Calculationnvarchar60CHAR(N' ')YesORF2CUSTPROFL1_NAME Allow NULL? 
16TEXTCustomizing Profile for Single Item Stock Calculationnvarchar150CHAR(N' ')YesTEXT_PRF_ORF Allow NULL? 
17NEQ_SYSTNumber of Parts per Aircraftdecimal166DEC((0))YesN_EQ
18NEQ_MANUFNumber of Parts per Aircraftdecimal166DEC((0))YesN_EQ
19MTBE_SYSTMean Time Between Events (MTBE)decimal166DEC((0))YesMTBR
20MTBE_MANUFMean Time Between Events (MTBE)decimal166DEC((0))YesMTBR
21TAT_REP_SYSTEMRepair Time (System) / Provision Perioddecimal166DEC((0))YesTAT_REP_SYSTEM
22TAT_TRP_SYSTEMTransport Time (System)decimal166DEC((0))YesTAT_TRP_SYSTEM
23TAT_REP_MANUFRepair Time ( Manufacturer)decimal166DEC((0))YesTAT_REP_MANUF
24EC_SYSTEMEssentiality Codechar10NUMC(N'0')YesEC Allow NULL? 
25EC_MANUFEssentiality Codechar10NUMC(N'0')YesEC Allow NULL? 
26HOMESHOP_SYSTEMLaboratory/design officenvarchar30CHAR(N' ')YesT024LLABOR Allow NULL? 
27PRICE_SYSTEMChoosed Price (MM): Mov. av. Price or Standard Pricedecimal112CURR((0))YesVERPR_STPRS
28PRICE_MANUFPricedecimal112CURR((0))YesUNIT_PRICE
29CURR_SYSTEMCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
30CURR_MANUFCurrency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
31MOA_USERModel of Applicability Codenvarchar40CHAR(N' ')YesADSPC_MOA Allow NULL? 
32CUS_USERCustomer Codenvarchar50CHAR(N' ')YesADSPC_CUS Allow NULL? 
33MAKTXMaterial Description (Short Text)nvarchar400CHAR(N' ')YesMAKTX Allow NULL? 
34SPC_MANUFSpare Part Class Codechar10NUMC(N'0')YesADSPC_SPC Allow NULL? 
35REC_MANUFRecommended Quantitynvarchar40NUMC(N'0000')YesADSPC_REC Allow NULL? 
36SPEC2_DUM1SPEC2_DUM1nvarchar150CHAR(N' ')YesSPEC2_DUM1 Allow NULL? 
37SPEC2_DUM2SPEC2_DUM2nvarchar150CHAR(N' ')YesSPEC2_DUM2 Allow NULL? 
38SPEC2_DUM3SPEC2_DUM3nvarchar150CHAR(N' ')YesSPEC2_DUM3 Allow NULL? 
39SPEC2_DUM4SPEC2_DUM4nvarchar150CHAR(N' ')YesSPEC2_DUM4 Allow NULL? 
40N_TPNumber of Aircraftdecimal166DEC((0))YesN_TP
41N_EQNumber of Parts per Aircraftdecimal166DEC((0))YesN_EQ
42TAUOperation Timedecimal166DEC((0))YesTAU
43MTBRMean Time Between Events (MTBE)decimal166DEC((0))YesMTBR
44TAT_TOTTurnaround Time / Provision Perioddecimal166DEC((0))YesTAT_TOT
45CLService Leveldecimal166DEC((0))YesCL
46MADMinimum Annual Demanddecimal166DEC((0))YesMIN_ANN_DEM
47ALGIN_DUM1ALGIN_DUM1decimal166DEC((0))YesALGIN_DUM1
48EC_EXEssentiality Codechar10NUMC(N'0')YesEC Allow NULL? 
49HOMESHOP_EXLaboratory/design officenvarchar30CHAR(N' ')Yes*LABOR Allow NULL? 
50DD_EXAnnual Demanddecimal166DEC((0))YesDD
51N_TP_EXNumber of Aircraftdecimal166DEC((0))YesN_TP
52N_EQ_EXNumber of Parts per Aircraftdecimal166DEC((0))YesN_EQ
53TAU_EXOperation Timedecimal166DEC((0))YesTAU
54MTBR_EXMean Time Between Events (MTBE)decimal166DEC((0))YesMTBR
55TAT_REWORK_EXRepair Time / Provision Period (External Model)decimal166DEC((0))YesTAT_REWORK_EX
56TAT_TRANSP_EXTransport Time (External Model)decimal166DEC((0))YesTAT_TRANSP_EX
57CL_EXService Leveldecimal166DEC((0))YesCL
58PRICE_EXPricedecimal112CURR((0))YesUNIT_PRICE
59MAD_EXMinimum Annual Demanddecimal166DEC((0))YesMIN_ANN_DEM
60ALGEX_DUM1ALGEX_DUM1decimal166DEC((0))YesALGEX_DUM1
61ALGEX_DUM2ALGEX_DUM2decimal166DEC((0))YesALGEX_DUM2
62ALGEX_DUM3Currency Keynvarchar50CUKY(N' ')Yes*WAERS Allow NULL? 
63DDAnnual Demanddecimal166DEC((0))YesDD
64ASLAverage Shop Load / Provision Period Demanddecimal166DEC((0))YesASL
65RFRotable Float / Expendable Requirement Quantitydecimal166DEC((0))YesRF
66ALGOUT_DUM1ALGOUT_DUM1decimal166DEC((0))YesALGOUT_DUM1
67FLAG_BATCHFlag: Multiple Item Calculationchar10CHAR(N' ')YesFLAG_BATCH Allow NULL? 
68FLAG_NO_CALCFlag: no Calculation possiblechar10CHAR(N' ')YesFLAG_NO_CALC Allow NULL? 
69FLAG_MAD_TYPEMinimum Annual Demand: regard or not by calculationchar10CHAR(N' ')YesMAD_TYPE Allow NULL? 
70TCC_BATCH2Time Cycle Code for URRchar10CHAR(N' ')YesADSPC_URRTCC Allow NULL? 
71TCC_SRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
72TCC_TRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
73MTBE_SRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
74MTBE_TRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
75NTP_SRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
76NTP_TRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
77TAU_SRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
78TAU_TRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
79NEQ_SRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
80NEQ_TRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
81TAT_REP_SRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
82TAT_REP_TRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
83TAT_TRP_SRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
84TAT_TRP_TRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
85EC_SRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
86EC_TRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
87HS_SRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
88HS_TRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
89PRICE_SRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
90PRICE_TRCFlag: Source / Trace Batchnvarchar20CHAR(N' ')YesSRC_TRC_CHAR2 Allow NULL? 
91BATCH2_DUM1BATCH2_DUM1nvarchar20CHAR(N' ')YesBATCH2_DUM1 Allow NULL? 
92BATCH2_DUM2BATCH2_DUM2nvarchar20CHAR(N' ')YesBATCH2_DUM2 Allow NULL? 
93BATCH2_DUM3BATCH2_DUM3nvarchar20CHAR(N' ')YesBATCH2_DUM3 Allow NULL? 
94EXTERN_CALCFlag: External Calculationchar10CHAR(N' ')YesEXTERN_CALC Allow NULL? 
95INVERSION_CALCFlag: Inversion Modechar10CHAR(N' ')YesINVERSION_CALC Allow NULL? 
96EXPEND_PARTFlag: Calculation of Expendable Partchar10CHAR(N' ')YesEXPEND_PART Allow NULL? 
97BANF_CREATEDFlag: Purchase Requisition createdchar10CHAR(N' ')YesBANF_CREATED Allow NULL? 
98NO_MM_DATAFlag: No MM Data availablechar10CHAR(N' ')YesNO_MM_DATA Allow NULL? 
99NO_IP_DATAFlag: No IP Data availablechar10CHAR(N' ')YesNO_IP_DATA Allow NULL? 
100NO_EX_DATAFlag: No Extractor Data availablechar10CHAR(N' ')YesNO_EX_DATA Allow NULL? 
101MTBE_SEARCHExtractor MTBE selection: recent or longest periodchar10CHAR(N' ')YesSEARCH_MTBE Allow NULL? 
102MTBE_LENGHTLength of the periodnvarchar20NUMC(N'00')YesLENPRD Allow NULL? 
103MTBE_DATETOEnd date of time segmentnvarchar80DATS(N'00000000')YesMTBE_DATETO Allow NULL? 
104FLAG_NUMERICNumerical schemechar10CHAR(N' ')YesFLAG_NUMERIC Allow NULL? 
105FLAG_NUM_BATCHFlag for numerical scheme (Multiple Item Calc.)char10CHAR(N' ')YesFLAG_NUM_BATCH Allow NULL? 
106FLAG_NUM_NSingle-Character Indicatorchar10CHAR(N' ')YesCHAR1 Allow NULL? 
107SUPPL1Supplier Codenvarchar50CHAR(N' ')YesADSPC_SPL Allow NULL? 
108WERKSPlantnvarchar40CHAR(N' ')Yes*WERKS_D Allow NULL? 
109BWTARValuation Typenvarchar100CHAR(N' ')Yes*BWTAR_D Allow NULL? 
110FLAG_VPRSVPrice control indicatorchar10CHAR(N' ')YesVPRSV Allow NULL? 
111IP_MATNR_ASSIGNAssignment IP - Materialchar10CHAR(N' ')YesIP_MATNR_ASSIGN Allow NULL? 
112WRONG_ASSIGNWrong Assignment IP - Materialchar10CHAR(N' ')YesWRONG_ASSIGN Allow NULL? 
113MTBE_SY_SRCSystem Source for MTBEchar10CHAR(N' ')YesMTBE_SY_SRC Allow NULL? 
114TAT_REP_SY_SRCSystem Source for Repair Time / Prov. Periodchar10CHAR(N' ')YesTAT_REP_SY_SRC Allow NULL? 
115TAT_TRP_SY_SRCSystem Source for Transport Timechar10CHAR(N' ')YesTAT_TRP_SY_SRC Allow NULL? 
116EC_SY_SRCSystem Source Essentiality Codechar10CHAR(N' ')YesEC_SY_SRC Allow NULL? 
117HS_SY_SRCSystem Source for Workshopchar10CHAR(N' ')YesHS_SY_SRC Allow NULL? 
118PRICE_SY_SRCSystem Source for Pricechar10CHAR(N' ')YesPRICE_SY_SRC Allow NULL? 
119CURR_SY_SRCSystem Source Currencychar10CHAR(N' ')YesCURR_SY_SRC Allow NULL? 
120MATNR_SY_SRCSystem Source for Materialchar10CHAR(N' ')YesMATNR_SY_SRC Allow NULL? 
121CUS_SY_SRCSystem Source Customerchar10CHAR(N' ')YesCUS_SY_SRC Allow NULL? 
122SY_SRC_DUM1SY_SRC_DUM1char10CHAR(N' ')YesSY_SRC_DUM1 Allow NULL? 
123CHANGE_MATFlag: Change Materialchar10CHAR(N' ')YesCHANGE_MAT Allow NULL? 
124FLAG_DUM1FLAG_DUM1char10CHAR(N' ')YesFLAG_DUM1 Allow NULL? 
125FLAG_DUM2FLAG_DUM2char10CHAR(N' ')YesFLAG_DUM2 Allow NULL? 
126FLAG_DUM3FLAG_DUM3char10CHAR(N' ')YesFLAG_DUM3 Allow NULL? 
127FLAG_DUM4FLAG_DUM4char10CHAR(N' ')YesFLAG_DUM4 Allow NULL? 
128FLAG_DUM5FLAG_DUM5char10CHAR(N' ')YesFLAG_DUM5 Allow NULL? 
129FLAG_DUM6FLAG_DUM6char10CHAR(N' ')YesFLAG_DUM6 Allow NULL? 
130FLAG_DUM7FLAG_DUM7nvarchar150CHAR(N' ')YesFLAG_DUM7 Allow NULL? 
131FLAG_DUM8FLAG_DUM8nvarchar150CHAR(N' ')YesFLAG_DUM8 Allow NULL? 
132FLAG_DUM9FLAG_DUM9nvarchar150CHAR(N' ')YesFLAG_DUM9 Allow NULL? 
133RADIO200Position of Radio Button (200) in a Stringnvarchar300CHAR(N' ')YesRADIO200 Allow NULL? 
NamePrimaryUniqueTypeColumns
ORFCALC~0YesYesCLUSTEREDCALCNR, MATNR, EIM, EIP, MFR, PNR, SQNBR, 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