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

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
1ERP EHP76.0/AIF/T_FINF701Interface definition
SQL:  selectupdate insert create

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

SELECT MANDT, NS, IFNAME, IFVERSION, FILETYPE, CR_LF, TEXTTYPE, SEPARATOR, HEADERLINE, HEADERFIELDNAMES, HEADERSTRUCT, FOOTERLINE, FOOTERSTRUCT, MAINSTRUCT, RECTYPEOFFSET, RECTYPECHARS, DEF_FILENAME, LAST_REC_VALUE, DDICSTRUCTURE, DDICSTRUCTUREXI, PROXYCLASSNAMEXI, PROXYCLASSNAMECL, XILINESTRUCT, XILINEFIELD, MOVECORRESP, DDICSTRUCTURERAW, RECTYPERAW, FUBA_CHECK, FUBA_CHECK_XI, FUBA_INIT, FUBA_INIT_TRANS, COMMITONCE, CODEPAGE, IGN_CERR, REPLACEMENTCHAR, MSG_LIFETIME, TESTRUN, MONITORING, POPUP_MONITORING, DEBUG_USER, KSCHL, NASTFUNCTION, PROCESSINGTYPE, VAR_ASSIGN_TAB, SYSTEM_FIELD, RFCDEST, APPL_ENGINE_ID, CUST_NS_APPL, CUST_APPL_ENG_ID, PERS_ENGINE_ID, CUST_NS_PERS, CUST_PERS_ENG_ID, SEL_ENGINE_ID, CUST_NS_SEL, CUST_SEL_ENG_ID, LOG_ENGINE_ID, CUST_NS_LOG, CUST_LOG_ENG_ID, MESTYP, IDOCTP, CIMTYP, MESCOD, MESFCT, STATUS, END_DATE, CLIENT_CONTRL, PRE_PROCESSING, PRX_METHOD, COMPONENT, BUSINESS_PROCESS FROM /AIF/T_FINF
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2NSNamespacenvarchar60CHAR(N' ')No/AIF/T_NS/AIF/NS Allow NULL? 
3IFNAMEInterface Namenvarchar100CHAR(N' ')No/AIF/IFNAME Allow NULL? 
4IFVERSIONInterface Versionnvarchar50CHAR(N' ')No/AIF/IFVERSION Allow NULL? 
5FILETYPEFile Typenvarchar100CHAR(N' ')Yes/AIF/IFFILETYPE Allow NULL? 
6CR_LFLine Ends with CR/LFchar10CHAR(N' ')Yes/AIF/CR_LF Allow NULL? 
7TEXTTYPEText Typenvarchar20CHAR(N' ')Yes/AIF/IFTEXTTYPE Allow NULL? 
8SEPARATORSeparatorchar10CHAR(N' ')Yes/AIF/SEPARATOR Allow NULL? 
9HEADERLINEHeader Line Existschar10CHAR(N' ')Yes/AIF/HEADERLINE Allow NULL? 
10HEADERFIELDNAMESHeaderline Contains Field Nameschar10CHAR(N' ')Yes/AIF/HEADERFIELDNAMES Allow NULL? 
11HEADERSTRUCTHeader Record Typenvarchar450CHAR(N' ')Yes/AIF/T_INTREC/AIF/HEADERRECTYPE Allow NULL? 
12FOOTERLINEFooter Line Existschar10CHAR(N' ')Yes/AIF/FOOTERLINE Allow NULL? 
13FOOTERSTRUCTFooter Line Record Typenvarchar450CHAR(N' ')Yes/AIF/T_INTREC/AIF/FOOTERRECTYPE Allow NULL? 
14MAINSTRUCTMain Record Typenvarchar450CHAR(N' ')Yes/AIF/T_INTREC/AIF/MAINRECTYPE Allow NULL? 
15RECTYPEOFFSETOffset of Record Type Fieldnvarchar20NUMC(N'00')Yes/AIF/RECTYPEOFFSET Allow NULL? 
16RECTYPECHARSRecord Type Fieldnvarchar20NUMC(N'00')Yes/AIF/RECTYPECHARS Allow NULL? 
17DEF_FILENAMEStandard Interface File Namenvarchar2550CHAR(N' ')Yes/AIF/DEF_FILENAME Allow NULL? 
18LAST_REC_VALUELast Value Indicatornvarchar1000CHAR(N' ')Yes/AIF/LAST_REC_VALUE Allow NULL? 
19DDICSTRUCTURESAP Data Structurenvarchar300CHAR(N' ')YesDD02L/AIF/IF_DDIC_STRUCT Allow NULL? 
20DDICSTRUCTUREXIXI Data Structurenvarchar300CHAR(N' ')YesDD02L/AIF/IF_DDIC_STRUCT_XI Allow NULL? 
21PROXYCLASSNAMEXIProxy Class Inboundnvarchar300CHAR(N' ')Yes/AIF/PROXY_INBOUND Allow NULL? 
22PROXYCLASSNAMECLProxy Class Outboundnvarchar300CHAR(N' ')Yes/AIF/PROXY_OUTBOUND Allow NULL? 
23XILINESTRUCTXI Data Line Structurenvarchar450CHAR(N' ')Yes/AIF/XILINESTRUCT Allow NULL? 
24XILINEFIELDField Name of XI Data Linenvarchar450CHAR(N' ')Yes/AIF/XILINEFIELD Allow NULL? 
25MOVECORRESPMove Corresponding Structureschar10CHAR(N' ')Yes/AIF/MOVECORRESPONDINGXI Allow NULL? 
26DDICSTRUCTURERAWRaw Data Structurenvarchar300CHAR(N' ')YesDD02L/AIF/IF_DDIC_STRUCT_RAW Allow NULL? 
27RECTYPERAWRecord Type in Raw Data Structurenvarchar450CHAR(N' ')Yes*/AIF/RECTYPERAW Allow NULL? 
28FUBA_CHECKCheck Function Modulenvarchar300CHAR(N' ')YesTFDIR/AIF/FUBA_CHECK_IF Allow NULL? 
29FUBA_CHECK_XIXI Check Function Modulenvarchar300CHAR(N' ')YesTFDIR/AIF/FUBA_CHECK_XI Allow NULL? 
30FUBA_INITInit Function Before Processingnvarchar300CHAR(N' ')YesTFDIR/AIF/FUBA_INIT Allow NULL? 
31FUBA_INIT_TRANSInit Function Before Mappingnvarchar300CHAR(N' ')YesTFDIR/AIF/FUBA_INIT_TRANS Allow NULL? 
32COMMITONCESeparate Commitchar10CHAR(N' ')Yes/AIF/COMMITONCE Allow NULL? 
33CODEPAGECode Pagenvarchar200CHAR(N' ')Yes/AIF/CODEPAGE Allow NULL? 
34IGN_CERRIgnore Conversion Errorschar10CHAR(N' ')Yes/AIF/IGN_CERR Allow NULL? 
35REPLACEMENTCHARReplacement Characterchar10CHAR(N' ')Yes/AIF/REPLCHAR Allow NULL? 
36MSG_LIFETIMELifetime of Application Lognvarchar100NUMC(N'0000000000')Yes/AIF/MSG_LIFETIME Allow NULL? 
37TESTRUNTest Modechar10CHAR(N' ')Yes/AIF/IFTESTRUN Allow NULL? 
38MONITORINGMonitor Levelchar10CHAR(N' ')Yes/AIF/MONITORING Allow NULL? 
39POPUP_MONITORINGShow Message as Popupchar10CHAR(N' ')Yes/AIF/POPUP_MONITORING Allow NULL? 
40DEBUG_USERDebugging Usernvarchar120CHAR(N' ')YesUSR02/AIF/DEBUG_USER Allow NULL? 
41KSCHLOutput Typenvarchar40CHAR(N' ')Yes/AIF/KSCHL Allow NULL? 
42NASTFUNCTIONNAST Messaging Function Modulenvarchar300CHAR(N' ')YesTFDIR/AIF/NASTFUNCTION Allow NULL? 
43PROCESSINGTYPEProcessing Type of Interfacenvarchar150CHAR(N' ')Yes/AIF/PROCESSINGTYPE Allow NULL? 
44VAR_ASSIGN_TABName of Variant Assigning Tablenvarchar300CHAR(N' ')YesDD02L/AIF/TABNAME_VAR_ASSIGN Allow NULL? 
45SYSTEM_FIELDField for the Sending Systemnvarchar1200CHAR(N' ')Yes/AIF/SYSTEM_FIELD Allow NULL? 
46RFCDESTLogical Destination (Specified in Function Call)nvarchar320CHAR(N' ')Yes*RFCDEST Allow NULL? 
47APPL_ENGINE_IDApplication Engine Identifiernvarchar30NUMC(N'000')Yes/AIF/S_ENGINES/AIF/APPL_ENGINE_ID Allow NULL? 
48CUST_NS_APPLNamespacenvarchar60CHAR(N' ')Yes/AIF/T_NS/AIF/NS Allow NULL? 
49CUST_APPL_ENG_IDIdentifier for a Customer-Specific AIF Enginenvarchar200CHAR(N' ')Yes/AIF/T_ENGINES/AIF/CUSTOMER_ENGINE_ID Allow NULL? 
50PERS_ENGINE_IDPersistence Engine Identifiernvarchar30NUMC(N'000')Yes/AIF/S_ENGINES/AIF/PERSISTENCY_ENGINE_ID Allow NULL? 
51CUST_NS_PERSNamespacenvarchar60CHAR(N' ')Yes/AIF/T_NS/AIF/NS Allow NULL? 
52CUST_PERS_ENG_IDIdentifier for a Customer-Specific AIF Enginenvarchar200CHAR(N' ')Yes/AIF/T_ENGINES/AIF/CUSTOMER_ENGINE_ID Allow NULL? 
53SEL_ENGINE_IDSelection Engine Identifiernvarchar30NUMC(N'000')Yes/AIF/S_ENGINES/AIF/SELECTION_ENGINE_ID Allow NULL? 
54CUST_NS_SELNamespacenvarchar60CHAR(N' ')Yes/AIF/T_NS/AIF/NS Allow NULL? 
55CUST_SEL_ENG_IDIdentifier for a Customer-Specific AIF Enginenvarchar200CHAR(N' ')Yes/AIF/T_ENGINES/AIF/CUSTOMER_ENGINE_ID Allow NULL? 
56LOG_ENGINE_IDLogging Engine Identifiernvarchar30NUMC(N'000')Yes/AIF/S_ENGINES/AIF/LOGGING_ENGINE_ID Allow NULL? 
57CUST_NS_LOGNamespacenvarchar60CHAR(N' ')Yes/AIF/T_NS/AIF/NS Allow NULL? 
58CUST_LOG_ENG_IDIdentifier for a Customer-Specific AIF Enginenvarchar200CHAR(N' ')Yes/AIF/T_ENGINES/AIF/CUSTOMER_ENGINE_ID Allow NULL? 
59MESTYPMessage Typenvarchar300CHAR(N' ')YesEDMSGEDI_MESTYP Allow NULL? 
60IDOCTPBasic typenvarchar300CHAR(N' ')YesEDBASEDI_IDOCTP Allow NULL? 
61CIMTYPExtensionnvarchar300CHAR(N' ')YesEDCIMEDI_CIMTYP Allow NULL? 
62MESCODLogical Message Variantnvarchar30CHAR(N' ')YesEDI_MESCOD Allow NULL? 
63MESFCTLogical message functionnvarchar30CHAR(N' ')YesEDI_MESFCT Allow NULL? 
64STATUSStatus Handlingnvarchar30NUMC(N'000')Yes/AIF/STATUS_HANDL Allow NULL? 
65END_DATEEnd Datenvarchar80DATS(N'00000000')Yes/AIF/END_DATE Allow NULL? 
66CLIENT_CONTRLAutomatic Client Control Indicator for Status Handlingchar10CHAR(N' ')Yes/AIF/CLIENT_CONTRL Allow NULL? 
67PRE_PROCESSINGPreprocessingchar10CHAR(N' ')Yes/AIF/PRE_PROCESSING Allow NULL? 
68PRX_METHODProxy Methodnvarchar300CHAR(N' ')Yes/AIF/PROXY_METHOD Allow NULL? 
69COMPONENTComponentnvarchar300CHAR(N' ')YesECHC_PROCESSESECH_DTE_COMPONENT Allow NULL? 
70BUSINESS_PROCESSBusiness Processnvarchar300CHAR(N' ')YesECHC_PROCESSESECH_DTE_PROCESS Allow NULL? 
NamePrimaryUniqueTypeColumns
/AIF/T_FINF~0YesYesCLUSTEREDIFVERSION, IFNAME, NS, MANDT