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

175 columns | Print definition?ERP 6.0  | SORT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBPC_SUS_TABDEFDefinition of Displayable Fields in a Table Item9SORTSort SRM SUS Iteratornvarchar10
2CCGLC_MPD_NEWEHS: Manual Print Dialog for Print Request11SORTSort Sequencenvarchar40
3CCGLC_WBC_BPEHS: LWB Function4SORTSort Sequencenvarchar40
4CCGLC_WBC_ETDEHS: LWB Activity5SORTSort Sequencenvarchar40
5CCGLC_WBC_QCEHS: LWB Search Criteria of a Function4SORTSort Sequencenvarchar40
6CCGLC_WBC_STBEHS: LWB Subtab5SORTSort Sequencenvarchar40
7CCGLC_WBC_STSDEHS: LWB Subtab Screen6SORTSort Sequencenvarchar40
8CCGLC_WBC_STSOEHS: LWB Subtab Screen Field Properties7SORTSort Sequencenvarchar40
9CCGLC_WBC_TABEHS: LWB Tab4SORTSort Sequencenvarchar40
10CCGLC_WBC_TSDEHS: LWB Tab Screen5SORTSort Sequencenvarchar40
11CCGLC_WBC_TSOEHS: LWB Tab Screen - Field Properties6SORTSort Sequencenvarchar40
12CCGLT_PRTREQ_PAREHS: Print Request Parameters11SORTSort Sequencenvarchar40
13CCGLT_PR_PAR_UTEHS: Print Request Parameters Test Data for Unit Tests4SORTSort Sequencenvarchar40
14CNV_20100_CEFORMCEFORMF records with rel. org. units + addit. VALUE field15SORTnvarchar40
15DFKKDPR_BP_ASORTData Protection: Information on Bus. Partner Retention5SORTStart Date of Retention Periodnvarchar80
16DFKKDPR_BP_SORTData Privacy: Information on Business Partner Retention4SORTStart Date of Retention Periodnvarchar80
17GRRMOBWAGDLoss Event WF: Agent Determination for Statuses4SORTSorting Sequencenvarchar20
18T77HRFONL_BLKPayslip: Definition of Block entries9SORTDisplay Ordernvarchar20
19T77HRFONL_SECTIOPayslip: Definition of Section entries8SORTDisplay Ordernvarchar20
20HRT1747Table Section for Infotype 17474SORTSort Sequencenvarchar30
21T7PIQCORRAPFORMApplication Forms for Ad-Hoc Correspondence6SORTSort Sequencenvarchar30
22T7PIQMODGRPCATModule Group Categories4SORTSort Sequencenvarchar20
23T7PIQQUAL_CLASSDegree Levels3SORTStanding of the Degree Levelnvarchar20
24T7PIQRULEMODTPRule Container/Callup Point Assignments3SORTSort Sequencenvarchar30
25T7PIQSEVERITYAcademic Level per Module3SORTSort Sequencenvarchar20
TOPAdvertising Management
26TJJCAMP_AM_T_ASSIS-M/AM: Marketing Campaign- Assign Template Order5SORTIS-M: General Sort Fieldnvarchar30
27TJJCAMP_SD_T_ASSIS-M/SD: Marketing Campaign - Assign Template Offer4SORTIS-M: General Sort Fieldnvarchar30
28TJJPLZONLIS-M: Online Positioning Instruction3SORTIS-M: Sorting for Online Positioning Instructionnvarchar40
TOPAnalyzer
29AFWCH_PHDEFALTAlternative Portfolio Hierarchy Definition8SORTSort Order of Characteristic Groupnvarchar30
TOPApplication Framework
30MDG_TR_CCOObject Status Client Copy3SORTSorting for Import Sequencenvarchar60
31MDG_TR_TCATDirectory of Transport Objects6SORTSorting for Import Sequencenvarchar60
32MDG_TR_TCATOAttributes of Obsolete Transport Objects7SORTSorting for Import Sequencenvarchar60
33MDG_T_CXT_DEMOPersistent Storage of a Simple Message Context5SORTNumeric Character Field, Length 10nvarchar100
TOPAppraisal, Valuation, and Survey Tool
34HRPAD605Additional Data PAD6053SORTSortnvarchar30
TOPBalanced Scorecard
35UMB_SC188Scorecard: Initiative: Benefits5SORTSequencenvarchar20
TOPBasic Data and Tools
36EHFNDD_CI_USRDEFCluster table for user specific settings5SORTSorting of Defaultsint100
TOPBelgium
37T5BS3Employee information except reductions ( level 3 )28SORTSI declaration date of leavingnvarchar80
TOPBudget Control System
38BUBAS_MSG_AREAMessage Area2SORTSort numbernvarchar30
TOPBusiness Navigator
39DF52AFilter Action Log3SORTNext record counter in EXPORT/IMPORT data tablesint100
TOPBusiness Planning and Simulation
40UPC_DATASLICEData Slices3SORTSort Ordernvarchar60
41UPC_DATASLICETData Slices4SORTSort Ordernvarchar60
42UPP_CHARPlanning: Characteristics7SORTSequential Numbernvarchar40
43UPP_ELEMTPlanning: Column Elements Texts7SORTSequential Numbernvarchar40
44UPP_SPREADSPlanning: Spreadsheet Customizing6SORTSequential Numbernvarchar40
45UPX_CHANMGROUPIUPX: Characteristic Groups - Items4SORTSort Ordernvarchar60
46UPX_CUST_FCTRYCustomizing Framework: Factories4SORTSequencenvarchar40
47UPX_CUST_STEPCustomizing Framework: Steps3SORTSequencenvarchar40
TOPCapacity Leveling
48TCY31_HDefinition of a sort per layout and chart6SORTFormat key for sortingnvarchar100
TOPCollectionsDisbursements
49TVKKSMenu Description for FS-CD Office5SORTNatural Numberint100
TOPContract Accounts Receivable and Payable
50DFK_JC_CNTRContainer for Related Jobs17SORTnvarchar20
TOPCross-Application Components
51TASUVAR1ASU Variants: Fieldinformations for reports with variant4SORTNatural Numberint100
TOPDocument Management Framework
52SKWATREEAdministration Workbench: Initial Access Screen3SORTCounternvarchar30
TOPEmployee Self-Service
53T77WWW_WHO_SRDESS Who's Who: Field Selection per Country Grpg & Appl.Type6SORTNumeric 1-characternvarchar10
TOPEnd User Technology
54RSZSELECTSelection properties of an element6SORTSort Orderint100
TOPEngineering Change Management
55TCCEPEffectivity parameters7SORTSort field for effectivity parametersnvarchar20
TOPEnvironment, Health and Safety
56/TDAG/CPC_CHKGACP: Check Group -> Check Assignment4SORTSort Sequencenvarchar40
57/TDAG/CPC_CPROVCP: Content Providers3SORTSort Sequencenvarchar40
58/TDAG/CPC_MGRSCCP: Configuration of Tab Pages in Compliance Workbench3SORTSort Sequencenvarchar40
59/TDAG/CPC_REP005CP: Define attributes for element5SORTSort Sequencenvarchar40
60/TDAG/CPC_REP011CP: Define hierarchy for report format6SORTSort Sequencenvarchar40
61/TDAG/CPC_TBPAGCP: Tab page5SORTSort Sequencenvarchar40
62/TDAG/RCSA_COSTCost Monitoring20SORTSortierreihenfolgenvarchar40
TOPEnvironment, Health and Safety Master Data
63HSMC_017EHS: Definition of Text Types for Hazardous Substance Master7SORTSort Sequencenvarchar40
64HSMC_019EHS: Definition of Numeric Types in Hazardous Subs. Master7SORTSort Sequencenvarchar40
65HSMT_DTEHS: Hazardous Substance Addit. Data 1 (Text Type)17SORTSort Sequencenvarchar40
TOPFinancials Basis
66FINB_TR_CCOClient Copy: Object Status3SORTFINB TR: Sorting for Import Sequencenvarchar60
67FINB_TR_TCATFINB TR: Directory of Transport Objects6SORTFINB TR: Sorting for Import Sequencenvarchar60
68FINB_TR_TCATOFINB TR: Attributes of Obsolete Transport Objects7SORTFINB TR: Sorting for Import Sequencenvarchar60
TOPForms
69TSELRANGES_01HR Forms: Specifications of Selections10SORTSort orderint100
TOPGeneric Project Planning
70CGPL_USROPTProject Planning - Classes for User Settings2SORTTwo digit numbernvarchar20
TOPGovernance, Risk and Compliance
71GRFNAGENTSLOTCCustomized Rules for Business Event3SORTnvarchar20
72GRFNLOGENABLEEnable/disable application log for GRC3SORTSequencenvarchar30
73GRFNMDCRIMaster Data Change Request Items3SORTNatural Numberint100
74GRFNTASKAUTHRELRelated authorization details per WF task3SORTnvarchar20
75GRPCRELLINKRelated links3SORTSequencenvarchar40
TOPGRC Risk Management
76GRFNMWREGMigration Registry1SORTSequencenvarchar30
77GRFNMWREGTMigration registry text table1SORTSequencenvarchar30
TOPHoliday Calendar, Factory Calendar, Appointment Calendar
78THOLPublic Holidays10SORTSort field for public holidaysnvarchar30
TOPIncentive and Commission Management ICM
79TCACS_COMPONENTTables for Available Components2SORTSort Sequencenvarchar50
80TCACS_INDUSTRYAvailable Industry Sectors2SORTSort Sequencenvarchar50
81TCACS_PROCESSTable for Available Processes3SORTSort Sequencenvarchar50
TOPIndustrial Hygiene and Safety
82CCIHC_IH07EHS: Exposure Rating3SORTSort Sequencenvarchar40
83CCIHC_MJCATEHS: Sampling Type4SORTSort Sequencenvarchar40
TOPIntegrated Product and Process Engineering
84PRELIDiPPE Relationship: Time-Independent ID and Attributes18SORTSort Field for iPPE Relationshipsnvarchar60
85PRGENGEN Relationships - Relationships Table20SORTSort Field for iPPE Relationshipsnvarchar60
86PRTSTTest Relationships - Relationships Table7SORTSort Field for iPPE Relationshipsnvarchar60
TOPLocalization
87RFITEMAP_NO_ITEMItem wise detail for the Vendor Transactions139SORTSort Key for Line Item Reportint100
88RFITEMAR_NO_ITEMItem wise detail for the Customer Transactions139SORTSort Key for Line Item Reportint100
89RFITEMGL_NO_ITEMItem wise detail for the GL Account Transactions139SORTSort Key for Line Item Reportint100
TOPLogbook
90DIOHFW_NODESNodes8SORTSort fieldnvarchar100
TOPManagement of Internal Controls
91FOPCOBJTYPEMIC Object Type3SORTCount parametersnvarchar40
92FOPCSTARTPAGEStart Page Configuration4SORTSequencenvarchar30
TOPMaterials Management
93/ISDFPS/CUSTACCCustomer Jump6SORTSort Sequencenvarchar20
TOPMedia Product Sales and Distribution
94JKSDCOLLECTISSUERecall Dates for Issues10SORTIS-M: Sort Field for Return Collectionint100
95JKSDCOLLECTITEMIS-M: (Obsolete) Collection Item Data5SORTIS-M: Sort Field for Return Collectionint100
96TJKSDFCCALCPROCIS-M: Assignment of Calculation Methods to Rule3SORTSequencenvarchar20
97TJKSDFCTOTLPROCIS-M: Assignment of Total Methods to Rule3SORTSequencenvarchar20
TOPMonitoring
98SAPWLWAMAITable to dynam. output fields in Trans. STAD - main list2SORTSAP Workload: STAD: Sort field for the output in main listtinyint30
TOPNetWeaver Enterprise Search
99ESH_OM_ACATTRCommon Attributes7SORTCheckboxnvarchar10
100ESH_OM_ACATTRUCommon Attributes: Usage Types6SORTCheckboxnvarchar10
101ESH_OM_CCATTRCommon Attributes7SORTCheckboxnvarchar10
102ESH_OM_CCATTRUCommon Attributes: Usage Types6SORTCheckboxnvarchar10
103ESH_OM_ICATTRCommon Attributes7SORTCheckboxnvarchar10
104ESH_OM_ICATTRUCommon Attributes: Usage Types6SORTCheckboxnvarchar10
TOPOffice Suite Program
105/OSP/T_DUET_MENUDuet Menu Options5SORT2 byte integer (signed)smallint50
TOPOLAP Technology
106RSRA_BT_PARAMSParameter Table for Template Setting4SORTNumbering for one-dimensional drilldownnvarchar40
TOPOverhead Cost Orders
107COBRASettlement Rule for Order Settlement22SORTSettlement rule sort fieldnvarchar220
TOPPeriodical Sales and Distribution
108TJYCIC_TEXTS_TPNIS-M: CIC, Texts, Texts per Node8SORTIS-M: CIC, Texts, Display Sequencenvarchar30
TOPPlanning
109T8PL01FI-Planning: Summary Table Dimensions to be Planned15SORTValidation sequence on initial screennvarchar40
110T8PL02FI-Planning: User attributes20SORTSequence Numbernvarchar40
TOPPlant Maintenance
111EAMWS_RESPONSESRisk Respones for Safety Checklist8SORTSort Field for List of Relevant Risksnvarchar100
112EAMWS_RISKSRisks for Safety Checklist7SORTSort Field for List of Relevant Risksnvarchar100
113EAMWS_SAFETYMEASSafety Measures for Safety Checklist8SORTSort Field for List of Relevant Risksnvarchar100
TOPProcess Controls
114GRPCCTRLPROPOSALGRPC:Control Proposal20SORTSequencenvarchar40
115GRPCENABLELOGEnable/disable API logging3SORTSortnvarchar20
116GRPCOBJTYPEObsolete: PC Object Type3SORTCount parametersnvarchar40
117GRPCSTARTPAGEStart Page Configuration4SORTSequencenvarchar30
118GRPC_ATTR_MAPPINMapping Dynamic Attributes with UI3SORTSequencenvarchar30
TOPProduct Safety
119CCGLC_MPDEHS: Manual Print Dialog12SORTSort Sequencenvarchar40
120CVDDPEHS: Parameter Values for Report Shipping45SORTSort Sequencenvarchar40
121EST_CHANGE_DOCSEHS: Change Documents in the EH&S System24SORTSort Sequencenvarchar40
122TCGES_ATTRIBUTESEHS: Search Form - Enterprise Search - Attributes5SORTNatural Numberint100
TOPProfitability Analysis
123/EACA/TPMCGRP1PM Characteristics of a Characteristic Group6SORTSort Key Groupsnvarchar30
124/EACA/TPMKGRP1Key Figure Groups - Key Figures6SORTSort Key Groupsnvarchar30
125CEFORMFCO: Definition of contents of element in row/col.str.14SORTSequence Numbernvarchar40
126CEFORMVCO: Variables for row/column structure20SORTSequence Numbernvarchar40
127CESETSSet Administration in the Report Painter11SORTSequence Numbernvarchar40
128TKEPPLLEVSPlanning Level - Selection Table12SORTSequence Numbernvarchar40
129TKEPPLPPSPlanning Package - Selection Table13SORTSequence Numbernvarchar40
TOPQualifications and Requirements
130T77PPHR-PD: Profile Maintenance - Sub-profile Names4SORTSort sequence for profiles/sub-profilesnvarchar20
131T77PR_V_H_PPA-PD: Profile - Assign Views to Headers to Subprofiles5SORTSort sequence for profiles/sub-profilesnvarchar20
TOPRecipe
132RCPC_MSC_ASCOPEChanges to Scope-of-Application Status4SORTSequence of Status Changesnvarchar40
133RCPC_MSC_STEXECExecution Steps for Recipe Header Status5SORTSequence of Status Changesnvarchar40
TOPRecords and Case Management
134RMPS_DESK_TAFDAssignment Folder to Desk4SORTTwo digit numbernvarchar20
TOPRecycling Administration Core Functions
135J_7LC47REA Customizing: Customer Enhancement3SORTREA Customizing: Subitemnvarchar60
136J_7LC47TREA Customizing: Customer Enhancement Text Table4SORTREA Customizing: Subitemnvarchar60
137J_7LC47WREA Customizing: Customer Enhancement (Internal Table)3SORTREA Customizing: Subitemnvarchar60
TOPRemaining Beverage - Obsolete Objects
138/BEV3/CHCTS01Selection Tables + Default Selection Fields9SORTSort sequencenvarchar40
139/BEV3/CHCTS02Selection Table + Selection Fields6SORTSort sequencenvarchar40
140/BEV3/CHCTS04Filter fields and tables (implicit)3SORTSort sequencenvarchar40
TOPReporting
141P05T_XML_KENTWage Return: XML Tags Mapping Indicator3SORTWage Return: Tag Sequence in a Part of a Sectionnvarchar30
142T77PRNL_XML_INPension Return: XML Tags Mapping Indicator4SORTWage Return: Tag Sequence in a Part of a Sectionnvarchar30
TOPResourcen Management
143FRMLC33RMS-FRM: Layout-Dependent Field Catalog5SORTSequence of Table Columnstinyint30
144FRMLC36RMGMT Formula: Key Figure Groups3SORTSort Sequence of Key Figure Groupstinyint30
145FRMLC37RMGMT Key Figures: Group Assignment4SORTSort Sequence for Key Figures Within a Grouptinyint30
146FRMLC50RMS-FRM: Data Source4SORTSequence of Table Columnstinyint30
147FRMLC53RMS-FRM: Calculation Cases5SORTSequence of Table Columnstinyint30
148FRMLC71RMS-FRM: Sort Sequence for Diet Groups3SORTSequence of Table Columnstinyint30
149FRMLC_NTR_GRPRMS-FRM: Nutrient Groups3SORTSequence of Table Columnstinyint30
150RMSLC_RULECustomizing: Apply Rule4SORTSort Ordertinyint30
151RMSLC_TEXTCustomizing: Text Modules3SORTSort Ordertinyint30
152RMXTC_M03TMS-TLS: Monitor Customizing - Assgt of Task to Task Group5SORTTask Sequenceint100
TOPRisk Analysis
153JBRPHDEFDefinitions Used to Derive Portfolio Hierarchy7SORTSort Order of Characteristic Groupnvarchar30
154JBRPHDEFBKRM: Backup for Table JBRPHDEF7SORTSort Order of Characteristic Groupnvarchar30
TOPSAP Healthcare - Industry-Specific Components for Hospitals
155TNNE1IS-H NL: Gültigkeit Behandlungsscheine7SORTIS-H NL: Sorteercode voor kaartsoortnvarchar10
TOPSAP Retail Store
156WOSCR_CBL_COCODECash Balancing: Settings for Each Company Code4SORTSequence Group of Accounts/Subgroup/G/L Account/Currencynvarchar20
157WOSCR_GRP_002SRS Convenience Retailing - Subgrouping of Accounts4SORTSequence Group of Accounts/Subgroup/G/L Account/Currencynvarchar20
158WOSCR_SITE_GRPCash Balancing: Settings for Each Group of Accounts4SORTSequence Group of Accounts/Subgroup/G/L Account/Currencynvarchar20
TOPServices
159FINB_T_CXT_DEMOPersistent Storage of a Simple MSG Context5SORTNumeric Character Field, Length 10nvarchar100
TOPShipping
160T186FFunctions in the Shipping Due List3SORTSort sequence for F codes for delivery creationnvarchar40
TOPTime Sheet
161TCATSDLISTCATS: Profile for Reporting (List Display)6SORTSort Sequencenvarchar50
TOPTransport Management System
162TMSFSYSLTMS Configuration: System Lists4SORTTMS: Sort Ordernvarchar20
TOPTransport Organizer
163TRFUNCSELMultiple Selection of Request Types2SORTtinyint30
TOPUse Subcomponents
164SOEMSREPSAPoffice: Control table for emergency sys. return transport3SORTSAPoffice: Sort class for recipient name (type)nvarchar10
165SOFRSAPoffice: Distribution List Table for Incoming Faxes2SORTSAPoffice: Sort field for fax distribution table (key)nvarchar40
166TSINASAPBPT: Configuration Table20SORTColumns - sortingnvarchar30
167TSINOSAPBPT: General SAP configuration columns9SORTColumns - sortingnvarchar30
168TSINUSAPBPT: Configuration Table User9SORTColumns - sortingnvarchar30
TOPUser and Authorization Management
169TUTYPASystem measurement: User types with attributes6SORTUser Types Sort Ordernvarchar60
170TUTYPNOWSYSSystem Measurement: System-Specific Active User Types6SORTUser Types Sort Ordernvarchar60
171USRSYSUTPACUA: System Measurement: User Types with Attributes8SORTUser Types Sort Ordernvarchar60
TOPValue Adjustment
172/IBS/CRB_BA_SRTRBD: Obsolete4SORTRBD: Sort Key for Error Messages from T100nvarchar30
173/IBS/CRB_BA_SRTPRBD: Obsolete2SORTRBD: Sort Key for Error Messages from T100nvarchar30
174/IBS/CRB_BA_SRTTRBD: Obsolete3SORTRBD: Sort Key for Error Messages from T100nvarchar30
TOPWork Center
175KAKOCapacity Header Segment50SORTFreely Selectable Character Sequence for Sorting Resourcesnvarchar300