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
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
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

50 columns | Print definition?ERP 6.0  | ABTYP

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFMCA_OBT_HISStorage of Lean Trace history for object based tax10ABTYPRevenue Typenvarchar40
2T5DPBS3FAbsence Categories for Pay Scale Level Increase2ABTYPAbsence Category for Pay Scale Level Increasenvarchar200
3T5DPBS3FTAbsence Categories for Pay Scale Level Increase (Texts)3ABTYPAbsence Category for Pay Scale Level Increasenvarchar200
4T5DPBS3GAssignment of Absence to Absence Category6ABTYPAbsence Category for Pay Scale Level Increasenvarchar200
5T672Conditions: View Sequence4ABTYPCategory of the rebate agreementnvarchar10
6TFMCA_BRFP_OBTBRFplus Function for Object-Based Revenue Types2ABTYPRevenue Typenvarchar40
TOPCollectionsDisbursements
7TKKVBAKTBanks for Payment3ABTYPOrigin Area of a Payment Formnvarchar20
8TKKVSLARTSelection Type for Clearing3ABTYPOrigin Area of a Payment Formnvarchar20
9VVKKFAPOSInvoicing Items in FS-CD7ABTYPOrigin Area of a Payment Formnvarchar20
TOPCommunication
10TN21Y_SE_MAPIS-H: Mapping table for Billing Categories for Indiv. Contro3ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
TOPConditions
11KONAAgreements9ABTYPCategory of the rebate agreementnvarchar10
12T6B1Rebate : Rebate Agreement Types4ABTYPCategory of the rebate agreementnvarchar10
TOPJust-In-Time Processing
13JITHDCall header11ABTYPCall Typenvarchar10
14JITQUNumber of Calls3ABTYPCall Typenvarchar10
TOPPatient Accounting
15NVBRPIS-H: Billing document item data79ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
16TN21XIS-H: Text For Individual Billing Categories4ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
17TN21YIS-H: Billing Categories for Indiv. Control of Billing3ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
TOPPatient Management
18NLEIIS-H: Services Performed74ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
TOPPersonnel Administration
19T503Employee Group/Subgroup5ABTYPEmployee subgroup grouping for primary wage tpyesnvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
20DFMCA_BRF850##BRF: Derive inco type from form type10ABTYPBRF: Expressionnvarchar200
21DFMCA_BUPR_TAData Table for Tax Advisor Relationships3ABTYPRevenue Typenvarchar40
22DPSOB_BILLTRIGTrigger for TRM Billing6ABTYPRevenue Typenvarchar40
23TFMCA_BRFEVENTAssign Revenue Types to BRF Events2ABTYPRevenue Typenvarchar40
24TFMCA_FORMTYPECustomizing Table for Form Types2ABTYPRevenue Typenvarchar40
25TFMCA_FORMTYPETCustomizing Table for Language-Dependent Texts Form Types3ABTYPRevenue Typenvarchar40
26TFMCA_INCORR_RLTime-Dependent Definition of Enhanced Inbound Correspondence5ABTYPRevenue Typenvarchar40
27TFMCA_LINKSCustomizing Table for Links2ABTYPRevenue Typenvarchar40
28TFMCA_LINKSTCustomizing Table for Language-Dependent Texts for Services3ABTYPRevenue Typenvarchar40
29TFMCA_PREPAYMain and Subtransaction for Open Items3ABTYPRevenue Typenvarchar40
30TFMCA_RC2REVReason Code Link <--> Revenue Types3ABTYPRevenue Typenvarchar40
31TFMCA_REFUNDMain/Subtransaction for Refund Items3ABTYPRevenue Typenvarchar40
32TFMCA_REMINDERReminder Letter for Inbound Corresp.5ABTYPRevenue Typenvarchar40
33TFMCA_REV2FPFFPF: relationship between revenue type and form bundle type2ABTYPRevenue Typenvarchar40
34TFMCA_REV2PERDefine Tax Periods for Revenue Types2ABTYPRevenue Typenvarchar40
35TFMCA_REV2PSOBDefine Revenue Types for Contract Object Types2ABTYPRevenue Typenvarchar40
36TFMCA_REVTYPERevenue Types2ABTYPRevenue Typenvarchar40
37TFMCA_REVTYPETTexts Revenue Types3ABTYPRevenue Typenvarchar40
38TFMCA_SERVICESCustomizing Table for Services2ABTYPRevenue Typenvarchar40
39TFMCA_SERVICESTCustomizing Table for Language-Dependent Text for Services3ABTYPRevenue Typenvarchar40
40TFMCA_STATLIMStatute of Limitation2ABTYPRevenue Typenvarchar40
41TFMCA_TRANSTYPESTransaction Type for Tax Processing2ABTYPRevenue Typenvarchar40
TOPSAP Healthcare - Industry-Specific Components for Hospitals
42NCH10IS-H CH: Service Breakdown5ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
43NCH10TIS-H CH: Service Breakdown Text6ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
44NCH41IS-H CH: Service Rules Service Breakdown12ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
45NCH42IS-H CH: Service Rules Service Maximum Values13ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
46NTPKCH_MAXIS-H CH: Zuordng Leistamm Schweiz (TARMED) => Maximumregel5ABTYPIS-H: categoria fattur. per controllo indiv. fatturazionenvarchar40
47NWCHLS_RNLSRIS-H CH: ALIS-Fehlerhandlung - Leistungen (RNLSR)65ABTYPIS-H: categoria fattur. per controllo indiv. fatturazionenvarchar40
48TNWCH108Charge Factor Value Determination for Fee Billing8ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
49TNWCH80IS-H CH: Charge Factor Value Determination15ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40
50TNWCH91Items for Fee Relevance11ABTYPIS-H: Billing Category for Individual Billing Controlnvarchar40