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

85 columns | Print definition?ERP 6.0  | CASE_TYPE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1GRFNCASECLASScase class1CASE_TYPECase Typenvarchar40
2GRFNOWPBSOffline working process business senario2CASE_TYPECase Typenvarchar40
3GRFNOWPENBLBSOWP enable Business Scenario2CASE_TYPECase Typenvarchar40
4GRFNWFTASKNAMEGRFN workflow task name maintenance table4CASE_TYPECase Typenvarchar40
5GRPCEVIDLVLKCFGLevel of Evidence level entity config3CASE_TYPECase Typenvarchar40
TOPAccounts Receivable Accounting Process Integration
6FDM_AR_MAPPINGFSCM-DM: Determination of Values of Source and Target Fields3CASE_TYPEFSCM-DM: Case Typenvarchar40
7FDM_AR_SOURCEFLDFSCM-DM: Selection of Source Fields for Synchronization3CASE_TYPEFSCM-DM: Case Typenvarchar40
8FDM_AR_SYNCFSCM-DM: Settings for Determination of Attribute Values3CASE_TYPEFSCM-DM: Case Typenvarchar40
9FDM_DCATTRFSCM-DM Integration: Dispute Case Attributes3CASE_TYPECase Typenvarchar40
10TFDM_BDREASONFSCM-DM: Default Values for Company Code2CASE_TYPECase Typenvarchar40
11TFDM_BDREASONTFSCM-DM: Default Values for Company Code3CASE_TYPECase Typenvarchar40
12TFDM_CUSTDISPFSCM-DM: Activation for Customer-Initiated Dispute Cases3CASE_TYPECase Typenvarchar40
13TFDM_DEFCCFSCM-DM: Default Values for Company Code4CASE_TYPECase Typenvarchar40
14TFDM_GENERICTABFSCM-DM: Generic Table Values of Original and Target Fields3CASE_TYPEFSCM-DM: Case Typenvarchar40
15TFDM_MAPPINGFSCM-DM: Generic Table Values of Original and Target Fields3CASE_TYPEFSCM-DM: Case Typenvarchar40
16TFDM_P2PCCSettings for Promise to Pay per Company Code3CASE_TYPECase Typenvarchar40
17TFDM_SOURCEFIELDFSCM-DM: Source Fields Synchronization of Attributes3CASE_TYPEFSCM-DM: Case Typenvarchar40
18TFDM_WRITEOFF02FSCM-DM: Default Values for Writing Off Dispute Cases3CASE_TYPECase Typenvarchar40
TOPBasic Functions
19UDMATTR_RCCODETRoot Cause Code3CASE_TYPECase Typenvarchar40
20UDMCASEATTRSYNCFSCM-DM: Relevant Attributes for Synchronization2CASE_TYPECase Typenvarchar40
21UDMCASEPROCESSORRegular Processor for Dispute Cases2CASE_TYPECase Typenvarchar40
22UDMEVENT_PARADefine the Effect of Events on Dispute Cases2CASE_TYPECase Typenvarchar40
23UDMPUBLISHPARACase: Parameters for the Transfer to External Applications2CASE_TYPECase Typenvarchar40
24UDM_AUTOSTAT_P2PFSCM-DM: Automatic Status for Promise to Pay2CASE_TYPECase Typenvarchar40
25UDM_AUTO_STATUSFSCM-DM: Automatic Status2CASE_TYPECase Typenvarchar40
26UDM_AUTO_TEXTIDText ID Used to Include Notes2CASE_TYPECase Typenvarchar40
27UDM_T_PROC_STATProcessing Status for Dispute Cases2CASE_TYPECase Typenvarchar40
28UKM_DCD_AUTOSTATAutomatic Status for Closing2CASE_TYPECase Typenvarchar40
29UKM_DCD_CASETYPECase Types for Documented Credit Decisions4CASE_TYPECase Typenvarchar40
30UKM_DCD_PDFFORMPDF Forms for Documented Credit Decision2CASE_TYPECase Typenvarchar40
31UKM_STATUSFSCM-CR: Status to be Set for a Case Type2CASE_TYPECase Typenvarchar40
TOPBusiness Partners
32NIPRAddnl HC-Specific Ins. Prov. Relatshp Data for SAP BP5CASE_TYPEIS-H: Case Typenvarchar10
TOPCase Management
33SCMGARCHCASETable for Archiving Customizihg2CASE_TYPECase Typenvarchar40
34SCMGATTR_CATEGOCategories2CASE_TYPECase Typenvarchar40
35SCMGATTR_CATEGOTCategories3CASE_TYPECase Typenvarchar40
36SCMGATTR_REASONCase: Reasons2CASE_TYPECase Typenvarchar40
37SCMGATTR_REASONTCase: Reasons3CASE_TYPECase Typenvarchar40
38SCMGCASETYPECase: Case Type2CASE_TYPECase Typenvarchar40
39SCMGCASETYPETCase: Text Table for Case Type3CASE_TYPECase Typenvarchar40
40SCMGCOPYCASECustomizing for Case Copy2CASE_TYPECase Typenvarchar40
41SCMG_T_CASE_ATTRCase Attributes3CASE_TYPECase Typenvarchar40
TOPCommand and Support Relationships
42/ISDFPS/CSHLPCustomizing for the HR Search Helps4CASE_TYPEUsage Typenvarchar10
TOPContract Accounts Receivable and Payable
43DFKKCASEITEMSHItem List in Cases, Header Data3CASE_TYPECase Typenvarchar40
TOPForce Element
44/ISDFPS/CCTYPECustomizing Usage Types2CASE_TYPEUsage Typenvarchar10
45/ISDFPS/CCTYPERCustomizing Table for Links2CASE_TYPEUsage Typenvarchar10
46/ISDFPS/CCTYPETCustomizing Usage Types - Text Table3CASE_TYPEUsage Typenvarchar10
47/ISDFPS/FORCEMAuthorized Materials6CASE_TYPEUsage Typenvarchar10
48/ISDFPS/FORMCAttributes of the Material Container-Force Element Relatshp15CASE_TYPEUsage Typenvarchar10
49/ISDFPS/FORMCHAttributes of the Material Container - HR Relationship15CASE_TYPEUsage Typenvarchar10
50/ISDFPS/FORMPHAttributes of the HR - MPO Relationship15CASE_TYPEUsage Typenvarchar10
51/ISDFPS/FORMPOAttributes of the Force Element - MPO Relationship15CASE_TYPEUsage Typenvarchar10
TOPGovernance, Risk and Compliance
52GRFN_BI_EVALTYPETranslation from Case Type/Category to Evaluation Type2CASE_TYPECase Typenvarchar40
TOPGRC Risk Management
53GRRMRESPCASEUPDNotify Risk about Control Results2CASE_TYPECase Typenvarchar40
TOPLegal Case Management for ILM
54LHMATTR_LHTYPELegal Hold Case: Legal Hold Type2CASE_TYPECase Typenvarchar40
55LHMATTR_LHTYPETLegal Hold Case: Legal Hold Type3CASE_TYPECase Typenvarchar40
TOPManagement of Internal Controls
56FOPCCASECLONECase Copy Information4CASE_TYPECase Typenvarchar40
57FOPCCASETYPESUsed Case Type and Case Categories2CASE_TYPECase Typenvarchar40
58FOPCSIGNOFF_ISDeactivate Issue Types for Sign-Off2CASE_TYPECase Typenvarchar40
TOPMaterial Categories
59/ISDFPS/MPO_PROTLog of Data Transfers into MPO44CASE_TYPEUsage Typenvarchar10
TOPMaterials Management
60/ISDFPS/ORG_UM_WCross-Plant Reorganizations16CASE_TYPEUsage Typenvarchar10
TOPMobile Human Resources Management
61/ISDFPS/MEHRTCTPCustomizing: Usage Types Relevant for the Mobile Application2CASE_TYPEUsage Typenvarchar10
TOPOrganizational Flexibility
62/ISDFPS/CHCMSHLPAdditional Search Helps for Object4CASE_TYPEUsage Typenvarchar10
63/ISDFPS/T77OS_EXEA-DFPS: Structure Search3CASE_TYPEUsage Typenvarchar10
TOPPersonnel Categories
64/ISDFPS/USAGE_EVEvaluation of Organizational Structure by Usage Type3CASE_TYPEUsage Typenvarchar10
TOPProcess Controls
65GRPCASDUEDATEDue date extend for repeat work2CASE_TYPECase Typenvarchar40
66GRPCASDUEDATE_TText table for GRPCASDUEDATE3CASE_TYPECase Typenvarchar40
67GRPCCASECLONECase Copy Information4CASE_TYPECase Typenvarchar40
68GRPCCASETYPESUsed Case Type and Case Categories2CASE_TYPECase Typenvarchar40
69GRPCREPFRQsettings for frequency of repeat work2CASE_TYPECase Typenvarchar40
70GRPCREPWORKSettings for repeated action2CASE_TYPECase Typenvarchar40
71GRPCREPWORK_TText table for GRPCREPWORK3CASE_TYPECase Typenvarchar40
72GRPCSIGNOFF_ISDeactivate Issue Types for Sign-Off2CASE_TYPECase Typenvarchar40
73GRPC_BW_EVALTYPETranslation from Case Type/Category to Evaluation Type2CASE_TYPECase Typenvarchar40
TOPRecords and Case Management
74RMPSATTR_REFGENReference Generation Profile2CASE_TYPECase Typenvarchar40
75RMPSATTR_RULNAMRule Names for the Generation of Case Indicators2CASE_TYPECase Typenvarchar40
76RMPSCASETYPEAdditional Characteristics of Case Types2CASE_TYPECase Typenvarchar40
77RMPS_DISPOSALTYType of RMS-ID (disposal, fileplan, ...)7CASE_TYPECase Typenvarchar40
78RMPS_FOLDERTYPEAdditional Folder Types in Fileplan2CASE_TYPECase Typenvarchar40
TOPSAP Business Partner
79COMM_CLEAR_STACKData Cleansing Cases4CASE_TYPEData Cleansing: Application Typenvarchar10
TOPSCM Basis
80CIF_IMFESRIMod Reference Table for Str. Elements and Supply Rels6CASE_TYPEUsage Type for Force Elementsnvarchar10
TOPStructures Workbench
81/ISDFPS/CCRTYPE1Assign Usage Types to Relationship Types2CASE_TYPEUsage Typenvarchar10
82/ISDFPS/CCRTYPE2Relationship Assignment for Each Usage/Relationship Ty. Pair2CASE_TYPEUsage Typenvarchar10
83/ISDFPS/CFDPSA01Structure Tree - Customizing Usage Types3CASE_TYPEUsage Typenvarchar10
84/ISDFPS/USRSTACKStack for Objects Loaded into Structures Workbench6CASE_TYPESingle-Character Indicatornvarchar10
85HRP1950DB Table for Infotype 195023CASE_TYPEUsage Typenvarchar10