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
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

173 columns | Print definition?ERP 6.0  | FLAG

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BI0/SFLAGMaster Data IDs: InfoObject Indicator, Flag1FLAGIndicator, Flagnvarchar10
2/SAPSLL/EBP_ACTSLL: Pre.Sys. EBP: Contr.: Call Customs Server4FLAGIndicator: Call Legal Services with Document Typenvarchar10
3BBPORGUSR2Parallel Table for BBPORGUSR5FLAGnvarchar320
4CNVCMIS_A_1_LDBDAdministration information for LDB17FLAGFlag for selection screen descriptionvarbinary10
5CNVC_SCWB_AUTHTable for authorization check2FLAGSingle-Character Indicatornvarchar10
6CNV_ICWB_UT_APPLApplication table for iCWB unit tests4FLAGGeneral Flagnvarchar10
7CNV_ICWB_UT_STAGStaging table for iCWB unit tests5FLAGGeneral Flagnvarchar10
8DMC_IU_E071KMWB Upgrade: Table E071K13FLAGGeneral Flagnvarchar10
9DMC_MDS_SOBJKIUUC: dyn maint event saving of e071k for logical w/o aim12FLAGGeneral Flagnvarchar10
10GRACIDMRESPResponse data14FLAGGrac flag for manual provisioningnvarchar10
11HRP5500Database Table for Infotype 550018FLAGGeneral Flagnvarchar10
12MDS_E071KMDS: E071K to a specific simulation version13FLAGGeneral Flagnvarchar10
13OCS_CP_E071KTLOGO E071K für CP TR: Schlüsseleinträge12FLAGallgemeines flagnvarchar10
14OCS_CP_E071K_STRTLOGO E071K_STR für CP TR: Schlüsseleinträge mit Strngfelder12FLAGallgemeines flagnvarchar10
15OCS_CP_PAT07TLOGO PAT07 für Correction Packages Patch Voraussetzungen8FLAGPAT07: Indikatornvarchar10
16OCS_CP_PAT08TLOGO PAT08 für Correction Package Erwtrte. Patch-Attribute5FLAGPAT07: Indikatornvarchar10
17P2RP_MFHR-PT: Payroll Results: Membership fees17FLAGNot used (length 1)nvarchar10
18P2RP_SCRTHR-PT: Cumulated result table (Legal entity dependent)16FLAGNot used (length 1)nvarchar10
19PA3376HR Master Record: Infotype 337629FLAGGeneral Flagnvarchar10
20PQDATAPureQuantify Daten7FLAGVerifikation : Datenflag Text/Integernvarchar10
21SCTS_TRACK_KEYcCTS: Helper for key persistence for object level tracking8FLAGGeneral Flagnvarchar10
22T5QT1Australia Tax - Calculation methods11FLAGApplicable for solutionnvarchar10
23T5QT6Australia Tax - Gross formation based on processing classes7FLAGApplicable for solutionnvarchar10
24TDDATMaintenance Areas for Tables4FLAGFlag for internal tablenvarchar10
25TDWAIInternal SAP Document Types2FLAGDocument Management Flagnvarchar10
26TILM_STOR_POOLILM DB Store: Management of Pool Tables5FLAGILM Storage: Properties of a Pool Entrynvarchar10
27TXMI_USAGEInformation About Activities of XMI Tools10FLAGSingle-Character Indicatornvarchar10
28ZSSAUTHCHKTable for auth. check in Crystal Info/Crystal Reports5FLAGCHAR01 data element for SYSTnvarchar10
TOPABAP Test Frameworks ATC, CheckMan, Code Inspector
29CRMPRIOCLOBSOLETE2FLAGYes/No Indicatornvarchar10
TOPAddress ManagementBusiness Address
30SADRAddress Management: Company Data26FLAGCheckboxnvarchar10
TOPALE Integration Technology
31TBDSSMapping of Segments to DDIC Structures4FLAGGeneral Flagnvarchar10
TOPAP-LIM Logistics Inventory Management Engine
32/LIME/GEN_IDXCOLGeneration Information for LIME Index Tables7FLAGnvarchar10
TOPApplication Framework
33MDG_TR_E071KObject List for Client Copy (Key)13FLAGGeneral Flagnvarchar10
TOPAustria
34T5A1ZELDA: Check Table for Dereg. Reason and End of Employment5FLAGIndicator for Test Proceduresnvarchar10
35T5A1Z_PBSELDA: Check Table for Dereg. Reason and End of Employment5FLAGIndicator for Test Proceduresnvarchar10
TOPBasis Components
36/CRYSTAL/AUTHCHKAuthorization check entries6FLAGCHAR01 data element for SYSTnvarchar10
37ZDS400_HEAD2Tabelle für Beispielprogramm des ZDS4004FLAGLöschkennzeichen im Einkaufsbelegnvarchar10
TOPBrazil
38PA0738Alimony adjustment for Brazil32FLAGIndicator for adjustment in the next payroll runnvarchar10
TOPBusiness Configuration Sets
39SCPRACTWBC Set: Active Values in Local System5FLAGBC Set: Additional Infonvarchar30
40SCPRDATABC Set: Values7FLAGBC Set: Additional Infonvarchar30
41SCPRDATACBC Set: Values5FLAGBC Set: Additional Infonvarchar30
42SCPREXCPTBC Set: Control Table for Exceptions5FLAGBC Set: General Flagnvarchar10
43SCPRFLAGBC Sets: Specially flagged BC Sets2FLAGBC Set: BC Set flagnvarchar10
44SCPRSVALLSwitch BC Set: Values (Language-Dependent)7FLAGBC Set: Additional Infonvarchar30
45SCPRSVALSSwitch BC Set: Values6FLAGBC Set: Additional Infonvarchar30
46SCPRVALLBC Set: Values (language-dependent)7FLAGBC Set: Additional Infonvarchar30
47SCPRVALSBC Set: Values6FLAGBC Set: Additional Infonvarchar30
TOPBusiness Package for Manager Self-Service FI
48FPB_EXP_SRVOTYPExpress Planning: Object Types and Planning Services Allowed4FLAGUse of Planning Servicenvarchar10
49FPB_EXP_SRVOTYPSExpress Planning: Object Types and Planning Services Allowed3FLAGUse of Planning Servicenvarchar10
50FPB_MONRULE_ROLECustomizing Rule Maintenance: Which Monitors are Displayed5FLAGGeneral Flagnvarchar10
TOPBusiness Planning and Simulation
51UPWB_HIERARCHYTable of Class Hierarchy3FLAGFlag for Inclusion, Exclusionnvarchar10
TOPCampaign Weighing and Dispensing
52CWD_CRD_SCALECampaign Weighing Control Recipe Dest. to Scale mapping5FLAGCampaign Weighing Indicatornvarchar10
53CWD_MATERIALCampaign Weighing Component Materials4FLAGCampaign Weighing Indicatornvarchar10
TOPCentral Functions Jurisdiction CodeTaxes
54TAX_TXJCD_FLAGProcess Logic Control for Jurisdiction Code Determination1FLAGField of length 16nvarchar160
TOPClasses
55TCOBJHelp table for optimization reports (INTERNAL USE ONLY!)5FLAGCharacter Field Length 1nvarchar10
TOPClinical System
56N2PROPERTYBAGIS-H*MED: Property Bag7FLAGCHAR01 data element for SYSTnvarchar10
57N2PROPERTYBAG_SHIS-H*MED: Property Bag6FLAGCHAR01 data element for SYSTnvarchar10
TOPContract Accounts Receivable and Payable
58TFKZWEXExceptiions for Doubtful Entries/Individual Value Adjustment5FLAGActivation Type for Exceptionnvarchar10
TOPContract Billing
59EMDUSDIFASSINFormula Allocation for Input Parameters6FLAGIndicatornvarchar10
60EMDUSDRQINPUTInput Parameters for Subrequest9FLAGIndicatornvarchar10
TOPCross-Application Components
61FRE_MD_PRODUCTObjects sent to F&R as Product5FLAGNew Input Valuesnvarchar10
TOPCustomizing Tools Techniques
62ZC010List of streets for france2FLAGGeneral Flagnvarchar10
TOPData Staging
63AUNIT_PSA_MD_CPCommunication of Parallel Processes in Test5FLAGnvarchar10
TOPDefault Risk and Limit System
64KLREGDEFDefinition of Variable Assignment Rule3FLAGCalculation Base for NPV/Nominal Amount Determinationnvarchar20
TOPDenmark
65T5MCCCluster Memory Table5FLAGCheckboxnvarchar10
TOPDocumentation Tools
66THLPXDocumentation: Transactions Without Links to Books2FLAGCHAR01 data element for SYSTnvarchar10
TOPEnd User Technology
67RSRCURRDISPAlternative Currency Display in BEx3FLAGCurrency Before/After Valuenvarchar10
TOPERP related topics
68/MRSS/LOCA_CHKRegional Flag to hide Candidate home city,region,postal code3FLAGGeneral Flagnvarchar10
TOPFinancials Basis
69FINB_TR_E071KObject List for Client Copy (Key)13FLAGGeneral Flagnvarchar10
TOPFramework
70CRMD_IC_XMLCOMComponent ID for XML storage for IC application2FLAGCustomizing Flag for Componentsnvarchar10
TOPFunds Management
71FMFG_HEAD_INVHeader Data for Improper Invoices7FLAGIndicator: No outstanding reason code(s) existnvarchar10
72FMLGD_H_VTYPXCheck Table for Posting Type and Account Assignment Method3FLAGError Account Assignmentnvarchar10
73FMLGD_H_VTYPXTText Table for FMLGD_H_VTYPX4FLAGError Account Assignmentnvarchar10
TOPGeneral Ledger Accounting
74FAGLSKF_CUSTFLDList of Fields in Customer Includes4FLAGField Is Filled During Postingsnvarchar10
TOPGRC Access Control Plug-In
75/VIRSA/FFREAACTReason/Activity Data3FLAGSingle-Character Indicatornvarchar10
TOPHelp Infrastructure for ABAP
76SAPGUIHC_LINKSTHelp Center: Document Texts4FLAGBTFR Indicatornvarchar10
77SAPGUIHC_NOTESHelp Center: 'My Notes'9FLAGBTFR Indicatornvarchar10
78SAPHC_LINKS_TEXTHelp Center: Texts for Documents5FLAGText Taken From Solution Managernvarchar10
TOPIntegration Customer Relationship Management
79ESIMCHAR_1Simulation Characteristics8FLAGIndicatorsnvarchar10
TOPKnowledge Warehouse
80IWR3LRESResults of Help Links Check34FLAGUse favorites flagnvarchar10
TOPLocal Currency Changeover
81EWUCMPTables for Which a CMP Client Copy is Made9FLAGGeneral Flagnvarchar10
TOPLogical DB, Selection Screens, Selection Variants
82LDBDAdministration information for LDB13FLAGFlag for selection screen descriptionvarbinary10
TOPLogistics - General
83CPSTOCKResult list for stock information for MSA5FLAGCritical Flagnvarchar10
TOPMaintenance Processing
84/MRSS/RM_RATE_TResource Management K-Rate Table3FLAGGeneral Flagnvarchar10
TOPManagement of Internal Controls
85FOPCCUSTOMIZING1Indicator2FLAGIndicatornvarchar200
86FOPCCUSTOMIZING2Rating Requiring Issue To Be Reported2FLAGIndicatornvarchar200
87FOPCCUSTOMIZINGTTexts: Indicator3FLAGIndicatornvarchar200
TOPManufacturing Execution System
88/SAPHT/MESEXITMES SPC IBU exit flag setup4FLAGMES SPC IBU exit turn on off flagnvarchar10
TOPMaterial Master
89WGDS_LOG_SUBCWGDS Log Subscription11FLAGWGDS Subscription Flagnvarchar120
90WGDS_SUBSCRIPSWGDS Subscriptions5FLAGWGDS Subscription Flagnvarchar120
TOPMigration
91TIG02Immobilien gew.: Flächenarten2FLAGPinta-alalajitnvarchar40
92TIG02TImmobilien gew.: Flächenartentext3FLAGPinta-alalajitnvarchar40
93TIG06Immobilien gew.: zul. Flächenart je Flächentyp4FLAGPinta-alalajitnvarchar40
94TIG09Immobilien gew.: zulässige Konditionsarten je Flächenart2FLAGPinta-alalajitnvarchar40
95TIG14Zulässige Zuordnungsverfahren pro gewerblicher Flächenart2FLAGPinta-alalajitnvarchar40
96VIGWFLBWImmobilien gew.: Flächen-Bewertungen (zeitabh.)3FLAGPinta-alalajitnvarchar40
97VIGWFLBW_FImmobilien gew.: Flächen-Bewertungen Stammdaten3FLAGPinta-alalajitnvarchar40
98VIGWFLBW_MImmobilien gew.: Flächen-Bewertungen (zeitabh.)3FLAGPinta-alalajitnvarchar40
99VIGWFLKGImmobilien gew.: Flächen-Kenngrössen (zeitabh.)3FLAGPinta-alalajitnvarchar40
100VIGWVOBWImmobilien gew.: Vorbelegung d.Konditionen f. BuKr/WE/GE/G6FLAGPinta-alalajitnvarchar40
101VIGWVOBW_UPDImmobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.6FLAGPinta-alalajitnvarchar40
102VIGW_VOBWCRE Ph.2.1 neu: Vorbelegung d.Konditionen f. BuKr/WE/GE/GR6FLAGPinta-alalajitnvarchar40
103VIGW_VOBW_UPDImmobilien gew.: Änderungsprotokoll der Konditionsvorbeleg.6FLAGPinta-alalajitnvarchar40
TOPMonitoring
104ALPFREP_DATTable for PerfDB Report Data4FLAGSingle-Character Indicatornvarchar10
TOPNon Profit Organizations
105HRP1080DB Table for Infotype 108019FLAGClassification Flagnvarchar10
106T7UNPAD_EGEXPMGTNPO: Expense Management Table44FLAGCheckboxnvarchar10
TOPOnline Correction Support Support Package and Add-On Tools
107PAD71KKeys of Table Entries Contained in a Patch12FLAGGeneral Flagnvarchar10
108PAT07Support Package Prerequisites8FLAGPAT07: Flagnvarchar10
109PAT07_ACPImport Prerequisites for Packages Referenced by ACP9FLAGPAT07: Flagnvarchar10
110PAT07_SDASupport Package Prerequisites8FLAGGeneral Flagnvarchar10
111PAT08Extended Support Package Attributes5FLAGPAT07: Flagnvarchar10
112PAT08_ACPExtended Attributes for Packages Referenced by ACP6FLAGPAT07: Flagnvarchar10
113PAT08_SDAExtended Support Package Attributes5FLAGGeneral Flagnvarchar10
TOPPayroll General Parts
114T515YSign Reversal for Table Fields in the Payroll Results4FLAGCheckboxnvarchar10
TOPPerformance Assessment Workbench
115SLS_CEMAILPAW - Result Evaluation: Pre-settings of the email flags2FLAGField Namenvarchar300
116SLS_CSIGNPAW - Result Evaluation: Pre-settings of the signals2FLAGField Namenvarchar300
117SLS_RITEMPAW - Result on Item8FLAGSingle-Character Indicatornvarchar10
118SLS_YITEMPAW - Result on Item8FLAGSingle-Character Indicatornvarchar10
TOPPlant Maintenance
119EAMS_SL_COUNTRYCountry Code table2FLAGGeneral Flagnvarchar10
120EAMS_SL_PIECHARTPie chart customizing table2FLAGGeneral Flagnvarchar10
121EAMS_SL_SCRN_SIZScreen sizing customization2FLAGGeneral Flagnvarchar10
122EAMS_SL_TIMERRefresh Timer for the Silverlight Appication3FLAGGeneral Flagnvarchar10
TOPProcess Controls
123GRPCCUSTOMIZING1Indicator2FLAGIndicatornvarchar200
124GRPCCUSTOMIZING2Rating Requiring Issue To Be Reported2FLAGIndicatornvarchar200
125GRPCCUSTOMIZINGTTexts: Indicator3FLAGIndicatornvarchar200
126GRPCREGBUSCUSTIndicator4FLAGIndicatornvarchar200
127GRPCREGBUSCUSTTtext table of GRPCREGBUSCUST5FLAGIndicatornvarchar200
TOPProfitability Analysis
128TKETRLFSummarization Levels: Catalog Entry, Characteristics7FLAGTotals records storagenvarchar10
TOPReal Estate Management
129VIMI05Characteristics per rental request5FLAGYes/no flag with 5 values Must/Yes/Not important/No/Nevernvarchar10
TOPRecords and Case Management
130RMPS_PRO_FOIFOI - Data4FLAGFoI Disclosability Indicatornvarchar10
TOPRecycling Administration Core Functions
131J_7LSADRAddress Management: Company Data26FLAGCheckboxnvarchar10
TOPSAP Utilities
132EVER_AUDITIS-U Audit Flags for Contracts3FLAGnvarchar40
TOPSecurity
133STRUSTCERTPublic Key Certificates5FLAGYes/Nonvarchar10
134STRUSTSSLSSL Client Identities of System3FLAGYes/Nonvarchar10
135STRUSTSSLSSSL Server Identities of the System3FLAGSwitch: Yes/Nonvarchar10
136STRUSTWSSEWS Security Identities of the System3FLAGSwitch: Yes/Nonvarchar10
TOPService Data Download
137/SDF/BPM_ASTADBPMon Application Statistical Records18FLAGSingle-Character Indicatornvarchar10
138/SDF/BPM_ASTAD2BPMon Application Statistical Records23FLAGSingle-Character Indicatornvarchar10
TOPServices
139UAFORMULA_DOCUUser-Specific Docu Window Option3FLAGIndicator for Documentation Windownvarchar10
TOPSyntax, Compiler, Runtime
140ABDOCMODEWindow Setting for ABAP Keyword Documentation3FLAGSingle-Character Indicatornvarchar10
141SLINCACHESLIN cache (table like INDX)2FLAGCHAR01 data element for SYSTnvarchar10
TOPTable Maintenance Tool
142TVDIRView Directory13FLAGCheckboxnvarchar10
TOPTranslation Tools
143APP_FCTRApplication ID Node Number2FLAGCheckbox for job statusnvarchar10
144DEVC_APPDevelopment Class Within the Application Hierarchy2FLAGCheckbox for job statusnvarchar10
145LXE_CO_2HHeader Data for Collection Groups2FLAGSingle-Character Indicatornvarchar10
146LXE_DIS_OObject Type Selection for Automatic Distribution4FLAGSingle-Character Indicatornvarchar10
147LXE_FIPRCheck Sum10FLAGSingle-Character Indicatornvarchar10
148MLTTSTLOGPMLT Test Cases: Log Positions15FLAGnvarchar10
149SBM132Industry short text proposal pool9FLAGSingle-Character Indicatornvarchar10
150TRNL_DC_2HHeader Data for Groups of Development Classes2FLAGSingle-Character Indicatornvarchar10
151TRNL_DIS_OGroup Selection for Automatic Distribution3FLAGSingle-Character Indicatornvarchar10
152TRNL_LANGTranslation Environment: Target Languages and Attributes 17FLAGSingle-Character Indicatornvarchar10
153TRNL_OTRSettings for OTR2FLAGSingle-Character Indicatornvarchar10
154TRNL_OTR_SSettings for OTR3FLAGSingle-Character Indicatornvarchar10
155TSKTUIndustry Short Text Search Strings5FLAGSingle-Character Indicatornvarchar10
156TSKTWIndustry short text replacements8FLAGSingle-Character Indicatornvarchar10
TOPTransport Organizer
157E071KChange & Transport System: Key Entries of Requests/Tasks12FLAGGeneral Flagnvarchar10
158E071KS_PREVIEWTransport Request Preview: Key Entries with Strings12FLAGGeneral Flagnvarchar10
159E071K_STRKey Entries with String Fields of Requests/Tasks12FLAGGeneral Flagnvarchar10
160E071K_STR_SHADOWCopy of E071K_STR_SHADOW, String Replaced By Long Char12FLAGGeneral Flagnvarchar10
161E071K__PREVIEWTransport Request Preview: Key Entries of a Request12FLAGGeneral Flagnvarchar10
162E071___PREVIEWTransport Request Preview: Objects of a Request12FLAGnvarchar10
163TADIR_MODNewly Created Repository Objects4FLAGSingle-Character Indicatornvarchar10
164TADIR_TMPNewly Created Repository Objects7FLAGSingle-Character Indicatornvarchar10
165TLOGOSObsolete8FLAGGeneral Flagnvarchar10
TOPUpgrade - General
166LANGTRKORRLanguages/Requests/Components (in the Upgrade)9FLAGGeneral Flagnvarchar10
TOPUpgrade Tools
167CRR_MDS_SOBJKCRR IUU: dyn maint event saving of e071k for logical w/o aim12FLAGGeneral Flagnvarchar10
TOPUS Prompt Payment Act
168FMFG_PPA_INV_HDPPA invoice header information (reason codes)7FLAGIndicator: No outstanding reason code(s) existnvarchar10
TOPUser Administration
169BBPORGUSRAssignment Users / Organizational Units for BBP5FLAGnvarchar320
TOPUser and Authorization Management
170USR_FLAGSVarious Flags for Authorization Programs1FLAGFlag for various authorization programsnvarchar40
171USSETTINGSCustomizing settings in user maintenance2FLAGFlag typenvarchar180
172USSETTINGTText table for USSETTINGS3FLAGFlag typenvarchar180
TOPWithout Description
173CCMSBI_CPH_REORGRepository for Data that Is Copied to the CPH Reorg. ODS4FLAGSingle-Character Indicatornvarchar10