steps for creating table
Answers were Sorted based on User's Feedback
Answer / siddharth samal
GO TO SE11 THEN GIVE A NAME AND PRESS THE BUTTON CREATE AND
IT WILL TAKE TO A DIFFERENT SCREEN. GIVE THE SHORT TEXT.
GIVE A PREDIFIENED DOMAIN NAME OR IF YOU WANT TO CREATE
GIVE A NEW NAME STARTING WITH Z AND DOUBLE CLICK IT THE
AFTER THAT GIVE THE DATA ELEMENT.
ACTIVATE THE TABLE AND A PHYSICAL TABLE WOULD BE CREATED IN
THE DATABSE SERVER.
| Is This Answer Correct ? | 19 Yes | 9 No |
Answer / lokesh
There are two types of creating Table :
1) Top-Down Approach
2) Bottom_Up Approach
In top-Down approach, first we Create Table name in SE11
and we go further by creating Data elements and Domains
In Bottom-Up appraoch 1)first we create the Domains ,how
many fields you want in the Dbase table save and activate.
and 2) next goto sell and select Object type as DATA TYPE
give the domain name and assign the corresponding domain
to this data element ..like this we create as many as you
want.
3) Now we create the table that start with 'Z'.
set frist field as Key fields , Save the table in a package
after that Click 'Technical Setting' set the dataclass as
APPL0 and set the size catagory as 0. save and activate .
II) In Top-Down Approach :
First GOTO SE11 :
and select the Object Type as TABLES and give the
Table name that should start with 'Z' and press the create
Button.
It will goes to the Next Screen , they we give
Delivery Class [A] and select the Maintenannce Status as
Maintenance Is allowed , then save it.
Then goto FIELDS TAB there you give the fields in the
fields column and give Data element in the field type. then
give how many fields as you want .. it will ask to ask for
save ...then press 'YES' u can save it in ur package or
save it as a local object.
now it will ask for the creation of the Data element
press yes.
click on the Field label tab and enter the lengths and
descriptions
then press Definition tab and enter the domain ..and
create the domain and mention the datatype in the
datatype fields and length in no.characters fields as
press enter.
and go back to initial screen.and
Click 'Technical Setting' set the dataclass as 'APPL0'
and set the size catagory as '0'. save and activate .
| Is This Answer Correct ? | 17 Yes | 7 No |
Answer / anjireddy bapathu
GO TO SE11 THEN GIVE A NAME with Starting "Z" letter AND PRESS THE CREATE BUTTON.
It will open new screen is " Maintain Table". then enter the short description and enter the "Delivery Class" and Go to "Fields" tab and enter the fields and click save after click "Technical settings" button and enter the "Data class" and "Size Category" click save.
If you have any modify fields in your table go to "Technical settings" and click delete button on top of left corner and click save. After go to "Utilities" and click "Table Maintenance generator". It will navigate to Generation Environment Screen and Enter the "Authorization Group", "Function Group" and "Maintenance Type" click the Paper Symbol in top left corner and go back and click save and activate table.
| Is This Answer Correct ? | 2 Yes | 1 No |
Explain Catch Command in ABAP?
wat is the difference between ALE & EDI?
How to maintain subtotals n grand totals in smart forms?
What are the types of the software component being deployed in the sap?
explains how to handle the table control in bdc
What is meant by read lock? : sap abap data dictionary
What is the significance of hide?
what is a value table?
Hi All, Can u tell me the difference between RFC and BAPI. I know Both are remote enabled.
Explain MM and SD flow from ABAP point of view?
can any body tell what is idoc archieving and how to do that
what is Work flow?
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)