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

135 columns | Print definition?ERP 6.0  | LAYOUT

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/IWBEP/I_SBU_PSB: UI perspectives2LAYOUTSB: UI layoutnvarchar10
2/UI2/EDM_PAGEUI2: Page3LAYOUTntext10737418230
3/UI2/PB_C_PAGECache for UI2 Pagebuilding Service: Page Header3LAYOUTntext10737418230
4/UI2/PB_C_PAGEMCache for UI2 Pagebuilding Service: Page Header4LAYOUTntext10737418230
5/XLSO/WEC_ADRLAYWeb Channel Address Layouts2LAYOUTWeb Channel Address Layoutnvarchar20
6DOUI_ELEMDBOS Cockpit: Screen Element26LAYOUTnvarchar30
7DOUI_SCREENDBOS Cockpit: UI Data Model - Basic Screen Properties7LAYOUTnvarchar30
8J_1GWTR1Vendor Tax Certificate Forms3LAYOUTSmart Forms: Form Namenvarchar300
9TFK8156Layouts of Maintenance Dialogs1LAYOUTGroup Definition for Maintenance Dialogs: Layoutnvarchar100
10TFK8156FGroup Fields for Maintenance Dialogs1LAYOUTGroup Definition for Maintenance Dialogs: Layoutnvarchar100
11TFK8156GField Groups for Maintenance Dialogs1LAYOUTGroup Definition for Maintenance Dialogs: Layoutnvarchar100
12TFK8156GTField Groups for Maintenance Dialogs (Texts)2LAYOUTGroup Definition for Maintenance Dialogs: Layoutnvarchar100
13TFK8156TLayouts of Maintenance Dialogs (Texts)2LAYOUTGroup Definition for Maintenance Dialogs: Layoutnvarchar100
14TFK8166CIT Maintenance Dialogs: Layouts1LAYOUTConsumption Item Maintenance Dialogs: Layoutnvarchar100
15TFK8166FCIT Maintenance Dialogs: Specify Fld Groups and Fld Sequence1LAYOUTConsumption Item Maintenance Dialogs: Layoutnvarchar100
16TFK8166GCIT Maintenance Dialogs: Field Groups1LAYOUTConsumption Item Maintenance Dialogs: Layoutnvarchar100
17TFK8166GTField Groups for Maintenance Dialogs (Texts)2LAYOUTConsumption Item Maintenance Dialogs: Layoutnvarchar100
18TFK8166TCIT Maintenance Dialogs: Texts for Layouts2LAYOUTConsumption Item Maintenance Dialogs: Layoutnvarchar100
19T7PIQCORRAPFORMApplication Forms for Ad-Hoc Correspondence5LAYOUTTab in master records: Tab layoutnvarchar40
TOPAdditionals Management
20TWETIS-R Labeling: Check Table Label Types4LAYOUTIS-R Labeling: Layoutnvarchar160
TOPAppropriation Requests
21TAIF1Appropriation request types25LAYOUTAssign Tab Layoutnvarchar40
TOPAsset Maintenance
22TAMLAY0Tab pages in master data: Tab layouts3LAYOUTTab in master records: Tab layoutnvarchar40
23TAMLAY0TTab pages in master data: Tab layout descriptions4LAYOUTTab in master records: Tab layoutnvarchar40
24TAMLAY1Tab pages in master data: Tab titles of layout3LAYOUTTab in master records: Tab layoutnvarchar40
25TAMLAY1TTabs in Master Data: Tab Index Titles4LAYOUTTab in master records: Tab layoutnvarchar40
26TAMLAY2Tab pages in master data: Assignment of group boxes3LAYOUTTab in master records: Tab layoutnvarchar40
TOPBasic Functions
27ANKLAYAsset class: Assignment of tab layouts4LAYOUTTab in master records: Tab layoutnvarchar40
28ANKLAYPAsset class: Assignment of tab layouts5LAYOUTTab in master records: Tab layoutnvarchar40
29EMMAC_BASICBasic Settings for EMMA3LAYOUTTab in master records: Tab layoutnvarchar40
30EMMAC_CWL_BTNCase List: Shortcut Buttons2LAYOUTLayout of Case Listnvarchar40
31EMMAC_CWL_BTNTTexts for Shortcut Buttons2LAYOUTLayout of Case Listnvarchar40
32EMMAC_CWL_SHLLayout of Case Processing List2LAYOUTLayout of Case Listnvarchar40
33EMMAC_CWL_SHLTText for Layout of Case Processing List2LAYOUTLayout of Case Listnvarchar40
TOPBusiness Partner
34TP39Selection Variants5LAYOUTLayout for a Listnvarchar120
TOPBusiness Planning and Simulation
35UPX_LAYOUTEnhanced Planning Layouts: Main Table5LAYOUTParameter Groupnvarchar80
TOPCapacity Leveling
36TCY31CTText table for definitions of charts3LAYOUTGrouping of layout keysnvarchar100
37TCY31DTText table for groupings per layout and chart3LAYOUTGrouping of layout keysnvarchar100
38TCY31FTText table for sorts per layout and chart3LAYOUTGrouping of layout keysnvarchar100
39TCY31GTText table for layout table TCY31_G3LAYOUTGrouping of layout keysnvarchar100
40TCY31_CDefinition of charts for layout2LAYOUTGrouping of layout keysnvarchar100
41TCY31_DDescription of a grouping per layout and chart2LAYOUTGrouping of layout keysnvarchar100
42TCY31_EDefinition of a grouping per layout and chart2LAYOUTGrouping of layout keysnvarchar100
43TCY31_FDescription of a sort per layout and chart2LAYOUTGrouping of layout keysnvarchar100
44TCY31_GDefinition of layouts2LAYOUTGrouping of layout keysnvarchar100
45TCY31_HDefinition of a sort per layout and chart2LAYOUTGrouping of layout keysnvarchar100
46TCY48Profile for the planning table18LAYOUTGrouping of layout keysnvarchar100
47TCY56Profile for planning table (tabular form) in cap. leveling3LAYOUTGrouping of layout keysnvarchar100
TOPChange Document Display and Time Stamp Management
48TBANK_CD_SELSelection Criteria14LAYOUTDefault for Display Formatnvarchar10
TOPCheck Input
49OIUCI_FIELDATTRCheck fields attributes6LAYOUTnvarchar10
TOPCollectionsDisbursements
50IBROSTMDFLTISCD: Broker Report - Default Values Per Item Category11LAYOUTScreen variants: Name of variantnvarchar50
51TIBRDEFAULTSBroker Collections - Default Values for Broker Report9LAYOUTScreen variants: Name of variantnvarchar50
TOPContract Accounts Receivable and Payable
52TFK090AMass Activity Types22LAYOUTTab in master records: Tab layoutnvarchar40
TOPCorporate Performance Monitor
53UMV_TR100Value Driver Tree: Header Table16LAYOUTParameter Groupnvarchar80
TOPCross-Application Components
54J_2GLPP1Table for print task codes7LAYOUTForm Namenvarchar160
55J_5KFH_CLFORMCMPLegal forms in company9LAYOUTName of Form Objectnvarchar300
TOPFinancial Accounting
56J_1GWTC1Withholding tax certificate types3LAYOUTForm Namenvarchar160
TOPForms Processing
57FPLAYOUTForm Objects: Layout11LAYOUTimage21474836470
58FPLAYOUTTForm Objects: Layout - Textual Description6LAYOUTimage21474836470
TOPGeneral Ledger Accounting
59FAGLSKF_LAY_INFOFields Used in Layouts1LAYOUTLayouts for Entering Statistical Key Figuresnvarchar20
TOPGraphic
60TCNONetwork/hierarchy graphics: options profile72LAYOUTMode for aligning graph in networknvarchar10
TOPIntegrated Product and Process Engineering
61CLAYIDLayout - Definition Table for iPPE Tabstrip2LAYOUTLayout Reference Name for iPPE Tab Pagenvarchar200
62CLAYTABLayout - Tab Pages Assignment Table2LAYOUTLayout Reference Name for iPPE Tab Pagenvarchar200
63CRELTABLayout - Object Type Assignment Table5LAYOUTLayout Reference Name for iPPE Tab Pagenvarchar200
64CTABLAYLayout Assignment for Additional Tabstrips4LAYOUTLayout Reference Name for iPPE Tab Pagenvarchar200
65CTXTLAYLayout - Text Table for the iPPE Tabstrip2LAYOUTLayout Reference Name for iPPE Tab Pagenvarchar200
TOPLocalization
66J_1BIMPCONDASAssign Tax Types to Tax Groups for Import Data Upload2LAYOUTMS Excel Layout for Data Uploadnvarchar500
67J_1BIMPLAYOUTRecord MS Excel Layouts for Import Data2LAYOUTMS Excel Layout for Data Uploadnvarchar500
68J_1BIMPLAYOUTTText Table for Layout Descriptions3LAYOUTMS Excel Layout for Data Uploadnvarchar500
69J_1BIMPXLSMAPMap MS Excel Columns to Data Structure Fields2LAYOUTMS Excel Layout for Data Uploadnvarchar500
70J_3R_CLFORMCMPLegal forms in company9LAYOUTName of Layoutnvarchar300
TOPMaterial Categories
71/ISDFPS/CLAYTABCLAYTAB Enhancements for EA-DFPS2LAYOUTLayout Reference Name for iPPE Tab Pagenvarchar200
TOPMusing Tools
72WDKAPPNAVWDK: External navigation targets2LAYOUTNavigation layoutnvarchar20
73WDKAPPNAVDFLTWDK: Default layouts for external navigation2LAYOUTNavigation layoutnvarchar20
74WDKAPPNAVFPWDK: Assignment of ext. navigation layout to floorplan state3LAYOUTNavigation layoutnvarchar20
75WDKAPPNAVFPSWDK: Assignm. of ext. navig. layout to floorplan substate3LAYOUTNavigation layoutnvarchar20
76WDKAPPNAVLAYWDK: Layout of external navigation1LAYOUTNavigation layoutnvarchar20
77WDKAPPNAVLAYTWDK: Text table for WDKAPPNAVLAY2LAYOUTNavigation layoutnvarchar20
78WDKAPPNAVPARWDK: External navigation target parameters2LAYOUTNavigation layoutnvarchar20
79WDKAPPNAVTWDK: Text table for WDKAPPNAV3LAYOUTNavigation layoutnvarchar20
80WDKAPPNAVVARWDK: External navigation -> application specific variants2LAYOUTNavigation layoutnvarchar20
81WDKDYNLAYOUTWDK: Dynamic Layout2LAYOUTLayout variant for dynamic adjustmentsnvarchar100
82WDKLAYOUTDefinition of Layouts2LAYOUTLayout variant for dynamic adjustmentsnvarchar100
83WDKLAYOUTTDefinition of Layouts (Texts)3LAYOUTLayout variant for dynamic adjustmentsnvarchar100
84WDKLAYOUTVALAssignment of Layout3LAYOUTLayout variant for dynamic adjustmentsnvarchar100
TOPOverhead Cost Orders
85AUFLAY0Entity Table: Order Layouts2LAYOUTLayout for Master Data Maintenance Ordersnvarchar40
86AUFLAY1Layouts for the Orders3LAYOUTLayout for Master Data Maintenance Ordersnvarchar40
87AUFLAY2Order Master Data Maintenance: Tab Names3LAYOUTLayout for Master Data Maintenance Ordersnvarchar40
88AUFLAY3Assignment Subscreens: Screens for Order Master Data Maint.2LAYOUTLayout for Master Data Maintenance Ordersnvarchar40
89T003OOrder Types20LAYOUTLayout for Master Data Maintenance Ordersnvarchar40
TOPPersonal Object Worklist
90POWL_ACT_QUERYquery activation data14LAYOUTnvarchar300
TOPPlanning Applications
91UPA_EXP_AFUNCAssignments of Layouts to Web-CCP Application5LAYOUTParameter Groupnvarchar80
TOPProcess Data Documentation
92REBRBatch Record: Overall Profile5LAYOUTDocument profile for batch recordsnvarchar80
93REBR1Batch Record: Layout Profile2LAYOUTDocument profile for batch recordsnvarchar80
94REBR1TBatch Record: Layout Profile2LAYOUTDocument profile for batch recordsnvarchar80
95REBR2Batch Record: Layout Profile2LAYOUTDocument profile for batch recordsnvarchar80
TOPProduction Orders
96COCF_CONF_QTYConfirmation: Table for Subdivided Quantity Postings4LAYOUTLayout for Quantity/Error Combinationnvarchar100
97COCF_CU_Q_LAYLayout of Quantity/Error Combination2LAYOUTLayout for Quantity/Error Combinationnvarchar100
98COCF_CU_Q_LAYTDescription of Layout of Quantity/Error Combination3LAYOUTLayout for Quantity/Error Combinationnvarchar100
99COCF_CU_Q_LAY_IDLayout Assignment to Quantity/Error ID4LAYOUTLayout for Quantity/Error Combinationnvarchar100
100COCF_CU_Q_LINRows of Quantity/Error Combination2LAYOUTLayout for Quantity/Error Combinationnvarchar100
101COCF_CU_Q_LINTQuantity Description for Quantity/Error Combination3LAYOUTLayout for Quantity/Error Combinationnvarchar100
102COCF_SR_CSTF_PDFShift Report: Customer's Own Fields (via BAdI)6LAYOUTLayoutnvarchar120
103TCOAFProfile order progress report18LAYOUTLayout of order progress reportnvarchar10
TOPRegulatory reporting for insurance companies
104TISSR_TP_ALVISSR: Tabelle mit Zuordnung Strukturnamen für ALV-Einsatz8LAYOUTKennzeichen: Eintrag aktivierennvarchar10
TOPResourcen Management
105FRMLC30RMS-FRM: Customizing for Formula Layouts2LAYOUTLayout for Editing Formulasnvarchar80
106FRMLC31RMS-FRM: Formula Layouts Language-Dependent Texts2LAYOUTLayout for Editing Formulasnvarchar80
107FRMLC33RMS-FRM: Layout-Dependent Field Catalog2LAYOUTLayout for Editing Formulasnvarchar80
108PNFRMRMS-FRM: PVS Formula - Item Nodes: Attributes16LAYOUTLayout for Editing Formulasnvarchar80
109RMSAT_STD_LAY_HRMS-ATL: Header Table Layout Standardization2LAYOUTStandardization Layoutnvarchar80
110RMSAT_STD_LAY_HTRMS.ATL: Text Table Layout Standardization2LAYOUTStandardization Layoutnvarchar80
111RMSAT_STD_LAY_PRMS-ATL: Item Table Layout Standardization2LAYOUTStandardization Layoutnvarchar80
112RMSAT_STD_PARA_HRMS-ATL: Header Table Parameter Standardization5LAYOUTStandardization Layoutnvarchar80
113RMSTC_XCL10RMS-TLS: Excel Output: Formatting Profile2LAYOUTFormatting Profile for Output with Microsoft Excelnvarchar100
114RMSTC_XCL11RMS-TLS: Excel Output: Description of Formatting Profiles2LAYOUTFormatting Profile for Output with Microsoft Excelnvarchar100
115RMSTC_XCL13RMS-TLS: Excel Output: Formats2LAYOUTFormatting Profile for Output with Microsoft Excelnvarchar100
TOPSales
116ERP_SLS_WORKSETWorklist Workset6LAYOUTWorkset Layout for Link Groupingnvarchar20
TOPSAP Retail Store
117WSAO_WORK_CTRLRetail Store Store Order: Worklist Control17LAYOUTLayoutnvarchar100
TOPService Data Download
118/SDF/LAYOUTSLayouts3LAYOUTLayoutnvarchar120
TOPService Process Warranty
119WTYSCC_LAYOUTLayout mapping to Profile and Document Type4LAYOUTTab in master records: Tab layoutnvarchar40
TOPStatus and Action Management
120SAMDT_SCHEMASS&AM Schemas14LAYOUTS&AM DT Layout informationnvarchar300
TOPStructures Workbench
121/ISDFPS/CFDPDA07Detail Area - Customizing Assignment Transaction <=> Layout4LAYOUTLayout Reference Name for iPPE Tab Pagenvarchar200
122/ISDFPS/CFDPDA08Detail Area - Customizing Assignment Transaction <=> Layout4LAYOUTLayout Reference Name for iPPE Tab Pagenvarchar200
TOPSyntax, Compiler, Runtime
123TPDASESSIONSTPDA: Debug Sessions6LAYOUTTPDA: Debug Session - Anteil - Layoutnvarchar10
TOPTable Maintenance Tool
124SDMEDPMF1DME: Dialog Pool Metadefinition 'Frame Layouts'1LAYOUTDME: Frame Layout Typesnvarchar200
125SDMEDPMF1TDME: Dialog Pool Metadefinition Texts for 'Frame Layouts'2LAYOUTDME: Frame Layout Typesnvarchar200
126SDMEDPMF2DME: Dialog Pool Metadefinition 'Position Frame Layouts'1LAYOUTDME: Frame Layout Typesnvarchar200
127SDMEDPMF2TDME: Dialog Pool Metadef. Texts for 'Pos. Frame Layouts'2LAYOUTDME: Frame Layout Typesnvarchar200
TOPTransaction Manager
128TCORT_VAR_ASSGNAssignment of ALV variants to Display variant4LAYOUTLayoutnvarchar120
TOPUI Configuration Design Layer
129BSPC_DL_FSLAYFact Sheet Tile Layout2LAYOUTFact Sheet Layoutnvarchar300
130BSPC_DL_FSLAYTFact Sheet Layout3LAYOUTFact Sheet Layoutnvarchar300
131BSPC_DL_FSLAY_TIFact Sheet Tile Layout Tiles2LAYOUTFact Sheet Layoutnvarchar300
TOPWarranty Claim Processing
132CWTY001Claim Types Warranty Claim6LAYOUTScreen Layoutnvarchar40
TOPWeb Channel UM ERP aspects
133ERPC_WEC_ADRLAYWeb Channel Address Layouts2LAYOUTWeb Channel Address Layoutnvarchar20
134ERPC_WEC_ADRLAYTWeb Channel Address Layout Descriptions2LAYOUTWeb Channel Address Layoutnvarchar20
TOPWeb Screen Tools - ABAP
135WDY_UI_ELEM_DEFWeb Dynpro: UI Element Definition7LAYOUTWeb Dynpro: Web Dynpro UI Element Definitionnvarchar600