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

209 columns | Print definition?ERP 6.0  | FORM

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CCEE/SIFISTATE2Balances on accounts for SFR report6FORMFlag: active or passive reference?nvarchar10
2/CEECV/RO_ANN_FSRomania: Annual Financial Stat. data for XML merge report3FORMVersion Number Componentnvarchar20
3/SAPQUERY/TA02Flight customers4FORMForm of addressnvarchar150
4CNV_20100_CEFORMCEFORMF records with rel. org. units + addit. VALUE field6FORMnvarchar120
5CNV_20551_DELTABTables earmarked for dropping5FORMHow the Dictionary object is implemented in the databasenvarchar10
6CNV_LICENCETable of Objects for Encryption4FORMName of the used routinenvarchar300
7CNV_LIC_FORMSTable of Objects for Encryption3FORMName of the used routinenvarchar300
8EHFNDD_CHM_BINFOChemical - Basic Info10FORMFormnvarchar210
9FIGEOMC_REPFORMAssign PDF Form to Report (Oman)5FORMFormnvarchar70
10FITDKWC_FSCDEFForm Structure: Definition5FORMPDF-Based Forms: Form Namenvarchar300
11HRESS_T7GB_ESS_FHR GB ESS P60 form display settings7FORMForm Namenvarchar160
12HRESS_T7IE_ESS_FHR IE ESS P60 form display settings3FORMForm Namenvarchar160
13IDOM_CC_COMBAllowed combinations for Company Types (Oman)4FORMFormnvarchar70
14IDOM_CC_COMB_ACTAllowed activities for Forms-Final Tax Statemenet (Oman)2FORMFormnvarchar70
15IDOM_CC_COMPAdditional Company Code Parametres (Oman)6FORMFormnvarchar70
16IDSAU_FSCDEFForm Structure: Definition5FORMPDF-Based Forms: Form Namenvarchar300
17J_1I_EXIM_DOCSETEXIM : Document Set5FORMName of Form Objectnvarchar300
18J_3RFBS_PERIODFinancial statement forms: Fiscal periods2FORMFinancial Statement Form Numbernvarchar10
19J_3RFBS_VERVARFinancial Statement Versions Used in Balance Sheet Forms3FORMFinancial Statement Form Numbernvarchar10
20T390PM: Shop papers for print control6FORMForm Namenvarchar160
21T5ITUI_2User Data Table for Report / Legal Form2FORMReport indicator/legal formnvarchar100
22TKEPDCO-PA: Screen Catalog - Planning3FORMFormnvarchar120
23TTS_PRINT_WTPrinted Forms Assignment3FORMText (100 characters)nvarchar1000
TOPABAP Workbench, Java IDE and Infrastructure
24SCUSTOMFlight customers4FORMForm of addressnvarchar150
TOPAccount Determination
25TRSETReset Data Before Production Start-up7FORMDelete form routinenvarchar200
TOPArchiveLink
26TOACRAsynchronous ArchiveLink Requests19FORMSAP ArchiveLink: Output formatnvarchar160
TOPBasic Data
27TNT2IS-H: Struct. Def. for Data Transfer from Seq. Files9FORMIS-H: FORM Routine for Field Format Conversionnvarchar300
TOPBelgium
28T5BR1Scenarios of social risk declaration6FORMSubapplicationnvarchar40
TOPBudgeting
29FMEDDOCFORMSAssignment of Forms for Entry document4FORMName of Form Objectnvarchar300
30FMEDFORMS_WDAssignment of Forms for Entry document6FORMName of Form Objectnvarchar300
TOPCanada
31T5KYHYear end reporting History table9FORMForm namenvarchar40
TOPClinical System
32N2DTAPPL_ADOBEDocumen Category: ADOBE Form Data6FORMName of Form Objectnvarchar300
TOPCommunication Channel
33ICI_CCS_MONI_SUBCCS Monitoring - subscriptions6FORMCMSS Stringntext10737418230
TOPCost Center Accounting
34KPP0VCO planning: Assignment layout <-> validation5FORMFormnvarchar120
35KPP2DCO planning: directory of generated dumps6FORMFormnvarchar120
36KPP2KCO Planning Processor: Context of user configurations5FORMFormnvarchar120
TOPData Collection
37TKED1Library of results from data mining processing30FORMFormnvarchar120
TOPDenmark
38T5M5SInformation to PBS for Remuneration Statement2FORMKey for PBS Forms (DK)nvarchar20
TOPeCATT Extended Computer Aided Test Tool
39DEMO_SCUSTOMCreate Control Table Flight Customers4FORMForm of addressnvarchar150
TOPEmpties Management
40/BEV1/EMPARTPartner Function for Processing Empties11FORMForm Namenvarchar160
TOPExtra Charge
41/BEV1/ECCODEDialog Checks4FORMFormnvarchar300
TOPFinancial Accounting
42/CCEE/SIFISTATESBalances on accounts for SFR report6FORMFlag: active or passive reference?nvarchar10
43TFIREVReversal Document Checks in FI4FORMForm namenvarchar300
TOPFlexible Real Estate Management
44TIVCAECRE-FX: Currency Conversion - Relevant Tables and Fields6FORMName of a form routinenvarchar300
TOPForms Processing
45FPFONTREPLFont Replacement Form Processing1FORMName of Form Objectnvarchar300
TOPFrance
46T5F6MReturns Table (TDR)9FORMForms / Nature Edition Filenvarchar40
TOPGeneral Application Functions
47TABADREXITSDerivation: Internal Exits6FORM30 Charactersnvarchar300
TOPGeneral Object Relations
48SFLITPASSAttribute Table: Transit Passenger5FORMForm of addressnvarchar150
TOPGlobal Organization Customizing
49TCUSFCountry version external routines4FORMExternal form routine for RSCICO02nvarchar300
TOPGreat Britain
50T5GEF01HR-GB: filing - Store parsed recording coming in from GG4FORMHR eFiling Form Namesnvarchar100
51T5GEFDATAHR-GB: filing - Store Infotype data coming in from GG4FORMHR eFiling Form Namesnvarchar100
52T5GEFHWMefiling infcoming forms (Hiigh Water Mark ) register4FORMHR eFiling Form Namesnvarchar100
TOPIncentive and Commission Management ICM
53CACS_MAP1Assignment, Administration Subprograms9FORMDW: Subroutinesnvarchar300
54TCACS_PROCSSteps in the Commission Process Parts7FORMDW: Subroutinesnvarchar300
TOPInformation System
55T804CReport Writer: Special Fields5FORMRoutine for filling the fieldnvarchar300
TOPItaly
56T5IT30Events and reasons2FORMReport indicator/legal formnvarchar100
57T5IT31Text table for events and reasons3FORMReport indicator/legal formnvarchar100
58T5IT32Entity table for event/reason code2FORMReport indicator/legal formnvarchar100
59T5IT33Events and reasons2FORMReport indicator/legal formnvarchar100
60T5IT34Events and reasons2FORMSubapplicationnvarchar40
61T5ITANAnnotazioni per CUD2FORMCodice report /legal formnvarchar100
62T5ITUAUser Data Table of the Company for Report/ Legal Form2FORMReport indicator/legal formnvarchar100
63T5ITUBReport: report field mapping - output boxes2FORMReport indicator/legal formnvarchar100
64T5ITUDReport: report and attribution fields2FORMReport indicator/legal formnvarchar100
65T5ITUDTReport: field texts3FORMReport indicator/legal formnvarchar100
66T5ITUDT_CReport: field texts3FORMReport indicator/legal formnvarchar100
67T5ITUD_CReport: report and attribution fields2FORMReport indicator/legal formnvarchar100
68T5ITUEReporting factory configuration2FORMReport indicator/legal formnvarchar100
69T5ITUE_CReporting factory configuration2FORMReport indicator/legal formnvarchar100
70T5ITUFReport: definition2FORMReport indicator/legal formnvarchar100
71T5ITUFTReport: definition texts3FORMReport indicator/legal formnvarchar100
72T5ITUGUnified reporting: output generation2FORMReport indicator/legal formnvarchar100
73T5ITUG_CUnified reporting: output generation2FORMReport indicator/legal formnvarchar100
74T5ITUIUser Data Table for Report / Legal Form2FORMReport indicator/legal formnvarchar100
75T5ITUPReport: post-processing field step2FORMReport indicator/legal formnvarchar100
76T5ITUP_CReport: post-processing field step2FORMReport indicator/legal formnvarchar100
77T5ITUSReport: section2FORMReport indicator/legal formnvarchar100
78T5ITUSTReport: section text3FORMReport indicator/legal formnvarchar100
79T5ITUS_CReport: section2FORMReport indicator/legal formnvarchar100
TOPLocalization
80IDCN_FSCDEFForm Structure: Definition5FORMPDF-Based Forms: Form Namenvarchar300
81J_1BAANota Fiscal type7FORMForm of Nota Fiscalnvarchar40
82J_1BAQForm2FORMForm of Nota Fiscalnvarchar40
83J_1BAQTForm description3FORMForm of Nota Fiscalnvarchar40
84J_1BB2Nota Fiscal print configuration4FORMForm of Nota Fiscalnvarchar40
85J_1BB2DYNAMICNota Fiscal Print Configuration dependent on dynamic key4FORMForm of Nota Fiscalnvarchar40
86J_1BNFDOCNota Fiscal Header14FORMForm of Nota Fiscalnvarchar40
87J_1BNFENUMCHECKNF-e Number Range - Last checked Number4FORMForm of Nota Fiscalnvarchar40
88J_1BNFENUMGAPNF-e Numbering Gaps5FORMForm of Nota Fiscalnvarchar40
89J_1BNFE_ACTIVEElectronic Nota Fiscal: Actual Status29FORMForm of Nota Fiscalnvarchar40
90J_2IRG1BALOpening/Closing balance table for RG15FORMMaterial packaging form: Packed, Loosenvarchar10
91J_3RFBS_VERSIONFinancial Statement versions used in balance sheet forms2FORMFinancial Statement Form Numbernvarchar10
92J_3RFBS_XMLDELBalance sheet forms: XML-tags to be removed2FORMFinancial Statement Form Numbernvarchar10
93J_3RFBS_XMLDELTBalance sheet forms: XML-tags to be removed:Text table3FORMFinancial Statement Form Numbernvarchar10
TOPLogistics Basic Data
94WCMPSDDetails for Category Management Step10FORMPlanning Layoutnvarchar120
TOPMerchandise and Assortment Planning
95TWISPC_CUARetail Planning: Customer-specific CUA Status and Title4FORMPlanning Layoutnvarchar120
96TWISPC_DPLVARetail Planning: Manual Planning Variants4FORMPlanning Layoutnvarchar120
97TWISPC_DPLVATRetail Planning: Texts for Manual Planning Variants5FORMPlanning Layoutnvarchar120
98TWISPC_DPLVVRetail Planning: Default Parameters for Manual Plng Variants4FORMPlanning Layoutnvarchar120
99TWISPC_FCODESRetail Planning: Customer-specific CUA Functions4FORMPlanning Layoutnvarchar120
100TWISPC_TKES1LRetail Planning: Additional Information for Planning Layouts3FORMFormnvarchar120
101TWISPC_ZINTPLAssignment of Interfaces to Planning Layouts4FORMPlanning Layoutnvarchar120
102TWISPC_ZPSPLRetail Planning: Assign. Planning Layouts to Plan Steps4FORMPlanning Layoutnvarchar120
103TWISPS_LEADCOLUser-Specific Settings for Lead Columns2FORMPlanning Layoutnvarchar120
104TWISPS_NOPROMO1Parameters for Promotions Created in MAP14FORMPlanning Layoutnvarchar120
TOPMigration
105TEMGENFORMIS-U migration: report generation form parameters3FORMForm for report generationnvarchar300
TOPOpen Information Warehouse
106TMCMOIW Data Sources7FORMFormnvarchar120
TOPPatient Accounting
107TN23RIS-H: Rule Table for BDT Format5FORMIS-H: FORM Routine for BDT Rule Checknvarchar300
TOPPendulum List Indirect Sales
108/BEV4/PLCTPRPeriod split5FORMForm Routine to Be Performednvarchar300
TOPPension Administration
109T7PBSNO2BAssignment of Report & Formular to Notification6FORMSmart Forms: Form Namenvarchar300
TOPPersonnel Administration
110T5ITUTdelete me3FORMCodice report /legal formnvarchar100
TOPPersonnel Categories
111/ISDFPS/MAT_MVMTMaterial Movement Types per Action7FORMPDF-Based Forms: Form Namenvarchar300
TOPPersonnel Management
112/BKC/S21_CHKINFC&T! - Infotypes for additional authorization checks8FORMC&T! - Name of a form routinenvarchar300
113/BKC/S21_CPUSRTBC&T! - User exits for copy of tables in customer's namespace5FORMC&T! - Name of a form routinenvarchar300
114/BKC/S21_CUSREXC&T! - Definition of user exits for comparison programs5FORMC&T! - Name of a form routinenvarchar300
115/BKC/S21_EXT_FC&T! - Definition of external anonymization routines8FORMC&T! - Name of a form routinenvarchar300
116/BKC/S21_USREXC&T! - Definition of user exits for data conversion6FORMC&T! - Name of a form routinenvarchar300
117/OTEI/PF_TASREIMConnection of HCM PF and EFM documents3FORMInteractive Process & Forms documentnvarchar10
TOPPlant Maintenance
118PMPLPM: Print log7FORMForm Namenvarchar160
TOPProfile Maintenance
119TPFYPROPTYParameter attributes11FORMName of form routine for checking profile parameternvarchar300
TOPProfitability Analysis
120CEFORMACO: Change History for Row/Column Structure5FORMFormnvarchar120
121CEFORMCRPT: History of formatting changes to elements5FORMFormnvarchar120
122CEFORMETable of descriptions of element structures5FORMFormnvarchar120
123CEFORMFCO: Definition of contents of element in row/col.str.5FORMFormnvarchar120
124CEFORMSTable for description of structures5FORMFormnvarchar120
125CEFORMTTable for Report Painter Row and Column Texts6FORMFormnvarchar120
126CEFORMVCO: Variables for row/column structure5FORMFormnvarchar120
127CEFORMWCO: Row/Column Structure Variable Texts6FORMFormnvarchar120
128CEPRINTTable for description of print statement for CO-PA forms5FORMFormnvarchar120
129CESETSSet Administration in the Report Painter5FORMFormnvarchar120
130TKEB1Report Management25FORMFormnvarchar120
131TKEBSRow/column structures5FORMFormnvarchar120
132TKEEXITSCO-PA Internal Exits6FORM30 Charactersnvarchar300
133TKEHA_VFIELDHANA Analytic View Keyfigures5FORMFormnvarchar120
134TKEP1CO-PA planning table for special fields5FORMFormnvarchar120
135TKEP2CO-PA planning of special fields5FORMFormnvarchar120
136TKES1Row/column structures5FORMFormnvarchar120
137TKES2Text Table for Row/Column Structure6FORMFormnvarchar120
138TKES3Text variables for definition of row/column str.5FORMFormnvarchar120
139TKES4CO Row/Column Structure: Logical Pages5FORMFormnvarchar120
140TKES5Text Table for TKES46FORMFormnvarchar120
141TKESKCO: Folder of key figures for row/column structure5FORMFormnvarchar120
TOPPublic Sector Contract Accounts Receivable and Payable
142DFMCA_FORMSData Table for Tax Forms3FORMForm for ISR Scenarionvarchar300
TOPRegulatory reporting for insurance companies
143ISSR_CUST_HD_DECustomer report header format for DE6FORMReport header field format (c-char b-blank)nvarchar300
TOPRemaining Beverage - Obsolete Objects
144/BEV1/RBFORMTable for Form Selection (Print Program) per Agreement4FORMForm Routine in Print Programnvarchar300
145/BEV3/CHCA_ABException Handling: Programs for Exception Handling6FORMForm Routine to Be Performednvarchar300
146/BEV3/CHCA_MDTXException Handling: Valuation Modules - Texts3FORMForm Routine to Be Performednvarchar300
147/BEV3/CHCA_MODException Handling: Valuation Modules3FORMForm Routine to Be Performednvarchar300
148/BEV3/CHCPRTSTRTProgram assignment of document print strategies4FORMForm Routine to Be Performednvarchar300
149/BEV3/CHCTAAMODSettlement Information Module6FORMForm Routine to Be Performednvarchar300
150/BEV3/CHCTABZPKTFrom time: Control ID of item within a period4FORMForm Routine to Be Performednvarchar300
151/BEV3/CHCTPRPeriod split5FORMForm Routine to Be Performednvarchar300
152/BEV3/CHCTREGRule Class, Coding Assignment6FORMForm Routine to Be Performednvarchar300
153/BEV3/CHCTWSBSTRValue Date: Customizing Basic Value Date Strategy4FORMForm Routine to Be Performednvarchar300
154/BEV3/CHCTWSFINDValue date: Value date formula determination4FORMForm Routine to Be Performednvarchar300
155/BEV3/CHCTWSSTRValue Date: Customizing Value Date Strategy4FORMForm Routine to Be Performednvarchar300
TOPReporting
156P05T_XML_VERSIONWage Return: Versions5FORMName of the Subroutinenvarchar300
157T77PRNL_XML_VPension Return: XML Versions6FORMName of the Subroutinenvarchar300
TOPResourcen Management
158RMSLA_FORM_NUTRSort and Indent Nutrients4FORMPDF-Based Forms: Form Namenvarchar300
159RMSLA_FORM_TABRelevant PDF Forms2FORMPDF-Based Forms: Form Namenvarchar300
160RMSLA_FORM_TABTDescription of PDF-Based Print Forms3FORMPDF-Based Forms: Form Namenvarchar300
161RMSLA_FORM_TXTBText Modules for PDF-Based Print Form3FORMPDF-Based Forms: Form Namenvarchar300
162RMSLA_FORM_TXTBTLanguage-Dependent Texts for PDF Form4FORMPDF-Based Forms: Form Namenvarchar300
163RMSLA_PALIHeader Data of Package Label List8FORMPDF-Based Forms: Form Namenvarchar300
164RMSLC_FORM2_TABRelevant PDF Forms EHP62FORMPDF-Based Forms: Form Namenvarchar300
165RMSLC_FORM2_TABTDescription of PDF Forms EHP63FORMPDF-Based Forms: Form Namenvarchar300
166RMSLC_FORM2_TXTBText Modules for PDF Form EHP62FORMPDF-Based Forms: Form Namenvarchar300
167RMSLC_FORM_NUTRSort and Indent Nutrients3FORMPDF-Based Forms: Form Namenvarchar300
168RMSLC_FORM_TABRelevant PDF Forms2FORMPDF-Based Forms: Form Namenvarchar300
169RMSLC_FORM_TABTDescription of PDF Forms3FORMPDF-Based Forms: Form Namenvarchar300
170RMSLC_FORM_TXTBText Modules for PDF Form3FORMPDF-Based Forms: Form Namenvarchar300
171RMSLC_FORM_TXTBTLanguage-Dependent Texts for PDF Form2FORMPDF-Based Forms: Form Namenvarchar300
TOPReuse Services for Country Development
172T50F0HR-FORMS: Assignment of Standard Texts to Forms4FORMForm Namenvarchar160
173T799BHRF01Report: definition3FORMSubapplicationnvarchar40
174T799BHRF02HRF Report sections3FORMSubapplicationnvarchar40
175T799BHRF02CHRF Report customer sections3FORMSubapplicationnvarchar40
176T799BHRF02THRF Report sections texts4FORMSubapplicationnvarchar40
177T799BHRF03HRF Report fields3FORMSubapplicationnvarchar40
178T799BHRF03CHRF Report customer fields3FORMSubapplicationnvarchar40
179T799BHRF03THRF Report fields texts4FORMSubapplicationnvarchar40
180T799BHRF04HRF Report output generation3FORMSubapplicationnvarchar40
181T799BHRF04CHRF Report customer output generation3FORMSubapplicationnvarchar40
182T799BHRF05HRF Factory configuration3FORMSubapplicationnvarchar40
183T799BHRF05CHRF Factory customer configuration3FORMSubapplicationnvarchar40
184T799BHRF06HRF Report Post Processing3FORMSubapplicationnvarchar40
185T799BHRF06CHRF Report Customer Post Processing3FORMSubapplicationnvarchar40
TOPRuntime Analysis
186SATR_FCODES_FORMSATR: Assignment of FCODES to Form Routines2FORMCalling Programnvarchar400
TOPSAP Healthcare - Industry-Specific Components for Hospitals
187NLVERZF_001NL-COLL_BILL: Smart-form4FORMSmart Forms: formuliernaamnvarchar300
TOPSAP Internet Transaction Server
188ITS_STYLEScontains different styles for generator53FORMnvarchar250
TOPSerial Numbers
189T377XDocuments Allowed for Serial Number Management7FORMName of the ABAP Form Routinenvarchar300
TOPStaffing
190T777NName Format9FORMSubroutine namenvarchar300
TOPStatements
191T50FGStatement Parameters4FORMPDF Formnvarchar300
TOPSyntax, Compiler, Runtime
192SAMTESAMT: Information about tasks3FORMSAMT: (External) subroutinenvarchar300
193SAMTXSAMT: (Language-specific) texts about tasks3FORMSAMT: (External) subroutinenvarchar300
TOPTraining and Event Management
194T77VCText Variable Editing5FORMSubroutine namenvarchar300
TOPUSA
195BRCDTABSI-TAX 4.0 BRCDTA12FORMBSI40: FORMnvarchar10
196BRCGDTABSI-TAX 4.0 BRCGDTA12FORMBSI40: FORMnvarchar10
TOPWork Clearance Management
197WCAPLWCM: Print Log8FORMForm Namenvarchar160
198WCCLWCM: Print6FORMForm Namenvarchar160
TOPWorkforce Management Application
199WFAFC_IND_TDATATime relative data associated with an indicator5FORMStat Formnvarchar20
200WFAFC_OBJ_STATObject Stat for Configuration6FORMStat Formnvarchar20
201WFAFC_SAMPLE2Forecasting Sample3FORMStat Formnvarchar20
202WFAFC_STATStat3FORMStat Formnvarchar20
203WFA_WRKA_HISTWork Area Attributes26FORMStat Formnvarchar20
TOPWorkforce Management Core
204WFMCAS_WRKA_HISTWork Area Attributes26FORMStat Formnvarchar20
205WFMCAS_WRK_COVERWork Coverage Rule - OBSOLETE12FORMStat Formnvarchar20
206WFMFC_OBJ_STATObject Stat for Configuration6FORMStat Formnvarchar20
207WFMFC_SAMPLEForecasting Sample - OBSOLETE3FORMStat Formnvarchar20
208WFMFC_SAMPLE2Forecasting Sample3FORMStat Formnvarchar20
209WFMFC_STATStat3FORMStat Formnvarchar20