cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a custom table

former_member253394
Participant
0 Kudos

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 UnitEmployee ID
1001E111
1000E112
1010E113



Can you please suggest how to proceed with this requirement.


Thanks,

Malkit Singh


Accepted Solutions (1)

Accepted Solutions (1)

former_member761937
Discoverer
0 Kudos

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.

former_member253394
Participant
0 Kudos

Hi Praveen,

Actually i was asking the same but in the C4C.

Can you tell me How to create in C4C SDK.

Thanks,

Malkit

TomK
Advisor
Advisor
0 Kudos

Hi Malkit,

you can create a new Custom BO with a 0..n node, that stores your two fields.

node ExampleNode [0,n] {

     element A:xxxx;

     element B:xxxx;

}

In the UI-Designer you can for example use an AdvancedListPane to show and edit the node content.

Best regards

Tom


former_member253394
Participant
0 Kudos

Thanks Tom,

So Where should i create Advanced list pane......i mean on which screen?

should i use EC or on any other screen?

if EC need to be used ? how should i add this in the existing workcenter?

Can you please explain this in brief ?

Regards,

Malkit

TomK
Advisor
Advisor
0 Kudos

Hi Malkit,

this depends on your business requirement?

Where do you want to show this information?

Best regards

Tom

former_member253394
Participant
0 Kudos

Tom,

Supposed i have the requirement to maintain advanced list pain for two fields Sales Unit and Employee ID and that should be present Under sales Work center as different work center view and that can be managed by the user.

Regards,

Malkit Singh

TomK
Advisor
Advisor
0 Kudos

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


Answers (2)

Answers (2)

sumeet_narang
Active Participant
0 Kudos

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

sunil1101
Employee
Employee
0 Kudos

Hi Malkit,

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

Regard

Sunil