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  | T607F
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
1ORCT154Incoming Payment
2OITM249Items
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OINM101Whse Journal
7OPCH268A/P Invoice
8JDT1110Journal Entry - Rows
9OOCR9Loading Factors
10OSRN20Serial Numbers Master Data
Sales and Distribution :: Foreign Trade :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0T607F461Documentary Payments: Indicators - Field Ctrl/Doc.CheckBasic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, INDAK, AKICMES, AKICDIA, CONFIRMAKT, KUNFS, KUNCK, AADFS, AADCK, AIDFS, AIDCK, AEDFS, AEDCK, AXDFS, AXDCK, AVDFS, AVDCK, ALDFS, ALDCK, ADDFS, ADDCK, AWEFS, AWECK, IAPFS, EUPFS, EUPCK, TEZFS, TEZCK, INCFS, INCCK, AUTFS, AUTCK, ATRFS, ATRCK, AMIFS, AMICK, TXTGR, FDLANGU, REFFS, INDGRUND, DOKFREI, FTCCD, DDZCK, DDICK, UNPFS, UNPCK FROM T607F
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2INDAKFinancial document processing: Financial document indicatornvarchar20CHAR(N' ')NoINDAK Allow NULL? 
3AKICMESFinancial document processing: Incompletion handlingchar10CHAR(N' ')YesAKICMES Allow NULL? 
4AKICDIAFinanc. doc. procg: System reaction in case of incompletionchar10CHAR(N' ')YesAKICDIA Allow NULL? 
5CONFIRMAKTFinancial document procg: Activate extended double-checkchar10CHAR(N' ')YesCONFIRMAKT Allow NULL? 
6KUNFSFinancial doc. processing: Field sel. cust./vendor numberschar10CHAR(N' ')YesKUNFS Allow NULL? 
7KUNCKFinancial doc. processing: Check customer / vendor numberschar10CHAR(N' ')YesKUNCK Allow NULL? 
8AADFSFinancial document processing: Fld selection - Request datechar10CHAR(N' ')YesAADFS Allow NULL? 
9AADCKFinancial document processing: Check request datechar10CHAR(N' ')YesAADCK Allow NULL? 
10AIDFSFinancial document processing: Fld selection - Opening datechar10CHAR(N' ')YesAIDFS Allow NULL? 
11AIDCKFinancial document processing: Check creation datechar10CHAR(N' ')YesAIDCK Allow NULL? 
12AEDFSFinancial doc. processing: Fld selection - Date of receiptchar10CHAR(N' ')YesAEDFS Allow NULL? 
13AEDCKFinancial document processing: Check date of receiptchar10CHAR(N' ')YesAEDCK Allow NULL? 
14AXDFSFinancial doc. procg: Field selection - Validity end datechar10CHAR(N' ')YesAXDFS Allow NULL? 
15AXDCKFinancial document processing: Check validity end datechar10CHAR(N' ')YesAXDCK Allow NULL? 
16AVDFSFinancial doc. procg: Field selection - Latest shipping datechar10CHAR(N' ')YesAVDFS Allow NULL? 
17AVDCKfinancial document processing: Check latest shipping datechar10CHAR(N' ')YesAVDCK Allow NULL? 
18ALDFSFinancial doc.procg: Fld selection - Date of bill of ladingchar10CHAR(N' ')YesALDFS Allow NULL? 
19ALDCKFinancial doc. procg: Check date of shipped bill of ladingchar10CHAR(N' ')YesALDCK Allow NULL? 
20ADDFSFinancial document processing: Fld ctrl - Submission of doc.char10CHAR(N' ')YesADDFS Allow NULL? 
21ADDCKFinancial document processing: Check submission of documentchar10CHAR(N' ')YesADDCK Allow NULL? 
22AWEFSFinancial doc. procg: Field selection - Financial doc. valuechar10CHAR(N' ')YesAWEFS Allow NULL? 
23AWECKFinancial doc. processing: Check financial document valuechar10CHAR(N' ')YesAWECK Allow NULL? 
24IAPFSFinancial document processing: Field selection consumptionchar10CHAR(N' ')YesIAPFS Allow NULL? 
25EUPFSFinancial document processing: Fld selection for overdraft %char10CHAR(N' ')YesEUPFS Allow NULL? 
26EUPCKFinancial document processing: Check percentage of overdraftchar10CHAR(N' ')YesEUPCK Allow NULL? 
27TEZFSFinancial doc. proc.: Field selection terms of paymentchar10CHAR(N' ')YesTEZFS Allow NULL? 
28TEZCKFinancial doc. processing: Check terms of paymentchar10CHAR(N' ')YesTEZCK Allow NULL? 
29INCFSFinancial document processing: Incoterms field selectionchar10CHAR(N' ')YesINCFS Allow NULL? 
30INCCKFinancial doc. processing: Check INCOTermschar10CHAR(N' ')YesINCCK Allow NULL? 
31AUTFSFinancial doc. procg: Field selection for partial dlv. ind.char10CHAR(N' ')YesAUTFS Allow NULL? 
32AUTCKFinancial document processing: Check partial delivery ind.char10CHAR(N' ')YesAUTCH Allow NULL? 
33ATRFSFinancial document processing: Fld selection - Reload ind.char10CHAR(N' ')YesATRFS Allow NULL? 
34ATRCKFinancial doc. procg: Check reload indicatorchar10CHAR(N' ')YesATRCK Allow NULL? 
35AMIFSFinancial document processing: Fld selection - Min./Max.qtychar10CHAR(N' ')YesAMIFS Allow NULL? 
36AMICKFinancial document processing: Check minimum/maximum qtychar10CHAR(N' ')YesAMICK Allow NULL? 
37TXTGRText determination procedurenvarchar20CHAR(N' ')YesTTXGTXTGR Allow NULL? 
38FDLANGUFinancial document processing: Default document languagechar10LANG(N' ')YesFDLANGU Allow NULL? 
39REFFSFinancial document processing: Field selection search termchar10CHAR(N' ')YesSUCHFS Allow NULL? 
40INDGRUNDFinancial document processing: Indicator for change reasonchar10CHAR(N' ')YesT607GINDGRUND Allow NULL? 
41DOKFREIFinancial document processing: Free entry of docs possiblechar10CHAR(N' ')YesDOKFREI Allow NULL? 
42FTCCDDerivation of company code from org. unit for Foreign Tradechar10CHAR(N' ')YesFTCCD Allow NULL? 
43DDZCKExistence check control of payment terms for financial docschar10CHAR(N' ')YesDDZCK Allow NULL? 
44DDICKExistence check control of Incoterms for financial documentschar10CHAR(N' ')YesDDICK Allow NULL? 
45UNPFSFinancial document processing: Field selection shortfall PRchar10CHAR(N' ')YesUNPFS Allow NULL? 
46UNPCKFinancial document processing: Shortfall percentage ratechar10CHAR(N' ')YesUNPCK Allow NULL? 
NamePrimaryUniqueTypeColumns
T607F~0YesYesCLUSTEREDINDAK, 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