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

84 columns | Print definition?ERP 6.0  | VISIBLE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/SAPSRM/C_MDFSBMeta Data Configuration for Set Fields8VISIBLEPDO Field Property "Visible"nvarchar10
2/SAPSRM/C_MDFSBBBO specific Restriction of Set Field Metadata7VISIBLEPDO Field Property "Visible"nvarchar10
3/SAPSRM/C_MDFSBCCustomer Table for Configuration of Set Field Metadata8VISIBLEPDO Field Property "Visible"nvarchar10
4/SAPSRM/C_MDFSBLLook-Up Table BO specific Restriction of Set Field Metadata8VISIBLEPDO Field Property "Visible"nvarchar10
5/SAPSRM/C_MDFSDMeta Data Configuration for Dependant object Fields6VISIBLEPDO Field Property "Visible"nvarchar10
6/SAPSRM/C_MDFSDBDependant object Field Metadata5VISIBLEPDO Field Property "Visible"nvarchar10
7/SAPSRM/C_MDFSDLLook-Up Table for Dependant Object/Set Field Metadata6VISIBLEPDO Field Property "Visible"nvarchar10
8/SAPSRM/C_MDF_H1Meta Data Configuration for Business Object Header Fields7VISIBLEPDO Field Property "Visible"nvarchar10
9/SAPSRM/C_MDF_HBBackground Table for Meta Data Config. for Header Fields5VISIBLEPDO Field Property "Visible"nvarchar10
10/SAPSRM/C_MDF_HCCustomer Meta Data Configuration for BO Header Fields7VISIBLEPDO Field Property "Visible"nvarchar10
11/SAPSRM/C_MDF_HDMeta Data Configuration for Business Object Header Fields7VISIBLEPDO Field Property "Visible"nvarchar10
12/SAPSRM/C_MDF_HLLook-Up Table for Meta Data Configuration for Header Fields6VISIBLEPDO Field Property "Visible"nvarchar10
13/SAPSRM/C_MDF_I1Meta Data Configuration for Business Object Item Fields9VISIBLEPDO Field Property "Visible"nvarchar10
14/SAPSRM/C_MDF_IBBackground Table for Meta Data Configuration for Item Fields7VISIBLEPDO Field Property "Visible"nvarchar10
15/SAPSRM/C_MDF_ICCustomer Meta Data Configuration for BO Item Fields9VISIBLEPDO Field Property "Visible"nvarchar10
16/SAPSRM/C_MDF_ILLook-Up Table for Meta Data Configuration for Item Fields8VISIBLEPDO Field Property "Visible"nvarchar10
17/SAPSRM/C_MDF_ITMeta Data Configuration for Business Object Item Fields9VISIBLEPDO Field Property "Visible"nvarchar10
18/SAPSRM/C_MDF_S1Meta Data Configuration for Set Fields9VISIBLEPDO Field Property "Visible"nvarchar10
19/SAPSRM/C_META_HMeta Data Cnofiguration for Business Object Header Fields5VISIBLEPDO Field Property "Visible"nvarchar10
20/XFT/EPA_CDTALDocument types: Alias/visibility10VISIBLEFunction Visiblenvarchar10
21/XFT/EPA_CFUNPROCustom functions: Visibility - Processing6VISIBLEFunction Visiblenvarchar10
22/XFT/EPA_CKPR001Functions - Element Types kpro - Visibility - Processing7VISIBLEFunction Visiblenvarchar10
23/XFT/EPA_CSPFNode Functions: Visibility7VISIBLEFunction Visiblenvarchar10
24/XFT/EPA_CTSFFile functions: Visibility6VISIBLEFunction Visiblenvarchar10
25/XFT/EPA_T0004Log settings4VISIBLEFunction Visiblenvarchar10
26BBPC_META_ITMMeta Data for Items Types5VISIBLEVisiblenvarchar10
27DOUI_ELEMDBOS Cockpit: Screen Element15VISIBLEDBOSC-CR: Generated ID (30)nvarchar300
28FBICRC_C_OV_ALLICR: Overview Chart with Multi Company Displayed3VISIBLEDisplay Chart on Chipsnvarchar10
29GRACEUPCONFIGEnd User Personalization Fields7VISIBLEVisible for EUPnvarchar10
30sap_perfcntr5visiblevarchar320
31T7PIQFS_ACT_SCENAction Scenario Table4VISIBLEVisiblenvarchar10
TOPApplication Frame
32CRMC_UI_BR_DLGDetails of Direct Link Groups (on Business Role Level)5VISIBLEVisibility of Direct Link Groups on Business Role Levelnvarchar10
33CRMC_UI_ROLE_DL1Display Direct Links per Role6VISIBLESingle-Character Ind.: Link Visible in Direct Link Groupnvarchar10
34CRMC_UI_ROLE_DL2Display Direct Links per Role5VISIBLESingle-Character Ind.: Link Visible in Direct Link Groupnvarchar10
35CRMC_UI_ROLE_DLGDisplay Direct Links per Role5VISIBLESingle-Character Ind.: Link Visible in Direct Link Groupnvarchar10
TOPApplication Framework
36USMD101CUI Model: Layout of Web Interface11VISIBLEVisiblenvarchar10
TOPBalanced Scorecard
37UMB_RB100Report Builder: Header Table4VISIBLEFlag (X or Blank)nvarchar10
TOPBusiness Navigator
38DF14LApplication Components21VISIBLEVisibilty Flagnvarchar10
TOPClassification System New
39CME_ST_CHARATRCharacteristic: Global Attributes9VISIBLEVisiblenvarchar10
40CME_ST_CHARATRHCharacteristic: Global Attributes7VISIBLEVisiblenvarchar10
TOPDangerous Goods Management
41TDG81Dynamic Tab Titles for Dangerous Goods Master7VISIBLETab Page Visiblenvarchar10
TOPFinancials Basis
42FINB_TACSYST_MFNObsolete !!! Valuation Systm: Meta Description - Field Names14VISIBLEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPGlobal Trade Services
43/SAPSLL/TCOEUIUser Interface Control Settings4VISIBLEControl: User Interface Field Is Visiblenvarchar10
TOPGovernance, Risk and Compliance
44GRPC_MCF_CUSFLDCustom Field UI configuration5VISIBLEVisible flagnvarchar10
45GRPC_MCF_SAP_ATTDynamic SAP Attributes properties6VISIBLEVisible flagnvarchar10
TOPIncentive and Commission Management ICM
46TCACS_PACKDEFList of All Packages5VISIBLEVisibility of Package (' '=CACSPACK, '2'=1Click)nvarchar10
TOPIntegration of FPM and Persistency Frameworks like BOPF
47/BOFU/IPBI_POWLAPOWL: Action Definition4VISIBLEVisiblenvarchar10
TOPLocalization
48FPIA_FIELDSTAT_CField status control for IoA fields6VISIBLEDisplay Mode Enablednvarchar10
49FPIA_FIELDSTAT_SField status control for IoA fields (SAP)5VISIBLEDisplay Mode Enablednvarchar10
TOPMaintenance Orders
50/MRSS/C_BUT_NAVINavigation buttons to launch transactions5VISIBLEDisplay pushbutton on the application barnvarchar10
51/MRSS/C_SGU_CNTRDefine layout: container item6VISIBLEVisisbility of containernvarchar10
52/MRSS/C_SGU_CONDefine layout: container item5VISIBLEVisisbility of containernvarchar10
53/MRSS/C_SGU_CONTDefine layout: container item6VISIBLEVisisbility of containernvarchar10
54/MRSS/C_SGU_CVARDefine layout: container item6VISIBLEScreen Content Item Displaynvarchar10
TOPMaintenance Processing
55/MRSS/C_DPR_UIConfiguration of UI elements in C Projects5VISIBLEVisiblenvarchar20
56/MRSS/C_RM_CVUIcustomizing for other resources and outlook export3VISIBLEVisiblenvarchar20
TOPManagement of Internal Controls
57FOPCSTARTPAGEStart Page Configuration5VISIBLEVisiblenvarchar10
TOPMobile Applications
58/ISDFPS/METFLDCustomizing: Field Properties (Mobile Application)5VISIBLEVisibilitynvarchar10
TOPMove-InOut
59TECAMIOFLDVISIS-U: Pre-entry Variants / Field Visibility6VISIBLEField Visibilitynvarchar10
TOPPeople Centric UI Framework Customizing
60CRMC_VSET_PERSPersonalization Data View Set Group9VISIBLEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPPersonal Object Worklist
61POWL_EASY_DEFFieldcat and Selection Criteria for Easy-POWL Feeder7VISIBLESpecifies if column is visible or hidden by defaultnvarchar10
TOPPortfolio Management
62/RPM/OBJ_CUS_UIObject type customizing for UI6VISIBLEVisiblenvarchar10
63/RPM/OBJ_SAP_UIObject type SAP UI Fields5VISIBLEVisiblenvarchar10
64/RPM/PORT_FLD_UIPortfolio Fields UI7VISIBLEVisiblenvarchar10
65RPM_DX_FIELDSDX Fileds4VISIBLEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPPrice Planning Workbench
66WRFT_PPW_TSHP_HTree Profile Hierarchy7VISIBLEVisiblenvarchar10
67WRFT_PPW_TSHP_HDDefault for Hierarchy Tree Profile6VISIBLEVisiblenvarchar10
TOPProcess Controls
68GRPCSTARTPAGEStart Page Configuration5VISIBLEVisiblenvarchar10
TOPProcess Management
69POC_DB_C_METADATDomain Model: Local Value Collection6VISIBLEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')nvarchar10
TOPPublic Sector Contract Accounts Receivable and Payable
70TFMCA_COREL_UIUI Setting for Relationship Maintenance6VISIBLEIndicator: Visible Fieldnvarchar10
71TFMCA_TF_UI_HCustomizing Table for Table Form Header Table UI6VISIBLEVisiblenvarchar10
72TFMCA_TF_UI_LCustomizing Table for Table Form Line Item Table UI6VISIBLEVisiblenvarchar10
TOPQualifications and Requirements
73T77PPHR-PD: Profile Maintenance - Sub-profile Names7VISIBLEFlag: sub-profile activenvarchar10
74T77PR_V_H_PPA-PD: Profile - Assign Views to Headers to Subprofiles6VISIBLEFlag: sub-profile activenvarchar10
TOPSAP Business Workflow
75SWFDLOGCMPLog Manager: Components of a Log Type3VISIBLEVisibility of a Component of a Log Typenvarchar10
TOPSAP Healthcare - Industry-Specific Components for Hospitals
76TN2DWS_COMPDWS Component Management5VISIBLEDWS: Component with or Without GUInvarchar10
TOPShift Planning
77T77EJInfo Column: Pre-sets4VISIBLECheckbox: Info column visible on entry screennvarchar10
TOPTraining Management
78LSOTACASECTIONAssessment - Section4VISIBLEFlag for Section Visiblenvarchar10
TOPWorkforce Management Application
79WFAC_QUERY_FIELDQuery fields info includes label, type, etc3VISIBLEWhether this field should be visible or notnvarchar10
80WFAEM_FIELD_AUI screen group field attributes4VISIBLEShould appear on screen flagnvarchar10
81WFAEM_SGRP_AAttributes for UI screen groups4VISIBLEShould appear on screen flagnvarchar10
TOPWorkforce Management Core
82WFMC_QUERY_FIELDQuery fields info includes label, type, etc3VISIBLEWhether this field should be visible or notnvarchar10
83WFMEM_FIELD_AUI screen group field attributes4VISIBLEShould appear on screen flagnvarchar10
84WFMEM_SGRP_AAttributes for UI screen groups4VISIBLEShould appear on screen flagnvarchar10