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

75 columns | Print definition?ERP 6.0  | EXTERNAL_ID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BIC/B0000151000PSA for 0DPR_PROJECT_ATTR T90CLNT090 Proj. Def. Attr.9EXTERNAL_IDnvarchar240
2/CPD/D_PFP_PHPlan Header4EXTERNAL_IDExternal ID for Financial Plannvarchar440
3/IWFND/I_MED_MEXmaps an external identifier to the mapping5EXTERNAL_IDgeneric place holder for an external object identifiernvarchar400
4CLB2C_APPL_DATACollaboration: Application Settings for a Target Server5EXTERNAL_IDCollaboration: Application ID at Collaboration Platformnvarchar2550
5CNV_MBT_ACT_RECActivity record - info about DMIS DEL Activities8EXTERNAL_IDMBT PCL: Session IDnvarchar200
6DMC_ACT_RECActivity record - info about the execution of DMC activities7EXTERNAL_IDExternal identifier of an MWB activitynvarchar400
7DMC_TABSPACE_SIZDMC : Tabelle zum Speichern von Tab.platz-Größe1EXTERNAL_IDExternal identifier of an MWB activitynvarchar400
8DOTM_SYSDBOSC-TM: System7EXTERNAL_IDDBOSC-CR: Generated ID (30) Lower Casenvarchar300
9GRRMOBLOSEVTMain Entity Table for Loss Events3EXTERNAL_IDExternal ID of Loss Eventnvarchar500
10GRRMOBLOSEVTHMain Entity Table for Loss Events - History Table4EXTERNAL_IDExternal ID of Loss Eventnvarchar500
11HRSFI_D_ONB_IMPSuccessFactors: Staging Area for Onboarding Applicants5EXTERNAL_IDExternal Id for New Hire Applicantntext10737418230
12RSPMPROCESSRSPM Process Directory9EXTERNAL_IDExternal IDnvarchar400
13T7BREFD_EVEXTTable to link between intern.event ID and external event ID2EXTERNAL_IDExternal event IDnvarchar640
14T7BREFD_STLOGEvent status log11EXTERNAL_IDExternal event IDnvarchar640
15WFAL_GUID_2_SMKMapping-Table GUID - semantic key3EXTERNAL_IDExternal Identifiernvarchar200
16ZDPR_OBJLINKObject link data storage for DPR11EXTERNAL_IDKey of the linked objectnvarchar2550
17ZRPM_OBJ_LINKObject link data storage7EXTERNAL_IDKey of the linked objectnvarchar2550
18ZRPM_STATUSRPM Status2EXTERNAL_IDBusiness Object IDnvarchar240
TOPBRFplus - ABAP-Based Business Rules
19FDT_ACTN_1010FDT: Action - Message Log8EXTERNAL_IDFDT: Universal Unique Identifiernvarchar320
20FDT_ACTN_1010AFDT: Action - Message Log8EXTERNAL_IDFDT: Universal Unique Identifiernvarchar320
21FDT_ACTN_1010SFDT: Action - Message Log7EXTERNAL_IDFDT: Universal Unique Identifiernvarchar320
22FDT_ACTN_1010TFDT: Action - Message Log7EXTERNAL_IDFDT: Universal Unique Identifiernvarchar320
TOPCommon Functions
23INM_INITIATIVEInitiative Master Table5EXTERNAL_IDInitiative IDnvarchar240
24INM_INIT_CDInitiative- Pseudo table for change documents5EXTERNAL_IDInitiative IDnvarchar240
TOPExternal Project Management Tools
25DPR_XML_TRANSTable for Transporting Templates2EXTERNAL_IDIdentification of Entitiesnvarchar240
TOPGeneric Project Planning
26CGPL_ARCH_IDXProject Planning: Index of Archived Projects3EXTERNAL_IDProject Planning: External Indentifier of an Elementnvarchar240
27CGPL_PROJECTProject Planning: Attribute Table for Project Headers3EXTERNAL_IDProject Planning: External Indentifier of an Elementnvarchar240
28CGPL_TASKProject Planning: Attribute Table for Activities3EXTERNAL_IDProject Planning: External Indentifier of an Elementnvarchar240
TOPGrantor Management
29GTR_CRM_GPMCRM Grantor Program Management: Mapping ID/LOGSYS -> GUID2EXTERNAL_IDGrantor Program External Identifier (CRM)nvarchar240
TOPLean Staffing
30SAWE_ENHANCED_FCEnhanced Forecast Objects6EXTERNAL_IDStaff Assignment External IDnvarchar100
TOPLine Maintenance
31/ISDFPS/LM_FLIFlight20EXTERNAL_IDExternal IDnvarchar120
TOPLoans Management
32TDLOS_MAP_TARIFLoan Origination: Assignment of Insurance Rates4EXTERNAL_IDKey for Insurance Ratenvarchar80
TOPMaster Data
33TDCLI_INSURANCETable of Credit Life Insurance Rates2EXTERNAL_IDKey for Insurance Ratenvarchar80
34TDCLI_INSURANCETText Tables for CLI - Rates3EXTERNAL_IDKey for Insurance Ratenvarchar80
35TDCLI_INS_1Table of Credit Life Insurance Rates1EXTERNAL_IDKey for Insurance Ratenvarchar80
TOPObject Links
36DPR_OBJLINKObject Link11EXTERNAL_IDExternal Identification of Linked Objectntext10737418230
TOPPortfolio Management
37/RPM/BUCKET_DOperational bucket persisted data3EXTERNAL_IDBusiness Object IDnvarchar240
38/RPM/COLLECTN_DCollection Persisted Data3EXTERNAL_IDBusiness Object IDnvarchar240
39/RPM/HIERARCHY_DStrategic hierarchy persisted data3EXTERNAL_IDBusiness Object IDnvarchar240
40/RPM/ITEM_DOperational item persisted data3EXTERNAL_IDBusiness Object IDnvarchar240
41/RPM/ITEM_HOperational item persisted data3EXTERNAL_IDBusiness Object IDnvarchar240
42/RPM/PORTFOLIO_DPortfolio Operational persisted data3EXTERNAL_IDBusiness Object IDnvarchar240
43/RPM/PORTFOLIO_SPortfolio Details persisted data3EXTERNAL_IDBusiness Object IDnvarchar240
44/RPM/RELATION_DPortofolio relation object persisted data6EXTERNAL_IDBusiness Object IDnvarchar240
45/RPM/REVIEW_DPortfolio Review Persisted Data3EXTERNAL_IDBusiness Object IDnvarchar240
46/RPM/WHATIF_DWhat If Persisted Data3EXTERNAL_IDBusiness Object IDnvarchar240
47RPM_BUCKET_D_CDBucket - Pseudo table for change documents3EXTERNAL_IDBusiness Object IDnvarchar240
48RPM_COLLECTN_CDCollection - Pseudo table for change documents3EXTERNAL_IDBusiness Object IDnvarchar240
49RPM_DOCUMENTDocument data storage6EXTERNAL_IDIDnvarchar240
50RPM_F4LABEL_TABProject ID display selection field structure2EXTERNAL_IDExternal_ID described in Long Text for helpnvarchar240
51RPM_FES_PRJ_ASGNAssignments for Project Manager22EXTERNAL_IDProject Planning: External Indentifier of an Elementnvarchar240
52RPM_FES_PRJ_ROLEAssignments for Project Manager22EXTERNAL_IDProject Planning: External Indentifier of an Elementnvarchar240
53RPM_FES_RES_ASGNTo be deleted22EXTERNAL_IDProject Planning: External Indentifier of an Elementnvarchar240
54RPM_FES_RES_ROLETo be deleted22EXTERNAL_IDProject Planning: External Indentifier of an Elementnvarchar240
55RPM_ITEM_D_CDItem details - Pseudo table for change documents3EXTERNAL_IDBusiness Object IDnvarchar240
56RPM_ITEM_H_CDItem header - Pseudo table for change documents3EXTERNAL_IDBusiness Object IDnvarchar240
57RPM_OBJ_LINKObject link data storage7EXTERNAL_IDExternal Identifier String of Linked Objectntext10737418230
58RPM_OBJ_LINK_CDObject links - Pseudo table for change documents7EXTERNAL_IDExternal Identifier String of Linked Objectntext10737418230
59RPM_PORTFOLIO_CDPortfolio attributes - Pseudo table for change documents3EXTERNAL_IDBusiness Object IDnvarchar240
60RPM_PROJECT_ARCHProjects in archive2EXTERNAL_IDIDnvarchar240
61RPM_RELATERPM: Relationship table16EXTERNAL_IDIDnvarchar240
62RPM_RELATE_BKUPRPM: Relationship table16EXTERNAL_IDIDnvarchar240
63RPM_RELATION_CDPortofolio Relations - Pseudo table for change documents6EXTERNAL_IDBusiness Object IDnvarchar240
64RPM_REVIEW_CDPortfolio Review - Pseudo table for change documents3EXTERNAL_IDBusiness Object IDnvarchar240
65RPM_WHATIF_D_CDWhat If Scenario - Pseudo table for change documents3EXTERNAL_IDBusiness Object IDnvarchar240
TOPProject Management
66CGPL_ARCH_IDX_VSProject Plan: Index of Archived Projects5EXTERNAL_IDProject Planning: External Indentifier of an Elementnvarchar240
67CGPL_ENTITYCGPL Entities5EXTERNAL_IDIdentification of Entitiesnvarchar240
TOPPromotion
68WAKHPromotion Header Data, IS-R93EXTERNAL_IDCGPL Project External IDnvarchar240
TOPReturnable Packaging Logistics
69RLEXTIDConversion of External Partner Descriptions6EXTERNAL_IDDescription of Object at Partnernvarchar350
TOPSocial Services and Social Security
70PSSCD_SXPSXP Header Data7EXTERNAL_IDTransaction Numbernvarchar100
TOPStreamWork ABAP Library
71CLBC_APPLI_DATACollaboration: Application Settings for a Target Server5EXTERNAL_IDCollaboration: Application ID at Collaboration Platformnvarchar2550
TOPTransaction Manager
72TCORIC_SWIFT_FRMFormat-dependent attributes for SWIFT message types5EXTERNAL_IDExternal format IDnvarchar150
TOPWeb Service and SOAP - ABAP
73SRT_CON_SYSTEMSSOAManager Connectivity : Remote systems for connectivity4EXTERNAL_IDExternal Service identifiernvarchar320
74SRT_IDENTIFIERService identifier2EXTERNAL_IDExternal Service identifiernvarchar320
TOPWorkforce Management Application
75WFA_TIMOFFREQTime off Requests19EXTERNAL_IDExternal Identifiernvarchar200