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  | FRE_SEND_OPTION
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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction
Cross-Application Components
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0FRE_SEND_OPTION1021Maintain Basic Settings for Data TransferCross-Application Components
SQL:  selectupdate insert create

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

SELECT MANDT, FRE_ACTIVE, FRE_RELEASE, FRE_RFC, SEND_ONCE, SEND_INTVL, SEND_INB_DIR, SEND_DEST, NUM_O_REC, FILESYST, LOGICAL_PATH_OUT, LOGICAL_PATH_TS, LOGICAL_PATH_MD, SAVE_FILES, SERVERGROUP, MAX_PARA_JOBS, TS_PER_INIT, TS_PER_NORM, WERKS_FILTER, DB_SELECT_PKG, LG_PKG_SIZE, WAIT_SECONDS, CPOCAL_DC, CPOCAL_STORE, PAST_LISTING, DIF_ACT, MCH_ACT, ARH_ACT, SGT_ACT, PROCYC_ACT, RPR_ACT, UOM_ACT, PRM_ACT, CONT_ACT, EKORG_ACT, ADD_ATTEMPTS, WAIT_TIME, DIF_NUM_REC, DIF_FILTER, DIF_PAST_PERIODS, REF_PSIZE_HEAD, REF_PSIZE_MODULE, SEND_RELPRO, INIT_DC, DELTA_DC, INIT_ST, DELTA_ST, MESS_CTRL, DOCSYNC_STATUS, SEND_LAYMOD, SEND_STRUCT_ART, NO_UNAMB_CHECK, SUPPORT_LEVEL, FILE_OUT, FILE_IN, FILE_MD1, FILE_MD2, FILE_MD3, FILE_MD4, FILE_MD5, FILE_MD6, FILE_MD7, FILE_MD8, FILE_MD9, FILE_MDL, FILE_CO, FILE_SU1, FILE_SU2, FILE_TS, FILE_EKORG, DIF_ACT_NO_SITES, DIF_NUM_REC2, DIF_ID_NO_SITES, DIF_PAST_PERIOD2, DIF_REPL_REL, DIF_DEV_PERC, DIF_EORD_USE, SU1_ACT, SU2_ACT, STOCK_TD_ACT, PROCYC_TD_ACT, FILE_TDL, PROCYC_TD_ASSIGN, SU1_PACKAGE_SIZE, SU2_PACKAGE_SIZE, FRE_NEW_LANES, FRE_NO_PRICES, FRE_INFREC_PRICE, FRE_STAND_PRICE, LAST_CHANGED_BY, LAST_CHANGED_AT, FRE_NEW_LP, FRE_STOCK_ACT, FRE_CONS_ACT, TS_PER_MERGE, FRE_SOURCE_LIST, PLIFZ_TD_ACT, PLIFZ_TD_ASSIGN, FRE_PO_NOT_REL_R, SO_ACT, SO_PAST_PERIOD, FILE_SO FROM FRE_SEND_OPTION
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2FRE_ACTIVEF&R is active and Connection existschar10CHAR(N' ')YesFRE_ACTIVE Allow NULL? 
3FRE_RELEASERelease of connected F&R Systemnvarchar20CHAR(N' ')YesFRE_RELEASE Allow NULL? 
4FRE_RFCSend Data to F&R by Asynchronous RFCchar10CHAR(N' ')YesFRE_RFC Allow NULL? 
5SEND_ONCETransmission to F&R once a daychar10CHAR(N' ')YesFRE_SEND_ONCE Allow NULL? 
6SEND_INTVLTransmission to F&R several times a day (Interval)char10CHAR(N' ')YesFRE_SEND_INTVL Allow NULL? 
7SEND_INB_DIRTransmission of Inbound Changes Immediatelychar10CHAR(N' ')YesFRE_SEND_INB_DIR Allow NULL? 
8SEND_DESTLogical Destination (Specified in Function Call)nvarchar320CHAR(N' ')YesRFCDESRFCDEST Allow NULL? 
9NUM_O_RECNumber of Records per Packagedecimal90DEC((0))YesFRE_NUM_O_REC
10FILESYSTSyntax group for file and path namesnvarchar100CHAR(N' ')YesFILESYSFILESYS_D Allow NULL? 
11LOGICAL_PATH_OUTLogical path namenvarchar600CHAR(N' ')YesFILEPATHPATHINTERN Allow NULL? 
12LOGICAL_PATH_TSLogical path namenvarchar600CHAR(N' ')YesFILEPATHPATHINTERN Allow NULL? 
13LOGICAL_PATH_MDLogical path namenvarchar600CHAR(N' ')YesFILEPATHPATHINTERN Allow NULL? 
14SAVE_FILESNo. of Days to store Filesdecimal30DEC((0))YesFRE_SAVE_FILES
15SERVERGROUPLogon/Server Group Namenvarchar200CHAR(N' ')YesRZLLITABRZLLI_APCL Allow NULL? 
16MAX_PARA_JOBSMaximum number of parallel tasksint100INT4((0))YesDDMAXTASKS Allow NULL? 
17TS_PER_INITNumber of Periods for Consumption initial loadnvarchar30NUMC(N'000')YesFRE_TS_PER_INIT Allow NULL? 
18TS_PER_NORMNumber of Periods for Consumption Normal Loadnvarchar30NUMC(N'000')YesFRE_TS_PER_NORMAL Allow NULL? 
19WERKS_FILTERHigh level filtering over customized siteschar10CHAR(N' ')YesFRE_WERKS_FILTER Allow NULL? 
20DB_SELECT_PKGNumber of Records per Packagedecimal90DEC((0))YesFRE_PACKAGE_SIZE
21LG_PKG_SIZENumber of Records per Packagedecimal90DEC((0))YesFRE_LOCGRP_PKG_SIZE
22WAIT_SECONDSTime Interval (Seconds) to Waitnvarchar20NUMC(N'00')YesFRE_SECONDS_TO_WAIT Allow NULL? 
23CPOCAL_DCCentral order calendar for DCsnvarchar20CHAR(N' ')YesTFACDFRE_CPOCAL_DC Allow NULL? 
24CPOCAL_STORECentral order calendar for storesnvarchar20CHAR(N' ')YesTFACDFRE_CPOCAL_STORE Allow NULL? 
25PAST_LISTINGnumber of days with listing information in the pastnvarchar40NUMC(N'0000')YesFREDE_NODAYS Allow NULL? 
26DIF_ACTTransfer Demand Influencing Factors to F&Rchar10CHAR(N' ')YesFRE_DIF_ACT Allow NULL? 
27MCH_ACTTransfer Merchandize Categ. Hierarchies to F&Rchar10CHAR(N' ')YesFRE_MCH_ACT Allow NULL? 
28ARH_ACTTransfer Article Hierarchies to F&Rchar10CHAR(N' ')YesFRE_ARH_ACT Allow NULL? 
29SGT_ACTTransfer Site Grouping Data to F&Rchar10CHAR(N' ')YesFRE_PLG_ACT Allow NULL? 
30PROCYC_ACTTransfer procurement cycles to F&Rchar10CHAR(N' ')YesFRE_PROCYC_ACT Allow NULL? 
31RPR_ACTActivate Transmission of Rounding Profiles to F&Rchar10CHAR(N' ')YesFRE_RPR_ACT Allow NULL? 
32UOM_ACTActivate Transmission of Unit of Measure Groups to F&Rchar10CHAR(N' ')YesFRE_UOM_ACT Allow NULL? 
33PRM_ACTTransfer Processing Methods to F&Rchar10CHAR(N' ')YesFRE_PROCMETH Allow NULL? 
34CONT_ACTTransfer Contract Data to F&Rchar10CHAR(N' ')YesFRE_CO_ACT Allow NULL? 
35EKORG_ACTActivate Transmission of Pur. Org. & Assignment to F&Rchar10CHAR(N' ')YesFRE_EKORG_AND_ASSIGN Allow NULL? 
36ADD_ATTEMPTSAdditional accessing attemptsnvarchar20NUMC(N'00')YesFRE_ADD_ATTEMPTS Allow NULL? 
37WAIT_TIMEWaiting time before next attemptnvarchar30NUMC(N'000')YesFRE_WAIT_TIME Allow NULL? 
38DIF_NUM_RECNumber of Records per Packagedecimal90DEC((0))YesFRE_DIF_NUM_O_REC
39DIF_FILTERFilter type for DIF occurrence (when saving promotions)char10CHAR(N' ')YesFRE_DIF_FILTER Allow NULL? 
40DIF_PAST_PERIODSPeriod in weeks that must be taken into accountnvarchar30NUMC(N'000')YesFRE_DIF_PAST_PERIODS Allow NULL? 
41REF_PSIZE_HEADPackage Size for reference module assignmentdecimal90DEC((0))YesFRE_REF_PSIZE_HEAD
42REF_PSIZE_MODULEPackage Size for reference modulesdecimal90DEC((0))YesFRE_REF_PSIZE_MODULE
43SEND_RELPROSend release profiles and assigments to SAP F&Rchar10CHAR(N' ')YesFRE_SEND_RELPRO Allow NULL? 
44INIT_DCInitial data transfer for distribution centerschar10CHAR(N' ')YesFRE_INIT_DC Allow NULL? 
45DELTA_DCDelta data transfer for distribution centerschar10CHAR(N' ')YesFRE_DELTA_DC Allow NULL? 
46INIT_STInitial data transfer for storeschar10CHAR(N' ')YesFRE_INIT_ST Allow NULL? 
47DELTA_STDelta data transfer for storeschar10CHAR(N' ')YesFRE_DELTA_ST Allow NULL? 
48MESS_CTRLMessage control for data transferchar10CHAR(N' ')YesFRE_MESS_CTRL Allow NULL? 
49DOCSYNC_STATUSDocument Synchronisation active -deactivechar10CHAR(N' ')YesFRE_DOCSYNC_STATUS Allow NULL? 
50SEND_LAYMODSend layout modules to SAP F&Rchar10CHAR(N' ')YesFRE_SEND_LAYMOD Allow NULL? 
51SEND_STRUCT_ARTSend structured articles to SAP F&Rnvarchar20CHAR(N' ')YesFRE_SEND_STRUCT_ART Allow NULL? 
52NO_UNAMB_CHECKdo not check for unique numberschar10CHAR(N' ')YesNO_UNAMB_CHECK Allow NULL? 
53SUPPORT_LEVELSupport Level - SAP Internalnvarchar20CHAR(N' ')YesFRE_SUPPORT_LEVEL Allow NULL? 
54FILE_OUTSave Order Proposal Outbound Data in Filechar10CHAR(N' ')YesFRE_FILE_OUT Allow NULL? 
55FILE_INSave Order Proposal Inbound Data in Filechar10CHAR(N' ')YesFRE_FILE_IN Allow NULL? 
56FILE_MD1Save MD Location Data in Filechar10CHAR(N' ')YesFRE_FILE_MD1 Allow NULL? 
57FILE_MD2Save MD Location Product Data in Filechar10CHAR(N' ')YesFRE_FILE_MD2 Allow NULL? 
58FILE_MD3Save MD Supply Network Data in Filechar10CHAR(N' ')YesFRE_FILE_MD3 Allow NULL? 
59FILE_MD4Save MD Merchandise Category Data in Filechar10CHAR(N' ')YesFRE_FILE_MD4 Allow NULL? 
60FILE_MD5Save MD Location Group Data in Filechar10CHAR(N' ')YesFRE_FILE_MD5 Allow NULL? 
61FILE_MD6Save MD DIF Occurrence Data in Filechar10CHAR(N' ')YesFRE_FILE_MD6 Allow NULL? 
62FILE_MD7Save MD Article Hierarchy Data in Filechar10CHAR(N' ')YesFRE_FILE_MD7 Allow NULL? 
63FILE_MD8Save MD Procurement Cycle Data in Filechar10CHAR(N' ')YesFRE_FILE_MD8 Allow NULL? 
64FILE_MD9Save MD Release Profile Data in Filechar10CHAR(N' ')YesFRE_FILE_MD9 Allow NULL? 
65FILE_MDLSave MD Layout Module Data in Filechar10CHAR(N' ')YesFRE_FILE_MDL Allow NULL? 
66FILE_COcreate recovery files for transmitted contractschar10CHAR(N' ')YesFRE_FILE_CO Allow NULL? 
67FILE_SU1Save Substitution Assignment Information in Filechar10CHAR(N' ')YesFRE_FILE_SU1 Allow NULL? 
68FILE_SU2Save Substitution Switchover Information to Filechar10CHAR(N' ')YesFRE_FILE_SU2 Allow NULL? 
69FILE_TSSave Time Series Data to Filechar10CHAR(N' ')YesFRE_FILE_TS Allow NULL? 
70FILE_EKORGSave P.Org. Assignment in Filechar10CHAR(N' ')YesFRE_FILE_EKORG Allow NULL? 
71DIF_ACT_NO_SITESTransfer DIF Occurrences for Number of Supplied Sites to F&Rchar10CHAR(N' ')YesFRE_DIF_ACT_NO_SITES Allow NULL? 
72DIF_NUM_REC2Number of Data Records in a Packagedecimal90DEC((0))YesFRE_DIF_NUM_O_REC2
73DIF_ID_NO_SITESDIF identifiernvarchar30CHAR(N' ')YesFRE_DIFID Allow NULL? 
74DIF_PAST_PERIOD2Period in Weeks for Number of Supplied Plantsnvarchar30NUMC(N'000')YesFRE_DIF_PAST_PERIOD2 Allow NULL? 
75DIF_REPL_RELOnly Count Matl-Plant Combs Relevant for F&R Matls Planningchar10CHAR(N' ')YesFRE_DIF_ONLY_REPLENISHMENT_REL Allow NULL? 
76DIF_DEV_PERCMaximum Variation to Ignore (in Percent)nvarchar30NUMC(N'000')YesFRE_DIF_DEVIATION_PERCENTAGE Allow NULL? 
77DIF_EORD_USEUse Purchasing Source Listchar10CHAR(N' ')YesFRE_DIF_EORD_USE Allow NULL? 
78SU1_ACTSubstitution Interface Assigment Information Activechar10CHAR(N' ')YesFRE_SU1_ACT Allow NULL? 
79SU2_ACTSubstitution - Interface Switchover Information Activechar10CHAR(N' ')YesFRE_SU2_ACT Allow NULL? 
80STOCK_TD_ACTTransfer TD Min-Max Stock Levels for Promotions to F&Rchar10CHAR(N' ')YesFRE_DISPRO_STOCK_TD_ACT Allow NULL? 
81PROCYC_TD_ACTTransfer TD Procurement Cycles for Promotions to F&Rchar10CHAR(N' ')YesFRE_DISPRO_PROCYC_TD_ACT Allow NULL? 
82FILE_TDLSave Time-Dependent Min/Max Stock for Promotions to Filechar10CHAR(N' ')YesFRE_FILE_TDL Allow NULL? 
83PROCYC_TD_ASSIGNAssignment of Time-Dependent Procurement Cycleschar10CHAR(N' ')YesFRE_DISPRO_PROCYC_ASSIGN Allow NULL? 
84SU1_PACKAGE_SIZENumber of Records per Packagedecimal90DEC((0))YesFRE_SU1_NUM_O_REC
85SU2_PACKAGE_SIZENumber of Records per Packagedecimal90DEC((0))YesFRE_SU2_NUM_O_REC
86FRE_NEW_LANESActivate new lanes modelchar10CHAR(N' ')YesFRE_NEW_LANES Allow NULL? 
87FRE_NO_PRICESNo Purchase Price Determination for Laneschar10CHAR(N' ')YesFRE_NO_PURCHASE_PRICING Allow NULL? 
88FRE_INFREC_PRICEFor Pricing use only Purchase Inforecord NetPricechar10CHAR(N' ')YesFRE_USE_INFORECORD_PRICE Allow NULL? 
89FRE_STAND_PRICEPerform Standard Purchasing Price Determinationchar10CHAR(N' ')YesFRE_STANDARD_PURCHASE_PRICING Allow NULL? 
90LAST_CHANGED_BYUser Namenvarchar120CHAR(N' ')YesSYUNAME Allow NULL? 
91LAST_CHANGED_ATUTC Time Stamp in Short Form (YYYYMMDDhhmmss)decimal150DEC((0))YesTIMESTAMP
92FRE_NEW_LPActivate new location productchar10CHAR(N' ')YesFRE_NEW_LP Allow NULL? 
93FRE_STOCK_ACTTransfer Stock Data to F&Rchar10CHAR(N' ')YesFRE_STOCK_ACT Allow NULL? 
94FRE_CONS_ACTTransfer Consumption Data to F&Rchar10CHAR(N' ')YesFRE_CONS_ACT Allow NULL? 
95TS_PER_MERGEMerge Overlapping Consumption Periods (Initial Load)char10CHAR(N' ')YesFRE_TS_PER_MERGE Allow NULL? 
96FRE_SOURCE_LISTTransfer Source List Data as Lanes to F&Rchar10CHAR(N' ')YesFRE_SOURCE_LIST_ACT Allow NULL? 
97PLIFZ_TD_ACTTransfer TD Planned Delivery Time for Promotions to F&Rchar10CHAR(N' ')YesFRE_DISPRO_PLIFZ_TD_ACT Allow NULL? 
98PLIFZ_TD_ASSIGNAssignment of Time-Dependent Planned Delivery Timechar10CHAR(N' ')YesFRE_DISPRO_PLIFZ_ASSIGN Allow NULL? 
99FRE_PO_NOT_REL_RTransmission of POs for F&R-Relevant Supplying Plantschar10CHAR(N' ')YesFRE_PO_NOT_REL_REC_LOC Allow NULL? 
100SO_ACTTransfer Sales Order to F&Rchar10CHAR(N' ')YesFRE_SO_ACT Allow NULL? 
101SO_PAST_PERIODPast Time Horizon for Completed Sales Orders in Daysnvarchar30NUMC(N'000')YesFRE_SO_PAST_PERIOD Allow NULL? 
102FILE_SOCreate Recovery Files for Transmitted Sales Order Datachar10CHAR(N' ')YesFRE_FILE_SO Allow NULL? 
NamePrimaryUniqueTypeColumns
FRE_SEND_OPTION~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