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

183 columns | Print definition?ERP 6.0  | CLNT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPPSSRM/EMAILIMG table for email addresses of recipients1CLNTClientnvarchar30
2/SAPPSSRM/IDCIDC types for Gov. Proc.1CLNTClientnvarchar30
3/SAPPSSRM/IDCPTTransaction Types Relevant for Order Types1CLNTClientnvarchar30
4/SAPPSSRM/IDCTTranslations for IDC types table1CLNTClientnvarchar30
5/SAPPSSRM/OPT_TBAvailable Option Indicators1CLNTClientnvarchar30
6/SAPPSSRM/OPT_TRTranslation for Option Values1CLNTClientnvarchar30
7/SAPPSSRM/PA_IDPricing Arrangements: PA Identifiers1CLNTClientnvarchar30
8/SAPPSSRM/PA_IDTPricing Arrangements: Identifier Description (Text Table)1CLNTClientnvarchar30
9/SAPPSSRM/PA_STPricing Arrangements: Components of Pricing Structure1CLNTClientnvarchar30
10/SAPPSSRM/PA_STTPricing Arrangements: Component Label (Text Table)1CLNTClientnvarchar30
11/SAPPSSRM/PA_TTAPricing Arrangements: Allow Function for Transaction Type1CLNTClientnvarchar30
12/SAPPSSRM/T_DPPTBusiness Transaction Types for Down Payments1CLNTClientnvarchar30
13/SAPPSSRM/T_DPTTDown Payment Types: Text Table1CLNTClientnvarchar30
14/SAPPSSRM/T_WHPTBusiness Transaction Types for Retention1CLNTClientnvarchar30
15/SAPSRM/BD_PTR_CDummy partners in Supplier System for Bidder Decoupling1CLNTClientnvarchar30
16BBPD_IMD_DEBUGDebugger Flag for Processing of E-mail Inbox1CLNTClientnvarchar30
17BBPD_IMS_BE_INVIMS: Last Update for TREX1CLNTClientnvarchar30
18BBPD_IMS_MAIL_PRTable for Reprocessing of E-mails in IMS1CLNTClientnvarchar30
19BBPD_ITS_STARTFlag for using new start page or the old style in SRM(ITS)1CLNTClientnvarchar30
20BBPT_IMS_LOGIMS Log Data Table1CLNTClientnvarchar30
21BBP_DYNAT_ACTActivation of Multiple Languages for Dyn. Attributes1CLNTClientnvarchar30
22BBP_DYNAT_MASTERMaster Data for Dynamic Attributes1CLNTClientnvarchar30
23BBP_DYNAT_MSTR_TTable to maintain Dynamic attributes with language key1CLNTClientnvarchar30
24BBP_IMS_SEND_CTRControl of E-mail Sending for IMS1CLNTClientnvarchar30
25BBP_TAX_SETTINGSSettings for Tax Calculation1CLNTClientnvarchar30
26BBP_WGT_PROP_CUSTable for Customizing for Weighting1CLNTClientnvarchar30
27CCGLT_PRTREQ_HDREHS: Print Request Header Table29CLNTClientnvarchar30
28DMC_IU_UPGTRMWB Upgrade: List of Transport Orders1CLNTClientnvarchar30
29FPIA_T_PTIOAProcess Types for Interest Indicator1CLNTClientnvarchar30
30GRFNSCRTABSAP Table Scripts1CLNTClientnvarchar30
31GRFNSCRTABTSAP Table Script Texts1CLNTClientnvarchar30
32GRFNTSVYGROUPSurvey Instance Group1CLNTClientnvarchar30
33GRFNTSVYINSTSurvey Instance table1CLNTClientnvarchar30
34GRRMPDFMCPDF Mapping (Customer)1CLNTClientnvarchar30
35GRRMRISKOPPLVLRisk and Opportunity Level Configuration1CLNTClientnvarchar30
36GRRMRISKOPPLVLTRisk and Opportunity Level Configuration Labels1CLNTClientnvarchar30
37GRRM_RESOURCE_RORESTful resources1CLNTClientnvarchar30
38J_1I_CINPRICEPrice data1CLNTClientnvarchar30
39J_1I_CINTAXTax data1CLNTClientnvarchar30
40PPMRP_C_TEXTIDCustomizing for text IDs for PR and PO1CLNTClientnvarchar30
41RSCRMD_IMP_TRACETrace results table1CLNTClientnvarchar30
42RSCRM_IMP_TRACETrace results table1CLNTClientnvarchar30
43SRT_SR_FORWARDServices Registry: Queue for asynchronous forwarding1CLNTClientnvarchar30
44T169QDifferential Invoicing Process1CLNTClientnvarchar30
45TISSR_RATING_HBHistorie des Wertpapier-Ratings1CLNTMandantnvarchar30
46TNLREPCTRLCheck Table to Determine if Legal Representative Active1CLNTClientnvarchar30
47YIT_OMDTIDA: Original Clients1CLNTClient - original datanvarchar30
48YIT_OMDTLIDA: clients containing original objects1CLNTClient - original datanvarchar30
49ZCONV_LOG_IMPORTImportprotokoll5CLNTMandant des Komponentensystemsnvarchar30
50ZLANDSCAPE_RULESLandscape Maintenance: Field Control2CLNTClient of component systemnvarchar30
51ZSYSTEM_ADDOBJAdditional Variables2CLNTClient of component systemnvarchar30
52ZSYSTEM_ADDOBJ_Tadditional objects: Texts2CLNTClient of component systemnvarchar30
53ZSYSTEM_INFO_CATCatalog information for systems3CLNTClient of component systemnvarchar30
54ZSYSTEM_INFO_TCPConversion-relevant TCP/IP Destinations4CLNTClient of component systemnvarchar30
55ZSYSTEM_MASTER_CConversion-relevant RFC Connections8CLNTClient of component systemnvarchar30
56ZSYSTEM_PARTNERLandscape data: Items4CLNTClient of component systemnvarchar30
57ZSYSTEM_TABSConversion of Table Fields7CLNTClient of component systemnvarchar30
58ZTARGET_ADDOBJValue table for additional objects3CLNTClient of component systemnvarchar30
59ZTARGET_INFO_TCPTCPIP Destinations in Systems4CLNTClient of component systemnvarchar30
60ZTARGET_PARTNERSystem Landscapes: Components4CLNTClient of component systemnvarchar30
61/BOBF/D_CC_LOG_HBOPF Contract Compliance Check Log header1CLNTClientnvarchar30
TOPALE Integration Technology
62TBDBDLSALLContains all tables to be converted2CLNTnvarchar10
TOPApplication-Specific Upgrade
63UACC_RFCUACC RFC Destinations1CLNTClientnvarchar30
TOPArchiveLink
64TOAMOArchiveLink Monitor Status1CLNTClientnvarchar30
TOPArchiving Connector ABAP
65ARCHLNK_AUDITINGLicense Audit for ARCHLNK Proxies from AL and DL1CLNTClientnvarchar30
66LHM_LH_PGATE_ALLegal Hold Cases for ArchiveLink Attachments1CLNTClientnvarchar30
67LHM_LH_PGATE_DLLegal Hold Cases for Print Lists1CLNTClientnvarchar30
68LHM_PGATE_AL_RWLegal Hold Cases for ArchiveLink Attachments in RW1CLNTClientnvarchar30
TOPBackground Processing
69TBCICPT1Table with intercept conditions for batch jobs1CLNT3-Byte fieldnvarchar30
TOPBasic Data
70TNBPOMCTRLControl table for the SAP BP and OM conversion1CLNTClientnvarchar30
TOPBusiness Planning and Simulation
71UPX_CUST_CONSTRCustomizing Components Constraints1CLNTClientnvarchar30
TOPCapacity and Resource Planning
72/MRSS/C_RM_AB_CARM Abstract Statuses at the Candidate Level1CLNTClientnvarchar30
73/MRSS/C_RM_AB_RORM Abstract Statuses at the Role Level1CLNTClientnvarchar30
74/MRSS/C_RM_AB_RQRM Abstract Statuses at the Request Level1CLNTClientnvarchar30
75/MRSS/C_RM_ASG_SMap Booking Types to MRS Assignment Status1CLNTClientnvarchar30
76/MRSS/C_RM_A_CA1RM Abstract Statuses at the Candidate Level1CLNTClientnvarchar30
77/MRSS/C_RM_BOOKMap Booking Type to Candidate Statuses1CLNTClientnvarchar30
78/MRSS/C_RM_ST_OBCustomizing for Maintaining Status obj type for Candidatates1CLNTClientnvarchar30
TOPClinical System
79N2DIS_TYPESDispatch Route Types f. ishmed Object Dispatch (s.Table Doc)1CLNTClientnvarchar30
80N2DIS_TYPESTText Table for N2DIS_TYPES1CLNTClientnvarchar30
81TN2CHART_ACTIVATCharting: Activate Chart Display1CLNTClientnvarchar30
82TN2COM_DOCFORMATDocument Category Settings for Document Dispatch1CLNTClientnvarchar30
83TN2COM_DOCTYPMAPImage of Relationship Between Internal & External Doc. Categ1CLNTClientnvarchar30
84TN2COM_PART_WSPartner Data for Web Service Communication1CLNTClientnvarchar30
85TN2COM_SYSTIDMaintain Sender Settings1CLNTClientnvarchar30
TOPCollections Management
86UDM_RSM_REASONReasons for Resubmission1CLNTClientnvarchar30
87UDM_RSM_REASONTNames of Resubmission Reasons1CLNTClientnvarchar30
TOPeCATT Extended Computer Aided Test Tool
88ECATT_LOG_DSP_MATo log the details after mass change of attributes1CLNTClientnvarchar30
TOPeXternal Management Interface Framework
89TBCICPTTable with intercept conditions for batch jobs1CLNTBackground client for authorization checknvarchar30
TOPGovernance, Risk and Compliance
90GRFNCONNECTORConnector1CLNTClientnvarchar30
91GRFNNOTIFYMSGCNotification Messages (Customer)1CLNTClientnvarchar30
92GRFNNOTIFYMSGCTNotification Message Subjects (Customer)1CLNTClientnvarchar30
93GRFNPERSRESPUser Responsible for Entity1CLNTClientnvarchar30
94GRFNSCRBWQSAP BW Query Script1CLNTClientnvarchar30
95GRFNSCRBWQTSAP BW Query Script Texts1CLNTClientnvarchar30
96GRFNSCRSAPQSAP Query Scripts1CLNTClientnvarchar30
97GRFNSCRSAPQTSAP Query Script Texts1CLNTClientnvarchar30
98GRFNSCRWSWeb Service Scripts1CLNTClientnvarchar30
99GRFNSCRWSTWeb Service Script Texts1CLNTClientnvarchar30
TOPGRC Risk Management
100/ORM/ORMT_PRBDEFProbability Definition1CLNTClientnvarchar30
101/ORM/ORMT_PRBLVProbability Level1CLNTClientnvarchar30
102/ORM/ORMT_PRBLVTProbability Level Texts1CLNTClientnvarchar30
103GRFNMWLOGMigration Log1CLNTClientnvarchar30
104GRRMCACTPROCLNKLink between Activity Categories and Processes1CLNTClientnvarchar30
105GRRMCACTTYPActivity Type1CLNTClientnvarchar30
106GRRMCACTTYPTActivity Type Text1CLNTClientnvarchar30
107GRRMSVYANALSurvey analysis data table1CLNTClientnvarchar30
108GRRMTKRIBUPRKRI Business Process1CLNTClientnvarchar30
109GRRMTKRIBUPRCOMPRelationship between Business Process and Component1CLNTClientnvarchar30
110GRRMTKRIBUPRTKRI Business Process Texts1CLNTClientnvarchar30
111GRRMTKRICOMPKRI Component1CLNTClientnvarchar30
112GRRMTKRICOMPTKRI Component Texts1CLNTClientnvarchar30
113GRRMTKRIREQIMPLRelationship between KRI Impl. Request and KRI Impl.1CLNTClientnvarchar30
114GRRMTKRISYSKRI System1CLNTClientnvarchar30
115GRRMTKRISYSTKRI System Texts1CLNTClientnvarchar30
116GRRMTSVYINSTSurvey Instance table1CLNTClientnvarchar30
TOPLegal Case Management for ILM
117LHM_LEGAL_HOLDSOBSOLETE1CLNTClientnvarchar30
118LHM_LH_ARCHIVEDLegal Holds in Archive Files1CLNTClientnvarchar30
119LHM_PROPAGATEStores Legal Holds for Archive Files1CLNTClientnvarchar30
TOPMaster Recipe
120CPC_CMX_DB_CORMaster Recipe: Context Table for Recipe Header1CLNTnvarchar30
121CPC_CMX_DB_COSMaster Recipe: Context Table for Recipe Operations/Phases1CLNTnvarchar30
122CPC_CMX_DB_LOGXSteps: Change Log1CLNTnvarchar30
123CPC_CMX_DB_R_CORRouting: Context Table for Plan Header1CLNTnvarchar30
124CPC_CMX_DB_R_COSRouting: Context Table for Operations1CLNTnvarchar30
125CPC_CMX_DB_R_LOGXSteps (Routing): Change Log1CLNTnvarchar30
TOPMaterials Management
126BBPC_RFC_DESTRFC Destinations that Refer to an SRM System1CLNTClientnvarchar30
TOPProcess Management
127CMX_XSE_DB_PERSXSEditor: Personalization Data1CLNTClientnvarchar30
128CMX_XSR_DB_AUTHStandard Execution Step Repository: Authorization Group1CLNTClientnvarchar30
129CMX_XSR_DB_AUTXTSXS Repository: Texts for Authorization Group1CLNTClientnvarchar30
130CMX_XSR_DB_CLOGXSteps: Change Log1CLNTnvarchar30
131CMX_XSR_DB_FOLDStandard Execution Step Repository: Folder1CLNTnvarchar30
132CMX_XSR_DB_FOLDTStandard Execution Step Repository: Texts for Folder1CLNTnvarchar30
133CMX_XSR_DB_ITEMStandard Execution Step Repository: Items1CLNTnvarchar30
134CMX_XSR_DB_ITEMTStandard Execution Step Repository: Texts for Items1CLNTnvarchar30
135CMX_XSR_DB_VERSStandard Execution Step Repository: Versions1CLNTnvarchar30
136CMX_XS_C_TL_PICXSteps: Translatable Process Instruction Characteristics1CLNTnvarchar30
137CMX_XS_DB_HDELXSteps: Historical Nodes with Deletion States (if Reorg.)1CLNTnvarchar30
138CMX_XS_DB_HISTXSteps: Historical Objects (Change Status)1CLNTnvarchar30
139CMX_XS_DB_HOBJXSteps: Historical Objects (Status Table)1CLNTnvarchar30
140CMX_XS_DB_HRELXSteps: Links to Historical Objects (Relationships)1CLNTnvarchar30
141CMX_XS_DB_INSTRXSteps: Process Instructions Table1CLNTnvarchar30
142CMX_XS_DB_INSTRTXSteps: Texts for Process Instruction Table1CLNTnvarchar30
143CMX_XS_DB_METAXSteps: Metadata1CLNTnvarchar30
144CMX_XS_DB_METATXSteps: Texts for Metadata1CLNTnvarchar30
145CMX_XS_DB_NOBJXSteps: Non-Historic Objects (Table of States)1CLNTnvarchar30
146CMX_XS_DB_NRELXSteps: Links to Non-Historic Objects (Relationships)1CLNTnvarchar30
147CMX_XS_DB_PREDXSteps: Predecessor1CLNTnvarchar30
148CMX_XS_DB_PREXXSteps: Predecessor before the Generation1CLNTnvarchar30
149CMX_XS_DB_PSXSteps: Parameter, Definition in DB Format SMALL1CLNTnvarchar30
150CMX_XS_DB_PSLXSteps: Parameter, LIVE Data in DB Format SMALL1CLNTnvarchar30
151CMX_XS_DB_PSLTXSteps: Texts for Parameters, LIVE Data in DB Format SMALL1CLNTnvarchar30
152CMX_XS_DB_PSTXSteps: Texts for Parameters in DB Format SMALL1CLNTnvarchar30
153CMX_XS_DB_REFXSteps: Step References Table1CLNTnvarchar30
154CMX_XS_DB_REFTXSteps: Texts for Step Reference Table1CLNTnvarchar30
155CMX_XS_DB_ROOTXSteps: Step Root1CLNTnvarchar30
156CMX_XS_DB_ROOTTXSteps: Texts for Step Root1CLNTnvarchar30
157CMX_XS_DB_STEPXSteps: Step Table1CLNTnvarchar30
158CMX_XS_DB_STEPTXSteps: Text for Step Table1CLNTnvarchar30
159CMX_XS_DB_TREEXSteps: Tree Characteristics1CLNTnvarchar30
160CMX_XS_DB_VLXSteps: Values in DB Format LARGE1CLNTnvarchar30
161CMX_XS_DB_VLTXSteps: Texts for Values in DB Format LARGE1CLNTnvarchar30
162CMX_XS_DB_VMXSteps: Values in DB Format MEDIUM1CLNTnvarchar30
163CMX_XS_DB_VMTXSteps: Texts for Values in DB Format MEDIUM1CLNTnvarchar30
164CMX_XS_DB_VSXSteps: Values in DB Format SMALL1CLNTnvarchar30
165CMX_XS_DB_VSTXSteps: Texts for Values in DB Format SMALL1CLNTnvarchar30
166CMX_XS_DB_XNSCXSteps: BAdI Exits, Release of Namespaces in Client1CLNTnvarchar30
TOPProcess Order
167COCR_CMX_DB_CO43Assignment Production Scheduling Profile and Standard XStep1CLNTnvarchar30
168COCR_CMX_DB_CRContext Data for Root Node1CLNTnvarchar30
169COCR_CMX_DB_CSContext Data for XSteps1CLNTnvarchar30
TOPSAP List Viewer
170SALV_GZT_ADMINSALV GUI Administration Settings1CLNTClientnvarchar30
TOPWeb Dynpro ALV for ABAP
171SALV_WD_ADMINSALV WD Administration Settings1CLNTClientnvarchar30
TOPWorkforce Management Core
172/SAPAPO/LRPRTYPEObsolete since 200: WFM Resource Types1CLNTClientnvarchar30
173/SAPAPO/LRPRTYPTObsolete since 200: Texts for WFM Resource Types1CLNTClientnvarchar30
174/SAPAPO/LRPTSRTAAssignment of Resource Types and Time Specification Types1CLNTClientnvarchar30
175WFDCS_APPCFGapplication configuration1CLNTClientnvarchar30
176WFDCS_REQACTIONSrequest actions1CLNTClientnvarchar30
177WFDCS_REQMNGMNTrequest management data1CLNTClientnvarchar30
178WFDCS_REQMNGRSregistered request managers1CLNTClientnvarchar30
179WFDCS_REQMSGSrequest messages: warnings, errors, etc1CLNTClientnvarchar30
180WFDCS_REQUESTScalculation requests1CLNTClientnvarchar30
181WFDCS_SOLVERSregistered calculation solvers1CLNTClientnvarchar30
182WFD_RESTYPESWFD Resource Types Text Table1CLNTClientnvarchar30
183WFD_RESTYPESTWFD Resource Types1CLNTClientnvarchar30