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
Financials :: Financial Supply Chain Management :: Dispute Management :: Basic Functions
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0UDMCASEATTR10362Dispute Case Attribute for Account Balance (FI-CA)Basic Functions
SQL:  selectupdate insert create

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

SELECT MANDT, CASE_GUID, FICA_GPART, FICA_VKONT, FICA_VTREF, FICA_APPLK, FICA_SUBAP, FICA_DISPUTED_AM, FICA_TOTALINV_AM, FICA_TOTALCOR_AM, FICA_REVERSED_AM, FICA_CREDITED_AM, FICA_WRITEOFF_AM, FICA_REPLACED_AM, FICA_PAID_AM, FIN_DISPUTE_CURR, FIN_RFC_CREATOR, FIN_LOG_SYSTEM, FIN_PROC_SEQNR, FICA_INT_REASON, FIN_BUKRS, FIN_COORDINATOR, FIN_ROOT_CCODE, FIN_DUE_DATE, FIN_CONTACT_NAME, FIN_CONTACT_MAIL, FIN_CONTACT_TEL, FIN_CONTACT_FAX, FIN_CONTACT_FAXC, FICA_CONTACT_KEY, FIN_ORIGIN, FIN_STAT_PARA, FICA_INFO1, FICA_DATE1, FICA_INTKY, FIN_EXTAPPL_PRO FROM UDMCASEATTR10
ColumnFieldDescriptionSQL TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')No*MANDT Allow NULL? 
2CASE_GUIDUUID in character formnvarchar320CHAR(N' ')NoSYSUUID_C Allow NULL? 
3FICA_GPARTBusiness Partnernvarchar100CHAR(N' ')Yes*FICA_GPART Allow NULL? 
4FICA_VKONTContract Accountnvarchar120CHAR(N' ')YesFICA_VKONT Allow NULL? 
5FICA_VTREFContract Referencenvarchar200CHAR(N' ')YesFICA_VTREF Allow NULL? 
6FICA_APPLKFI-CA Application Areachar10CHAR(N' ')YesFICA_APPLK Allow NULL? 
7FICA_SUBAPSubapplication in Contract Accounts Receivable and Payablechar10CHAR(N' ')YesFICA_SUBAP Allow NULL? 
8FICA_DISPUTED_AMDisputed Amountdecimal152CURR((0))YesFICA_DISPUTED_AMT
9FICA_TOTALINV_AMTotal Receivable (for Business Partner)decimal152CURR((0))YesFICA_TOTALINV_AMT
10FICA_TOTALCOR_AMTotal Correction (for Business Partner)decimal152CURR((0))YesFICA_TOTALCOR_AMT
11FICA_REVERSED_AMAmount Reverseddecimal152CURR((0))YesFICA_REVERSED_AMT
12FICA_CREDITED_AMAmount Crediteddecimal152CURR((0))YesFICA_CREDITED_AMT
13FICA_WRITEOFF_AMAmount Written Offdecimal152CURR((0))YesFICA_WRITEOFF_AMT
14FICA_REPLACED_AMAmount Replaced (New Receivable)decimal152CURR((0))YesFICA_REPLACED_AMT
15FICA_PAID_AMTotal Payments Received since Creation of Casedecimal152CURR((0))YesFICA_PAID_AMT
16FIN_DISPUTE_CURRCurrency of Dispute Casenvarchar50CUKY(N' ')YesTCURCUDM_DISPUTE_CURR Allow NULL? 
17FIN_RFC_CREATORUser That Created the Dispute Case via RFCnvarchar120CHAR(N' ')Yes*UDM_RFC_CREATOR Allow NULL? 
18FIN_LOG_SYSTEMLogical systemnvarchar100CHAR(N' ')Yes*LOGSYS Allow NULL? 
19FIN_PROC_SEQNRSequential Number of Processnvarchar30NUMC(N'000')YesUDM_PROC_SEQNR Allow NULL? 
20FICA_INT_REASONFI-CA: Internal Dispute Typenvarchar40CHAR(N' ')YesUDM_FICA_REASONFICA_INT_REASON Allow NULL? 
21FIN_BUKRSCompany Codenvarchar40CHAR(N' ')Yes*BUKRS Allow NULL? 
22FIN_COORDINATORCoordinator of Dispute Casenvarchar120CHAR(N' ')Yes*UDM_COORDINATOR Allow NULL? 
23FIN_ROOT_CCODERoot Cause Codenvarchar40CHAR(N' ')YesUDMATTR_RCCODEUDM_ROOT_CCODE Allow NULL? 
24FIN_DUE_DATEProcessing Deadlinenvarchar80DATS(N'00000000')YesUDM_DUE_DATE Allow NULL? 
25FIN_CONTACT_NAMEName of Contact Person at Business Partnernvarchar400CHAR(N' ')YesUDM_CONTACT_NAME Allow NULL? 
26FIN_CONTACT_MAILe-mail Address of Contact Person at Business Partnernvarchar1280CHAR(N' ')YesUDM_CONTACT_EMAIL Allow NULL? 
27FIN_CONTACT_TELTelephone Number of Contact Person at Business Partnernvarchar300CHAR(N' ')YesUDM_CONTACT_PHONE Allow NULL? 
28FIN_CONTACT_FAXFax Number of Contact Person at Business Partnernvarchar300CHAR(N' ')YesUDM_CONTACT_FAX Allow NULL? 
29FIN_CONTACT_FAXCCountry of Fax Numbernvarchar30CHAR(N' ')YesT005UDM_CONTACT_FAXC Allow NULL? 
30FICA_CONTACT_KEYCorrespondence Key in Dispute Managementnvarchar430CHAR(N' ')YesFICA_CONTACT_KEY Allow NULL? 
31FIN_ORIGINOrigin of Dispute Casenvarchar20CHAR(N' ')YesUDM_FIN_ORIGIN Allow NULL? 
32FIN_STAT_PARACase: System Statusnvarchar30CHAR(N' ')YesSCMGSTATPARA Allow NULL? 
33FICA_INFO1Additional Specification for Dispute Casenvarchar500CHAR(N' ')YesFICA_INFO1 Allow NULL? 
34FICA_DATE1Transaction Date for Dispute Casenvarchar80DATS(N'00000000')YesFICA_DATE1 Allow NULL? 
35FICA_INTKYFI-CA: Number of Dispute Casenvarchar120CHAR(N' ')YesFICA_INTKY Allow NULL? 
36FIN_EXTAPPL_PROProcessing by External Applicationnvarchar40CHAR(N' ')Yes*UDM_EXTAPPL_PRO Allow NULL? 
NamePrimaryUniqueTypeColumns
UDMCASEATTR10~0YesYesCLUSTEREDMANDT, CASE_GUID
UDMCASEATTR10~COONoNoNONCLUSTEREDMANDT, FIN_COORDINATOR, FIN_STAT_PARA