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

82 columns | Print definition?ERP 6.0  | ROLE_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/CPD/D_MP_CONTACMaster Project contact person14ROLE_IDRole IDnvarchar40
2/CPD/D_MP_TEAM_RTeam Role Subnodes5ROLE_IDRole IDnvarchar40
3/CPD/PWSC_RA_MAPTable to Map Role and Aspect ID2ROLE_IDRole IDnvarchar40
4/CPD/PWSC_ROLPIDDBTable: Role Profile, Role ID3ROLE_IDRole IDnvarchar40
5/CPD/PWSC_WSPROLMaster Project Partner Role2ROLE_IDRole IDnvarchar40
6/CPD/PWSC_WSPRRLProject Role3ROLE_IDRole IDnvarchar40
7/CPD/PWSC_WSROLERole for Master Project2ROLE_IDRole IDnvarchar40
8/CPD/PWSC_WS_RLTRole for Master Project2ROLE_IDRole IDnvarchar40
9/OPT/VT_ROLESReporting table: Roles2ROLE_IDRole IDnvarchar40
10/OPT/VT_ROLESDETReporting table: Role mapping5ROLE_IDRole IDnvarchar40
11/OPT/VT_ROLES_TReporting table: Text table for roles2ROLE_IDRole IDnvarchar40
12/OPT/X137Reporting table: Roles2ROLE_IDRole IDnvarchar40
13/OPT/X138Reporting table: Role mapping5ROLE_IDRole IDnvarchar40
14/OPT/X139Reporting table: Text table for roles2ROLE_IDRole IDnvarchar40
15/OPT/Y137Reporting table: Roles2ROLE_IDRole IDnvarchar40
16/OPT/Y138Reporting table: Role mapping5ROLE_IDRole IDnvarchar40
17/OPT/Y139Reporting table: Text table for roles2ROLE_IDRole IDnvarchar40
18/OPT/Z137Reporting table: Roles2ROLE_IDRole IDnvarchar40
19/OPT/Z138Reporting table: Role mapping5ROLE_IDRole IDnvarchar40
20/OPT/Z139Reporting table: Text table for roles2ROLE_IDRole IDnvarchar40
21/PICM/C_RR_MAPRole and responsibility mapping table4ROLE_IDRole IDnvarchar40
22/SAPPSSRM/PRMPPermission assignment4ROLE_IDRole Identifiernvarchar50
23/SAPPSSRM/PRROLEPermission Roles2ROLE_IDRole Identifiernvarchar50
24/SAPPSSRM/PRRO_TLanguage-Specific Text Table for tendering role table2ROLE_IDRole Identifiernvarchar50
25/SAPPSSRM/RL_AUTDefine the Collaboration folder Authorizations for the roles6ROLE_IDRolenvarchar100
26/SLOAP/ROLESLOAS: Role data3ROLE_IDSLOAS: Role IDnvarchar700
27/SLOAP/ROLL2PROFMapping table rolls to profiles2ROLE_IDSLOAS: Berechtigungnvarchar700
28/XPPM/GW_PRT_CUSDefaults Customzing3ROLE_IDRole Namenvarchar300
29ACMATSUBJ2ROLEACM-Admintime: Subjects(Users) assigned to Roles4ROLE_IDACM: UUID of a Rolevarbinary160
30ACMTSTATSUBJ2ROLACM-Admintime: Subjects(Users) assigned to Roles4ROLE_IDACM: UUID of a Rolevarbinary160
31ACMTST_ID_HASHESACMTST: ACMTST-ID-Hashes + their corresponding values5ROLE_IDACM: UUID of a Rolevarbinary160
32CRMD_SHCUT_D_CATDistributed saved search categories4ROLE_IDBusiness Rolenvarchar120
33CRMD_SHCUT_U_CATSaved search categories for users4ROLE_IDBusiness Rolenvarchar120
34DFKKDPR_BP_ROLEIndex Table Business Partner Roles in Transaction Data3ROLE_IDRole of Business Partner in Transaction Datanvarchar20
35FIGEKWC_ROLEIDRole IDs for FI Leagal Forms2ROLE_IDRole IDnvarchar100
36FIGEKWC_ROLEID_TRole IDs for FI Leagal Forms3ROLE_IDRole IDnvarchar100
37FIGEKWC_ROLESRoles for FI Legal Forms3ROLE_IDRole IDnvarchar100
38FIGEKWC_ROLESEQAssign Form Signatures to Roles5ROLE_IDRole IDnvarchar100
39FIGEKWC_ROLES_TText for Role sin FI Legal Forms3ROLE_IDRole IDnvarchar100
40FILFGNC_ROLEIDRole IDs for FI Leagal Forms2ROLE_IDRole IDnvarchar100
41FILFGNC_ROLEID_TRole IDs for FI Leagal Forms3ROLE_IDRole IDnvarchar100
42FILFGNC_ROLESRoles for FI Legal Forms3ROLE_IDRole IDnvarchar100
43FILFGNC_ROLESEQAssign Form Signatures to Roles5ROLE_IDRole IDnvarchar100
44FILFGNC_ROLES_TText for Role sin FI Legal Forms3ROLE_IDRole IDnvarchar100
45GRACBGTECHROLEStores values for Background Job Parameter Value8ROLE_IDObject IDnvarchar500
46GRACBUSROLESNAPBusiness Role Snapshot3ROLE_IDUUID of the GRC object (char32)nvarchar320
47GRACBUSROLEUSERSBusiness Role User Reassignment5ROLE_IDRole IDnvarchar320
48GRACRLCONNStore roles in backend system, incl roles not maint. in ERM2ROLE_IDUUID of the GRC object (char32)nvarchar320
49GRACRLCONNTTable to store role description in backend system3ROLE_IDUUID of the GRC object (char32)nvarchar320
50GRACROLEEXPORTTable for templatory storing the role to be exported2ROLE_IDObject IDnvarchar500
51GRACROLEMGRLCOUNManagement Violated Role Data5ROLE_IDObject IDnvarchar500
52GRACROLEORGRole ORG Level4ROLE_IDUUID of the GRC object (char32)nvarchar320
53GRACROLEUSAGERole Usage6ROLE_IDUUID of the GRC object (char32)nvarchar320
54GRACUSERROLEUser Role Assignment Table5ROLE_IDUUID of the GRC object (char32)nvarchar320
55T5PPBS1BSIADAP: Buttons5ROLE_IDAppraisal Role IDnvarchar20
56T5PPBS1CASIADAP: Column A5ROLE_IDAppraisal Role IDnvarchar20
57T5PPBS1RSIADAP: Roles2ROLE_IDAppraisal Role IDnvarchar20
58ZPPMC_CPL_C_CATSFieldname of Role ID on CATS DB and RFC Destination2ROLE_IDField Namenvarchar300
TOPAppraisal, Valuation, and Survey Tool
59HRHAP_OTHERSAppraisal Document: Additional Participant Assignment6ROLE_IDAppraisal Role IDnvarchar20
60HRHAP_P_APPERAppraisal Document: Part Appraiser Assignment7ROLE_IDAppraisal Role IDnvarchar20
61HRT5024Table Part Infotype 50244ROLE_IDAppraisal Role IDnvarchar20
62T77HAP_C_ROLEAppraisal Category - Role Assignment4ROLE_IDAppraisal Role IDnvarchar20
63T77HAP_ROLEAppraisal Roles2ROLE_IDAppraisal Role IDnvarchar20
64T77HAP_ROLE_TAppraisal Role - Text Table3ROLE_IDAppraisal Role IDnvarchar20
TOPAuthorizations and Access Control Context
65/PLMB/AUTH_ROLESllowed Roles in PLM Core2ROLE_IDRole IDnvarchar300
66HRP7601DB Table for Infotype 760119ROLE_IDRole Namenvarchar300
TOPBP for Production Supervisor
67RMAN_PRSP_RU_SCRAssignment of Confirmation Layout4ROLE_IDRole ID for Confirmation in Portalnvarchar10
TOPClinical System
68N2GL_ITEMPathways: Item of Treatment Pathway12ROLE_IDpathways Responsibility IDnvarchar40
69N2GL_TM_STEPpathways Step of Patient Pathway14ROLE_IDpathways Responsibility IDnvarchar40
TOPConfirmations
70AFRUOrder Confirmations141ROLE_IDRole ID for Confirmation in Portalnvarchar10
TOPCross-Application Components
71ACO_ROLEObject-Related Authorizations for a Role3ROLE_IDRole IDnvarchar300
TOPFloorplan Manager Web Dynpro ABAP
72FPM_SAVED_SEARCHFPM Table for saved searches3ROLE_IDRole Namenvarchar300
73FPM_SSEARCH_APPLFPM Table for saved searches3ROLE_IDRole Namenvarchar300
TOPGateway SAP Data Enablement
74/IWBEP/D_MGW_SUBOData Channel Subscriptions20ROLE_IDRole Namenvarchar300
TOPOffice Suite Program
75SOSP_T_ROLETYP_TRole Type Description3ROLE_IDRole typenvarchar150
76SOSP_T_ROLE_TYPERole Type2ROLE_IDRole typenvarchar150
TOPPortfolio Management
77RPM_FES_PRJ_ROLEAssignments for Project Manager4ROLE_IDRole IDnvarchar300
78RPM_FES_RES_ROLETo be deleted4ROLE_IDRole IDnvarchar300
79RPM_ROLERPM: Role attributes3ROLE_IDIDnvarchar240
TOPRuntime
80SWFGPROLEINSTGuided Procedures: Role Instance2ROLE_IDID of a Guided Procedures Process Rolenvarchar320
TOPSchedule Manager
81KPEP_WL_ROLESAssignment of Role to Object Type5ROLE_IDObject ID of Standard Objectnvarchar80
TOPTalent Management
82T5TMCSRC_SAVEDTMC CSI: Table for Saved Combined Searches3ROLE_IDRole Namenvarchar300