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

106 columns | Print definition?ERP 6.0  | CASE_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BST_MDG_CCCleansing Case Change Requests2CASE_GUIDData Cleansing Case: Globally Unique Identifiervarbinary160
2GRFNCASEISCase table of Issue2CASE_GUIDUUID in character formnvarchar320
3GRRMANALYSIS_TSAnalysis Table2CASE_GUIDCase GUIDnvarchar320
4GRRMANASSMNTAssessment Table2CASE_GUIDCase GUIDnvarchar320
5GRRMANDATAAnalysis Data2CASE_GUIDCase GUIDnvarchar320
6GRRMPROPRESPONSETable for Response Proposal2CASE_GUIDResponse Proposal - GUIDnvarchar320
7ZCASE_ADD_ATTRZusätzliche Case-Attribute2CASE_GUIDTechnischer Schlüssel des Falles (Fall-GUID)nvarchar320
8ZPHDEMO_ATTRTAB2Case Attributes2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
TOPAccounts Receivable Accounting Process Integration
9FDM_BUFFERCluster for Decoupling in 1-System Scenario3CASE_GUIDFSCM-DM: GUID (Internal Key of Dispute Case)nvarchar320
10FDM_CDISCONFLICTFSCM-DM: Conflicts in Automatic Assignment of Items to Cases2CASE_GUIDFSCM-DM: GUID (Internal Key of Dispute Case)nvarchar320
11FDM_CDISPROPOSALFSCM-DM: Proposal for Assignment of OIs to Cust.-Init. Disp.7CASE_GUIDFSCM-DM: GUID (Internal Key of Dispute Case)nvarchar320
12FDM_COLL_TROBJFSCM-COL: Trigger Table for Collections Management7CASE_GUIDFSCM-DM: GUID (Internal Key of Dispute Case)nvarchar320
13FDM_LDDBFSCM-DM: Log And Delay Database2CASE_GUIDUUID in character formnvarchar320
14FDM_P2P_ATTRAttributes of Promise to Pay; Required for Process Integratn2CASE_GUIDFSCM-DM: GUID (Internal Key of Dispute Case)nvarchar320
15FDM_P2P_INSTMNTInstallments in Promise to Pay with Installment2CASE_GUIDFSCM-DM: GUID (Internal Key of Dispute Case)nvarchar320
TOPBasic Functions
16BIW_EMMA_CASEDelta Queue for Process Statistics for Clarification Cases3CASE_GUIDGUID of Clarification Casevarbinary160
17EMMA_CASEClarification Case3CASE_GUIDGUID of Clarification Casevarbinary160
18UDMCASEATTR00Dispute Case Attributes2CASE_GUIDUUID in character formnvarchar320
19UDMCASEATTR10Dispute Case Attribute for Account Balance (FI-CA)2CASE_GUIDUUID in character formnvarchar320
20UDMCASEATTR20Collection Case Attributes2CASE_GUIDUUID in character formnvarchar320
21UDM_P2P_ATTRPromise to Pay2CASE_GUIDFSCM-DM: GUID (Internal Key of Dispute Case)nvarchar320
22UDM_T_CORRCONTFSCM-DM: Container (Dialog Correspondence)2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
23UKMCASEATTR00Attribute of Credit Case2CASE_GUIDUUID in character formnvarchar320
24UKM_DCD_ATTRAttributes of a Documented Credit Decision2CASE_GUIDUUID in character formnvarchar320
TOPCase Management
25SCMG_T_CASECase: Entity Table for Case2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
26SCMG_T_CASE_ATTRCase Attributes2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
TOPCollections Management
27UDM_COLL_ITEMCASOpen Items with Dispute Case5CASE_GUIDFSCM-DM: GUID (Internal Key of Dispute Case)nvarchar320
TOPContract Accounts Receivable and Payable
28DFKKCASEITEMSItem List in Cases, Lines2CASE_GUIDGUID for Item Listnvarchar320
29DFKKCASEITEMSHItem List in Cases, Header Data2CASE_GUIDGUID for Item Listnvarchar320
30DFKKCCUPDATEItem Lists to Which Changes Were Made2CASE_GUIDGUID for Item Listnvarchar320
TOPEmployee Interaction Center
31THREIC_ACTIVITYEIC Activity2CASE_GUIDEIC: GUIDnvarchar320
32THREIC_KS_ATTRSpecific Attributes for Knowledge Search in EIC2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
33THREIC_PER_ALRTSEIC: Personal Alerts2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
34THREIC_SLA_ALRTActivities Selected by SLA Alert Program3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
35THREIC_SLA_ALRTSActivities Selected by SLA Alert Program2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
TOPEngineering Change Record
36/PLMI/ECR_HDREngineering Change Record Header data2CASE_GUIDEngineering Record GUID (Technical Key)nvarchar320
TOPGlobal Trade Services
37/SAPSLL/CMLBPCase Management Audit Business Partners2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
38/SAPSLL/CMLCDCase Management Audit Customs Document2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
39/SAPSLL/CMLPRCase Management Audit Customs Product2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
40/SAPSLL/CMPARAttributes of a Case for Case Management Integration2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
TOPGrantor Management
41CRMD_GRM_CASECase Relation3CASE_GUIDnvarchar320
TOPGRC Risk Management
42GRRMANALASSMNTAssessment Table2CASE_GUIDCase GUIDnvarchar320
43GRRMANALYSISAnalysis Table2CASE_GUIDCase GUIDnvarchar320
44GRRMANALYSISDATAAnalysis Data2CASE_GUIDCase GUIDnvarchar320
45GRRMPROPOSERISKPropose risk2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
46GRRMRESPONSETable for Response2CASE_GUIDCase GUIDnvarchar320
47GRRMVALIDATIONAnalysis Table2CASE_GUIDCase GUIDnvarchar320
TOPHR Administrative Services
48T5ASRARCHINDEXASR: Archiving Index Table2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
49T5ASRCONTCASELNKAssignment of Data Container to Case2CASE_GUIDKey for Process, Scenario, or Process Stepnvarchar320
50T5ASRDOCCASELNKAssignment of Attachments to Case5CASE_GUIDKey for Process, Scenario, or Process Stepnvarchar320
51T5ASRPROCESSESHR Administrative Services: Processes2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
52T5ASRSCENARIOSHR Administrative Services: Scenarios2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
53T5ASRSTEPSHR Administrative Services: Process Steps (Work Items)2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
54T5SSCXSSSERVICESXSS Self-Service Instances2CASE_GUIDKey for Self-Servicenvarchar320
TOPInternal Collection Procedure
55UHCCASEATTR20Collection Case Attributes2CASE_GUIDUUID in character formnvarchar320
56UHC_CASE_ALISTActions in Collection Case2CASE_GUIDUUID in character formnvarchar320
TOPLegal Case Management for ILM
57LHM_CASE_ATTRTable with Additional Attributes for Legal Hold Cases2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
58LHM_LEGAL_HOLDSOBSOLETE3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
59LHM_LH_ARCHIVEDLegal Holds in Archive Files5CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
60LHM_PROPAGATEStores Legal Holds for Archive Files2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
61SLCM_COMMENTSILM: Legal Case Management - Comments3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
62SLCM_EDIS_RUNILM: Legal Case Management- Executed E-Discovery Reports3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
63SLCM_HIS_AL_DELILM: Legal Case Management - History Deleted AL Docs3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
64SLCM_HIS_BOR_DELILM: Legal Case Management - History Deleted BOR Objects4CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
65SLCM_LH_ALILM: Legal Case Management - Legal Hold Table for AL Doc.3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
66SLCM_LH_BORILM: Legal Case Management - Legal Hold Table for BOR Obj.3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
67SLHM_CASE_HEADLegal Hold Management - Cases (Header Data)2CASE_GUIDLegal Case IDnvarchar320
TOPManagement of Internal Controls
68FOPCCASEASAssessment2CASE_GUIDUUID in character formnvarchar320
69FOPCCASECLONECase Copy Information3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
70FOPCCASEISIssue2CASE_GUIDUUID in character formnvarchar320
71FOPCCASEPLRemediation Plan2CASE_GUIDUUID in character formnvarchar320
72FOPCCASETEAttributes: Testing2CASE_GUIDUUID in character formnvarchar320
73FOPCCASETLTest log2CASE_GUIDUUID in character formnvarchar320
74FOPCCASEUPGRADEMIC Case: Information of Upgrade2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
75FOPCDEFICANAMIC: Deficiency Analysis3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
76FOPCRPLCINFO2Replacement Information: Case3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
TOPOrganizational Flexibility
77/ISDFPS/ORGMOrganizational Measure Attributes2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
78/ISDFPS/ORGMAREAMeasure Area Attributes2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
TOPPayment Transactions
79FPCL_DETECT_COGarnishments for a Payment Document6CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
80FPCR_CESSGarnishment Register Attributes2CASE_GUIDUUID in character formnvarchar320
81FPCR_LINK_OBJLinked Objects for Garnishment2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
82FPCR_REDUCTIONReduction Data for Garnishment2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
TOPPersonnel Administration
83PA3246HR Master Record for Infotype 3246 (Legal Hold)25CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
TOPProcess Controls
84GRPCCASEASAssessment2CASE_GUIDUUID in character formnvarchar320
85GRPCCASECLONECase Copy Information3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
86GRPCCASECPCAPA Plan2CASE_GUIDUUID in character formnvarchar320
87GRPCCASEISIssue2CASE_GUIDUUID in character formnvarchar320
88GRPCCASEPLRemediation Plan2CASE_GUIDUUID in character formnvarchar320
89GRPCCASETEAttributes: Testing2CASE_GUIDUUID in character formnvarchar320
90GRPCCASETLTest log2CASE_GUIDUUID in character formnvarchar320
91GRPCCASEUPGRADEObsolete : PC Case: Information of Upgrade2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
92GRPCDEFICANAPC: Deficiency Analysis3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
93GRPCRPLCINFO2Replacement Information: Case3CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
TOPPublic Sector Contract Accounts Receivable and Payable
94DFMCA_FORMSData Table for Tax Forms5CASE_GUIDTechnical Key of Formnvarchar320
95DFMCA_FORM_CONTSData Table for Data Container Key2CASE_GUIDTechnical Key of Formnvarchar320
96DFMCA_FPF_HISFPF: Form Processing History2CASE_GUIDTechnical Key of Carrying Objectnvarchar320
97DFMCA_RETURNData Table for Tax Returns2CASE_GUIDTechnical Key of Carrying Objectnvarchar320
98DFMCA_RETURN_MData Table for Additional Accounting Data in Return2CASE_GUIDTechnical Key of Carrying Objectnvarchar320
99DFMCA_RETURN_OData Table for Tax Returns5CASE_GUIDTechnical Key of Carrying Objectnvarchar320
100DFMCA_TAX_CASEData Table for Tax Cases2CASE_GUIDUUID in character formnvarchar320
101DFMCA_TC_PERSData Table for Periods of Tax Case2CASE_GUIDUUID in character formnvarchar320
TOPQuality Management
102ZPH_ATTR_CASE1Pharman: Medical Engineering Case Attributes2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
TOPRecords and Case Management
103RMPS_CASE_KYWORDCase: Key Words2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
104RMPS_DOD_T_CATTRDoD Attributes for Folder (Case)2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
105RMPS_PRO_T_CATTRPRO Attributes for Folder (Case)2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320
106RMPS_T_CASE_ATTRDOMEA Attributes for Cases2CASE_GUIDTechnical Case Key (Case GUID)nvarchar320