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

38 columns | Print definition?ERP 6.0  | ORG_UNIT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1BBP_TARGET_OBJDestination of Target Object in Backend2ORG_UNITResponsible Purchasing Groupnvarchar140
2BBP_USR01Internet user data26ORG_UNITObject IDnvarchar80
3BBP_WS_DETAILSExtension for Table WSI_ENTITY4ORG_UNITResponsible Purchasing Organization Object IDnvarchar120
4CMCBD_BGT_CLAIMBudget claims based on suggest level5ORG_UNITOrganizational Unit IDnvarchar80
5CMCBD_EXCEL_TEMPTemp Table for Excel Upload3ORG_UNITOrganizational Unit IDnvarchar80
6CMCBD_LIQ_DIM_RTRuntime: Planing liquidity item dimension2ORG_UNITOrganizational Unit IDnvarchar80
7CMCBD_PL_LAYOUTPlanning Layout master table2ORG_UNITOrganizational Unit IDnvarchar80
8CMCBD_PL_LIQ_DIMPlanning liquidity item and dimension2ORG_UNITOrganizational Unit IDnvarchar80
9CMCBD_PL_LIQ_PRIPlanning liquidity item priority and based on suggest level2ORG_UNITOrganizational Unit IDnvarchar80
10CMCBD_PL_LIQ_SCPlanning liquidity item and source2ORG_UNITOrganizational Unit IDnvarchar80
11CMCBD_WF_ORGCash Budgeting Org Info3ORG_UNITOrganizational Unit IDnvarchar80
12DMC_FILE_STGMWB: File Settings for an Org. Unit1ORG_UNITMWB: Type of Org. Unit (Global, Proj., Subproj., Conv.Obj. )nvarchar10
13GRRMOBEFFALLCEffects Allocations6ORG_UNITOrgunit IDnvarchar80
14GRRMOBEFFALLCHEffects Allocations - History Table7ORG_UNITOrgunit IDnvarchar80
15PA0906HR Master Record: Infotype 090631ORG_UNITHR IN PS: Proposed Org Unitnvarchar80
16ZHR_ABSENCESAnual Absences for Demo Uploads2ORG_UNITObject IDnvarchar80
17ZHR_ABS_DEMOAnual Absences for Demo Uploads2ORG_UNITObject IDnvarchar80
18ZHR_ABS_MASTERAnual Absences for Demo Uploads2ORG_UNITObject IDnvarchar80
19ZSUPM_WM_INTSuPM and WM integration table3ORG_UNITnvarchar500
TOPBasis Components
20/XFT/INV_QInvoice receipt queue: Header122ORG_UNITOrganizational Unitnvarchar140
21/XFT/INV_Q_SInvoice receipt queue: Header122ORG_UNITOrganizational Unitnvarchar140
TOPCapacity and Resource Planning
22/MRSS/D_RM_BCDATBroadcast Worklist Data6ORG_UNITObject IDnvarchar80
23/MRSS/D_RM_BCHISBroadcast History Table8ORG_UNITObject IDnvarchar80
TOPCentral Part of Product Master
24COMC_SETTYPEAdministrative Tables for Set Types28ORG_UNITIndicator for Organizational Dependencynvarchar100
25COMS_SETTYPE_WZStatus of the Input Fields and Tables in the Set Type Wizard8ORG_UNITStatus of the Input Fields in the Set Type Wizardnvarchar40
TOPCost Center Accounting
26T811PCycle Run Group3ORG_UNITAllocation: Organizational Unitnvarchar100
27T811PCResults of Checks of Assignments for Cycle Run Groups3ORG_UNITAllocation: Organizational Unitnvarchar100
28T811PTCycle Processing Group: Texts4ORG_UNITAllocation: Organizational Unitnvarchar100
TOPDialog People-Centric UI for Products
29COMC_SETTYPE_BSPSet-Type Customizing for BSP Application5ORG_UNITIndicator for Organizational Dependencynvarchar100
TOPDistributed System Landscape
30/ISDFPS/SYNC_EOUALE Systems - Organizational Unit Responsible for Monitoring3ORG_UNITCharacter Field of Length 12nvarchar120
TOPEnvironment, Health and Safety
31/TDAG/RCSC_SLORGSRC: Assign organizational unit to authorization group3ORG_UNITCode of an Organizational Unitnvarchar290
TOPIntegration of Catalogs, Partner Directories OCI, OPI
32BBP_CAT_ENTITYDefiniton of Allowed Catalogs4ORG_UNITResponsible Purchasing Organization Object IDnvarchar120
TOPLean Staffing
33SAWE_ENHANCED_FCEnhanced Forecast Objects11ORG_UNITOrganizational Unitnvarchar80
TOPLocations Location Structure
34EHFNDD_LOC_REVLocation - Revisions20ORG_UNITOrganizational Unit IDnvarchar80
TOPMaintenance Orders
35/MRSS/C_DSG_COLColor Properties for Web Util Report2ORG_UNITObject ID of Resource Planning Nodenvarchar80
36/MRSS/D_SHIFTSStandard Shift Schedule for Organizational Unit2ORG_UNITObject ID of Resource Planning Nodenvarchar80
TOPSAP Retail Store
37WSMAN_PT_BUFFERStore Manager Portal: Buffer for Availability Display7ORG_UNITOrganizational Unitnvarchar80
TOPUser Interface
38WCF_UST_DLDistribution List6ORG_UNITOrganization Object ID (Org. Unit, Position, User)nvarchar120