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

Home | ERP 6.0 
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

68 columns | Print definition?ERP 6.0  | PARENT_GUID

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BSNAGT/FILE_INFFile Status Information20PARENT_GUIDGlobally Unique Identifier for the Messagevarbinary160
2/SYCLO/WB007DevTool: Label table7PARENT_GUIDDevTool: 32 Char GUIDsnvarchar320
3BBPD_PCH_IDXDatabase Table with Hierarchy Index4PARENT_GUIDCategory GUIDvarbinary160
4BBP_CT_ATTACHMAttachment4PARENT_GUIDGUID Parentvarbinary160
5BBP_PDHIERContract Hierarchy Information4PARENT_GUIDHeader GUID of the Parent Nodevarbinary160
6DMC_CU_RUN_OBJTSObject pair for Content Upgrade Analysis4PARENT_GUIDDMC: Globally Unique Key (22 Characters)nvarchar220
7EHPRCD_ICH4ADChapter4: OrgID dependent data2PARENT_GUIDGlobally Unique Identifiervarbinary160
8EHPRCD_ICH4MPUNUSED: Chapter 4: Multiple part entries2PARENT_GUIDGlobally Unique Identifiervarbinary160
9EHPRCD_ICH4TXChapter 4: Text table for Chapter 4 data2PARENT_GUIDGlobally Unique Identifiervarbinary160
10WFAL_GUID_2_SMKMapping-Table GUID - semantic key4PARENT_GUIDGUID 32 used in WFAnvarchar320
11ZPPMC_CPL_T_CACHCache for Delta Posting2PARENT_GUIDApplication Object GUIDvarbinary160
12ZPPMC_CPL_T_COSTplanning positions of project for bapis4PARENT_GUIDGUID for Objectvarbinary160
TOPCentral Part of Product Master
13COMM_CATEGORYCategory5PARENT_GUIDCategory GUIDvarbinary160
14COMM_CATEGORYDELCategories To Be Deleted (Temporary) in Download5PARENT_GUIDCategory GUIDvarbinary160
15COMM_CATEGORYHCategory: History6PARENT_GUIDCategory GUIDvarbinary160
TOPCRM Accruals
16CRM_ACE_OH_DATACRM Accruals: Object Header7PARENT_GUIDGUID of a CRM Order Objectvarbinary160
TOPEnvironment, Health and Safety
17/TDAG/CPA_ICH4ADChapter4: OrgID dependent data2PARENT_GUIDGlobally Unique Identifiervarbinary160
18/TDAG/CPA_ICH4MPUNUSED: Chapter 4: Multiple part entries2PARENT_GUIDGlobally Unique Identifiervarbinary160
19/TDAG/CPA_ICH4TXChapter 4: Text table for Chapter 4 data2PARENT_GUIDGlobally Unique Identifiervarbinary160
TOPEvaluations
20DPR_DASHBOARDDashboard Data for Project4PARENT_GUIDGUID of Superior Objectvarbinary160
TOPGroup Hierarchy
21BUT_HIER_STRUCTBusiness Partner Hierarchy Group - Hierarchy Relationship6PARENT_GUIDGUID of Hierarchy Nodevarbinary160
TOPHR Administrative Services
22POBJD_LEV2LEVLNKLevels Assigned to level2PARENT_GUIDKey Element of POBJ Levelnvarchar320
TOPIntegrated Product and Process Engineering
23INSTANCEIDGeometric Instance: Identification5PARENT_GUIDInternal Number of iPPE Objectvarbinary160
24PNCONiPPE Concept Group6PARENT_GUIDInternal Identification for PVS Objectsvarbinary160
TOPMaintenance Orders
25/MRSS/D_ASG_CHLDstores the link betw. child assignt. and the parent assignt.3PARENT_GUIDGUIDvarbinary160
TOPMaster Data
26CMS_ASTAsset Details5PARENT_GUIDAsset Guid as a parent GUID for a sub-assetvarbinary160
27CMS_AST_HISTAsset Value History4PARENT_GUIDAsset Guid as a parent GUID for a sub-assetvarbinary160
TOPPeople Centric UI Framework
28CRM_BSP_CNTGeneric CRM data container.3PARENT_GUIDUUID in character formnvarchar320
TOPPortfolio Management
29/RPM/BK_VER_CTRLBucket Version Controller Data7PARENT_GUIDGuid for application objectsvarbinary160
30/RPM/BUCKET_DOperational bucket persisted data5PARENT_GUIDGuid for application objectsvarbinary160
31/RPM/CAP_B_CATDemand planning for bucket categories6PARENT_GUIDGuid for application objectsvarbinary160
32/RPM/CAP_B_GROUPDemand planning bucket category groups7PARENT_GUIDGuid for application objectsvarbinary160
33/RPM/CAP_CATDemand Planning Category6PARENT_GUIDGuid for application objectsvarbinary160
34/RPM/CAP_GROUPxRPM Demand planning group object5PARENT_GUIDGuid for application objectsvarbinary160
35/RPM/COLLECTN_DCollection Persisted Data5PARENT_GUIDGuid for application objectsvarbinary160
36/RPM/FIN_B_CATFinancial planning for bucket categories6PARENT_GUIDGuid for application objectsvarbinary160
37/RPM/FIN_B_GROUPFinancial planning bucket category groups7PARENT_GUIDGuid for application objectsvarbinary160
38/RPM/FIN_CATFinancial Category6PARENT_GUIDGuid for application objectsvarbinary160
39/RPM/FIN_GROUPxRPM Financial Group Object5PARENT_GUIDGuid for application objectsvarbinary160
40/RPM/HIERARCHY_DStrategic hierarchy persisted data5PARENT_GUIDGuid for application objectsvarbinary160
41/RPM/ITEM_DOperational item persisted data5PARENT_GUIDGuid for application objectsvarbinary160
42/RPM/ITEM_HOperational item persisted data5PARENT_GUIDGuid for application objectsvarbinary160
43/RPM/ITEM_ILItem Internal Links3PARENT_GUIDGuid for application objectsvarbinary160
44/RPM/PORTFOLIO_DPortfolio Operational persisted data5PARENT_GUIDGuid for application objectsvarbinary160
45/RPM/PORTFOLIO_SPortfolio Details persisted data5PARENT_GUIDGuid for application objectsvarbinary160
46/RPM/RELATION_DPortofolio relation object persisted data8PARENT_GUIDGuid for application objectsvarbinary160
47/RPM/REVIEW_DPortfolio Review Persisted Data5PARENT_GUIDGuid for application objectsvarbinary160
48/RPM/WHATIF_DWhat If Persisted Data5PARENT_GUIDGuid for application objectsvarbinary160
49RPM_BUCKET_D_CDBucket - Pseudo table for change documents5PARENT_GUIDGuid for application objectsvarbinary160
50RPM_CAP_B_CAT_CDBucket demand category - Pseudo table for change documents6PARENT_GUIDGuid for application objectsvarbinary160
51RPM_CAP_B_GRP_CDBucket demand groups - Pseudo table for change docu7PARENT_GUIDGuid for application objectsvarbinary160
52RPM_CAP_CAT_CDDemand Planning Category- Pseudo table for change documents6PARENT_GUIDGuid for application objectsvarbinary160
53RPM_CAP_GRP_CDDemand planning groups - Pseudo table for change documents5PARENT_GUIDGuid for application objectsvarbinary160
54RPM_COLLECTN_CDCollection - Pseudo table for change documents5PARENT_GUIDGuid for application objectsvarbinary160
55RPM_FIN_B_CAT_CDBucket Financial Categories - Pseudo table for change docu6PARENT_GUIDGuid for application objectsvarbinary160
56RPM_FIN_B_GRP_CDBucket financial groups - Pseudo table for change docu7PARENT_GUIDGuid for application objectsvarbinary160
57RPM_FIN_CAT_CDFinancial Category - Pseudo table for change documents6PARENT_GUIDGuid for application objectsvarbinary160
58RPM_FIN_GRP_CDFinancial Group Object - Pseudo table for change documents5PARENT_GUIDGuid for application objectsvarbinary160
59RPM_ITEM_D_CDItem details - Pseudo table for change documents5PARENT_GUIDGuid for application objectsvarbinary160
60RPM_ITEM_H_CDItem header - Pseudo table for change documents5PARENT_GUIDGuid for application objectsvarbinary160
61RPM_ITEM_IL_CDItem Internal Links - Pseudo table for change documents3PARENT_GUIDGuid for application objectsvarbinary160
62RPM_PORTFOLIO_CDPortfolio attributes - Pseudo table for change documents5PARENT_GUIDGuid for application objectsvarbinary160
63RPM_RELATION_CDPortofolio Relations - Pseudo table for change documents8PARENT_GUIDGuid for application objectsvarbinary160
64RPM_REVIEW_CDPortfolio Review - Pseudo table for change documents5PARENT_GUIDGuid for application objectsvarbinary160
65RPM_WHATIF_D_CDWhat If Scenario - Pseudo table for change documents5PARENT_GUIDGuid for application objectsvarbinary160
TOPProduct Lifecycle Management
66CPROW_LOCK_NULLLocked "Null Resources" in the WebDAV Interface2PARENT_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320
TOPRecipe Development
67/PLMB/RPR_PEProcess Element5PARENT_GUIDParent GUIDvarbinary160
TOPSales
68LORD_XSTRINGLean Order: Temporary container for DOC/RTL content, XSTRING3PARENT_GUIDGUID in 'CHAR' Format in Uppercasenvarchar320

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy