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

77 columns | Print definition?ERP 6.0  | VARNAME

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/KORA/OBJREL_Tkr: Objektrelationen2VARNAMEkr:Scenarionvarchar200
2CNV_10940_CLUCluster Table for Report/Variants Back up5VARNAMEABAP: Name of variant (without program name)nvarchar140
3CNV_10940_CONVSTVariant conversion status6VARNAMEABAP: Name of variant (without program name)nvarchar140
4CNV_10940_COUNTCount for all reports and variants5VARNAMEABAP: Name of variant (without program name)nvarchar140
5CNV_10940_FCONSTFinal consistency check status6VARNAMEABAP: Name of variant (without program name)nvarchar140
6CNV_10940_FSELStoring free selections5VARNAMEABAP: Name of variant (without program name)nvarchar140
7CNV_10940_VARDETStoring values of variants5VARNAMEABAP: Name of variant (without program name)nvarchar140
8CNV_10940_VARHStoring all variants for relevant reports5VARNAMEABAP: Name of variant (without program name)nvarchar140
9TTDTGSAPscript: Standard Symbols for Word Processing2VARNAMESymbol namenvarchar220
TOPABAP List-Based PI Sheet
10COVLPPI Sheet: Current Variable Values3VARNAMEName of the variablenvarchar300
TOPALE Integration Technology
11TBDTPVALE Template: Variables2VARNAMEVariable name for VM Templatesnvarchar100
12TBDTPVTALE Template: Variable Names2VARNAMEVariable name for VM Templatesnvarchar100
TOPBatch-Oriented Parallel Processing of Mass Data
13BANK_REPORTSReport on Process4VARNAMEReport Variant Namenvarchar140
TOPBusiness Planning and Simulation
14UPX_RESP_SRC_VARUPX: Data Sources - Header4VARNAMEVariablenvarchar80
TOPCross-Application Mass Maintenance
15MASSVARABAPVariants: ABAP FORM Routines3VARNAMEVariant Namenvarchar100
16MASSVARABAP_SSystem Variants: ABAP FORM Routines2VARNAMEVariant Namenvarchar100
17MASSVARDBVariants for Mass Maintenance3VARNAMEVariant Namenvarchar100
18MASSVARIANTVariants: Basic Information3VARNAMEVariant Namenvarchar100
19MASSVARIANT_SSystem Variants: Basic Information2VARNAMEVariant Namenvarchar100
20MASSVARNEWPARAVariants: Reference for New Segments3VARNAMEVariant Namenvarchar100
21MASSVARNEWPARA_SSystem Variants: Reference for New Segments2VARNAMEVariant Namenvarchar100
22MASSVARNEWVALUESVariants: New Field Values3VARNAMEVariant Namenvarchar100
23MASSVARNEWVAL_SSystem Variants: New Field Values2VARNAMEVariant Namenvarchar100
24MASSVARRANGEVariants: Selection Options (Ranges)3VARNAMEVariant Namenvarchar100
25MASSVARRANGE_SSystem Variants: Selection Options (Ranges)2VARNAMEVariant Namenvarchar100
26MASSVARTABLESTABVariants: Reference for New Segments3VARNAMEVariant Namenvarchar100
27MASSVARTAB_SSystem Variants: Reference for New Segments2VARNAMEVariant Namenvarchar100
28MASSVARTRMass Maintenance Variants in Transportable Form3VARNAMEVariant Namenvarchar100
TOPFinancial Services Localization
29/GSINS/REU_VARCoordinates of Reserve Variables5VARNAMEVariable namenvarchar100
TOPImplementation Guide
30TVARHHeader entries for screen variants3VARNAMEScreen variant namenvarchar140
TOPIncentive and Commission Management ICM
31CACS_DET_VARDATAData for Determination Variants3VARNAMEName of Variantnvarchar300
32CACS_DET_VARIANTCharacteristics of Determination Variant3VARNAMEName of Variantnvarchar300
TOPInformation System
33GRIX_SELReport Writer: Selection parameters for stored data5VARNAMEVariable namenvarchar80
34GRIX_VARReport Writer: Variable for a report group version4VARNAMEVariable namenvarchar80
35GRIX_VARPVariation parameters for extracts (Report Writer)11VARNAMEVariable namenvarchar80
TOPliveCache Applications
36/SAPAPO/OMTSTDSCTest Description2VARNAMEABAP: Name of variant (without program name)nvarchar140
37/SAPAPO/OMTSTSETTest Cockpit Text Combinations3VARNAMEABAP: Name of variant (without program name)nvarchar140
TOPMigration
38TEMDBIS-U Mig.: Structure of Automation Data13VARNAMEFixed valuenvarchar120
39TEMFEIS-U Mig.: Fxd Vals1VARNAMEFixed valuenvarchar120
40TEMFECODEIS-U Migration: Table of Program Lines for Fixed Value1VARNAMEFixed valuenvarchar120
41TEMFETIS-U Mig.: Descriptions for FVs2VARNAMEFixed valuenvarchar120
42TEMRFIS-U Mig.: Conv. Rules (definition of fixed values)5VARNAMEFixed valuenvarchar120
43TEMUSIS-U Mig.: Managmnt10VARNAMEFixed valuenvarchar120
TOPOLAP Technology
44RSECLOGStorage for Authorizations Logs xml3VARNAMEVariable namenvarchar720
45RSECLOPDLOGCStore for LOPD Logs3VARNAMEVariable namenvarchar720
TOPPosition Budgeting and Control
46T77HRFPM_CD_FIVAHRFPM: Cust. Table for DC (Variant<-> Filter)2VARNAMEVariant Name of Document Creatornvarchar140
47T77HRFPM_CD_VARIHRFPM: Cust.Table for FPM Table (Feature Variant)4VARNAMEVariant Name of Document Creatornvarchar140
48T77HRFPM_DC_FIVAHRFPM: Cust. Table for DC (Variant<-> Filter)2VARNAMEData Collector Variantnvarchar140
49T77HRFPM_DC_PAYHRFPM: Cust.Table for DC (Payroll Simulation for PCP )2VARNAMEData Collector Variantnvarchar140
50T77HRFPM_DC_PCPHRFPM: Cust.Table for DC (PCP: Context / Scenario)2VARNAMEData Collector Variantnvarchar140
51T77HRFPM_DC_SUBHRFPM: Cust.Table for DC (PCP: Subtypes for 5010/0666)2VARNAMEData Collector Variantnvarchar140
52T77HRFPM_DC_VARHRFPM: Cust. Table for DC (PCP: Report Variant)2VARNAMEData Collector Variantnvarchar140
53T77HRFPM_DC_VARIHRFPM: Cust. Table for DC (Variant<-> Detailed Variant)3VARNAMEDetail Variant of Data Collector Modulenvarchar140
54T77HRFPM_ER_FIVAHRFPM: Cust. Table for Error Handler (Variant<-> Filter)2VARNAMEVariant for Module Error Handlingnvarchar140
55T77HRFPM_OBJCOLHRFPM: Customizing Table for Object Collector (Variants)2VARNAMEVariant for Module Collectornvarchar140
56T77HRFPM_OP_FIVAHRFPM: Cust. Table for Output (Variant<-> Filter)2VARNAMEVariant for Module Outputnvarchar140
57T77HRFPM_RA_FIVAHRFPM: Cust. Table for DC (Variant<-> Filter)2VARNAMEData Collector Variantnvarchar140
58T77HRFPM_VARIANTHRFPM: Customizing global variant of the run2VARNAMEVariant Name of Commitment Runnvarchar140
TOPProduct Cost Planning
59CKQS_MAP_IDMapping of Costing Run ID + Data Basis to Variant2VARNAMEABAP: Name of variant (without program name)nvarchar140
TOPRevenues and Earnings
60AD01FILTVARFilter Variants3VARNAMEVariantnvarchar140
61AD01STRUCTVARStructuring Variants3VARNAMEVariantnvarchar140
62AD01VARMASTERVariant Master4VARNAMEVariantnvarchar140
TOPSAP Business Partner
63TB041BP: Entry Variants for Evaluation Generator3VARNAMEABAP: Name of variant (without program name)nvarchar140
64TB041TBP: Texts for Variants of Evaluation Generator4VARNAMEABAP: Name of variant (without program name)nvarchar140
TOPSAPscript
65TTXSYSAPscript system symbol2VARNAMESymbol namenvarchar220
TOPService Data Download
66/BDL/FUPDATValues for data definition3VARNAMEParameter namenvarchar300
67BDLFUPDATValues for data definition3VARNAMEParameter namenvarchar300
TOPSets
68T802GU_SETUse of Variables in Sets4VARNAMEVariable namenvarchar80
69T802GU_VARUse of Variables in Formula Variables3VARNAMEVariable namenvarchar80
TOPTransaction Manager
70TCORT_CODCODeal: Conditions62VARNAMEVariable Namenvarchar40
71TCORT_CODULCODeal : Underlying's Conditions64VARNAMEVariable Namenvarchar40
TOPUser and Authorization Management
72USRCRCOMBPart List of Variants for Critical Combinations of Auths2VARNAMEVariant for Critical Combination of Authorizationsnvarchar200
73USRVARVariants for Critical Authorizations2VARNAMEVariant for Critical Authorizationsnvarchar200
74USRVARCOMVariants of Critical Combinations of Authorizations2VARNAMEVariant for Critical Combination of Authorizationsnvarchar200
75USRVARCOMTShort Texts for Variants of Critical Combs of Authorizations3VARNAMEVariant for Critical Combination of Authorizationsnvarchar200
76USRVARIDPart List of Variants for Critical Authorizations2VARNAMEVariant for Critical Authorizationsnvarchar200
77USRVARTShort Texts for Variants of Critical Authorizations3VARNAMEVariant for Critical Authorizationsnvarchar200