Skip to Content

How to create a custom table

Hi,

Can you please tell me how to create a custom Table to maintain the data and that can be modified by the user itself from UI screen itself.


Suppose i have requirement of maintain two field in table for multiple entries as shown:


Sales Unit Employee ID 1001 E111 1000 E112 1010 E113



Can you please suggest how to proceed with this requirement.


Thanks,

Malkit Singh


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 20, 2015 at 06:31 AM

    Creating Custom table using transaction SE11, start with the naming convention as “Z or Y”.

    Table Maintenance Generator (TMG) is a tool which is used to create equipment by which customized tables created by end users can be changed as required, such as making an entry to that table, deleting an entry etc.

    Transaction code to create table maintenance generator in SE93, SM30 table maintenance Generator is used to manually input values to custom table

    Steps to create TABLE MAINTENANCE GENERATOR

    1)      Go to se11 check table maintenance check box under attributes tab

    2)      Utilities- table maintenance Generator-> create function group and assign it under function group            input box. Also assign authorization group default &NC&.

    3)      Select standard recording routine radio in table maintenance generator to move table contents to            quality and production by assigning it to request.

    4)      Select maintained type as single step.

    5)      Maintenance screen as system generated numbers this dialog box appears when you click on              create button

    6)      Save and activate table

    One step, two step in Table Maintenance Generator

    Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.

    Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Malkit Singh

      Hi Malkit,

      you would need to create a WCView and add this via the Extensibility Explorer to the relevant WCF, which would be in your case BYD_COD/SalesOnDemand/Opportunity/UI/COD_Sales_WCF.

      I think you cannot add an EC directly on the WCView. So you would first need to add an OWL to your Custom BO.

      Maybe it would make more sense then not to go with the EC / Node approach.... You could directly define your Custom BO on Root node with your to fields. Each instance of your BO would then reflect one line of your table. Basically the OWL would be your list.

      Another advantage would be, that you can generate the WCView and OWL for your Custom BO :-)!

      Best regards

      Tom


  • avatar image
    Former Member
    Mar 04, 2015 at 10:08 AM

    Hello Malkit,

    You need to create a Business Configuration Object with fields Sales Unit and Employee ID. Then you can create a BC set and BC view for this BCO. You need to assign this BC view to the Implementation Project work center and then create a BAC element to maintain the same.

    You can then add this to the scope of your Implementation project and then the BC view will appear in the Activity list of your project. This can then be maintained by the Administrator.

    You can find more information on this in the studio guide if you want to try this way.

    Regards,

    Sumeet

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 20, 2015 at 10:49 AM

    Hi Malkit,

    Please follow the below post,  there you will find useful video tutorials for custom development in C4C or ByD

    Video-How-To's for SAP Cloud Applications Studio

    Regard

    Sunil

    Add comment
    10|10000 characters needed characters exceeded