What are the types of tables in SAP?
Answers were Sorted based on User's Feedback
Answer / rajesh.vellur
The Answer Number 4 is wrong there no such a TABLE called
Hashed Table....Hashed Table is the concept of sorting an
Internal Table such as..1)standard Table..2)Sorted Table..3)
Hashed Table..
so thr are only 3 types of table in SAP .
1- Transperent Table
2- Cluster Table
3-Pool Table
| Is This Answer Correct ? | 75 Yes | 2 No |
Answer / bibhubrata sahoo
There are 3 types of table in SAP .
1- Transperent Table
2- Cluster Table
3-Pool Table
| Is This Answer Correct ? | 71 Yes | 4 No |
Answer / sapien
Transparent Table: Exists with the same structure both in
the dictionary and database exactly with same data and
fields. it's to store transaction data. It's one to one
relation table
Pool tables: These are logical tables must be assigned to a
table pool when they are defined. its use to store control
data. its many to one relation table
Clustered tables: these also logical tables and must be
assigned to table cluster when they are defined. Its also
used to store control data. used to store temporary data or
text ex., documentation. It's also many to one relation
table.
| Is This Answer Correct ? | 47 Yes | 3 No |
Answer / kamala kannan
1- Transperent Table - It has one to one relationship with
DB table
2- Cluster Table - It has Many to one relationship with DB
table
3-Pool Table -It has Many to one relationship with DB table
| Is This Answer Correct ? | 38 Yes | 2 No |
SAP ABAP table types:-->
1)Transparent Table: Exists with the same structure both in
the dictionary and database exactly with same data and
fields. it's to store transaction data. It's one to one
relation table
2)Pool tables: These are logical tables must be assigned to a
table pool when they are defined. its use to store control
data. its many to one relation table
3)Clustered tables: these also logical tables and must be
assigned to table cluster when they are defined. Its also
used to store control data. used to store temporary data or
text ex., documentation. It's also many to one relation
table.
4)Internal Table such as..
1)standard Table..2)Sorted Table..3)Hashed Table..
| Is This Answer Correct ? | 17 Yes | 4 No |
Answer / anupa
Hi,
Refer below link on how to find table names and field names
in SAP.
http://learnsaptips.blogspot.com/2010/08/how-to-find-table-names-and-field-names.html
| Is This Answer Correct ? | 6 Yes | 4 No |
Answer / guest
there are mant tables in each functional like MM,PP, Fi,co
etc
some of table sin MM are Marc,Mast,Mard etc...
| Is This Answer Correct ? | 13 Yes | 43 No |
Explain the concept of split valuation and when can it be used? What are the settings required?
How does 'automatic account assignment' work in mm?
What are the types of special stocks available?
Outline 'stock valuation methods' for material revaluation?
Material number has to be 30 Digit. So how to get this is SAP? The present 18 Digit is NOT at all sufficient for the business? It has to be Alpha Numeric or sometimes only numbers. It must be external numbering system only & not the SAP generated internal number range because material number or name is given by Vendors. Ex: ABC1234, 89900-0098-8987, Y778-009, 77777766665444433322211-A, etc
Can I include the parameters like cost centre,plant.account assignmnet category,purchasing group in PR release strategy with classification which is at header level????
Explain the 'transaction keys' in mm?
What is purchase requisition as related to sap?
How is master data important in mm module?
What is a business area?
Explain subcontracting cycle
Can you manually create purchase requisition with reference to documents such as purchase order or scheduling agreement?
SAP Basis (1262)
SAP ABAP (3939)
SAPScript (236)
SAP SD (Sales & Distribution) (2717)
SAP MM (Material Management) (912)
SAP QM (Quality Management) (99)
SAP PP (Production Planning) (523)
SAP PM (Plant Maintenance) (252)
SAP PS (Project Systems) (138)
SAP FI-CO (Financial Accounting & Controlling) (2766)
SAP HR (Human Resource Management) (1180)
SAP CRM (Customer Relationship Management) (432)
SAP SRM (Supplier Relationship Management) (132)
SAP APO (Advanced Planner Optimizer) (92)
SAP BW (Business Warehouse) (896)
SAP Business Workflow (72)
SAP Security (597)
SAP Interfaces (74)
SAP Netweaver (282)
SAP ALE IDocs (163)
SAP Business One (110)
SAP BO BOBJ (Business Objects) (388)
SAP CPS (Central Process Scheduling) (14)
SAP GTS (Global Trade Services) (21)
SAP Hybris (132)
SAP HANA (700)
SAP PI (Process Integration) (113)
SAP PO (Process Orchestration) (25)
SAP BI (Business Intelligence) (174)
SAP BPC (Business Planning and Consolidation) (38)
SAP BODS (Business Objects Data Services) (49)
SAP BODI (Business Objects Data Integrator) (26)
SAP Ariba (9)
SAP Fiori (45)
SAP EWM (Extended Warehouse Management) (58)
Sap R/3 (150)
SAP FSCM Financial Supply Chain Management (101)
SAP WM (Warehouse Management) (31)
SAP GRC (Governance Risk and Compliance) (64)
SAP MDM (Master Data Management) (0)
SAP MRS (Multi Resource Scheduling) (0)
SAP ESS MSS (Employee Manager Self Service) (13)
SAP CS (Customer Service) (0)
SAP TRM (Treasury and Risk Management) (0)
SAP Web Dynpro ABAP (198)
SAP IBP (Integrated Business Planning) (0)
SAP OO-ABAP (Object Oriented ABAP) (70)
SAP S/4 HANA Finance (Simple Finance) (143)
SAP FS-CD (Collections and Disbursements) (0)
SAP PLM (Product Lifecycle Management) (0)
SAP SuccessFactors (33)
SAP Vistex (0)
SAP ISR (IS Retail) (28)
SAP IdM (Identity Management) (0)
SAP IM (Investment Management) (0)
SAP UI5 (59)
SAP SCM (Supply Chain Management) (51)
SAP XI (Exchange Infrastructure) (49)
SAP Cloud Platform (34)
SAP Testing (89)
SAP SolMan (Solution Manager) (63)
SAP MaxDB (116)
SAP GUI (15)
SAP AllOther (329)