07-30-2008 8:02 PM
Hi Guys,
I have 2 tables ZHEADER and ZLINE. In the table ZHEADER all i have is key fields which are foreign keys of
ZLINE.
PROBLEM: I want to create a Maintenance view in which i can do the maintenance for both the tables from SM30.
In the join conditions when i key in ZHEADER and click on Relationship button it doesn't pull up the fields as expected.
What can be wrong ?
For Reference the Structure of both the tables is as follows.
ZHEADER
Field Data type Key
MANDT MANDT X
PERNR PERSNO X
PLAN_TYPE TEXT6 X
PLAN_BASIS TEXT6 X
QUARTER TEXT6 X
FYEAR TEXT4 X
ZLINE
Field Data type Key
MANDT MANDT X
PERNR PERSNO X
BEGDA DATUM
ENDDA DATUM
ENAME EMNAM
Amandeep
07-30-2008 8:13 PM
u should go for View Cluster Maintenance .
View Cluster Maintenance is a collection of various views into a joint maintenance interface with a joint navigation area, which belong logically or hierarchically to a commercially or technically complex function. View clusters are created in Generate table maintenance dialog (SE54). You can maintain related data in several tables/views consistently in a view cluster. In other words, it can be said that a view cluster is the set of objects, such as views, reports or tables, which belong to one business function. The data can be arranged either hierarchically or non-hierarchically in view cluster. Through this utility one can view / edit cross-table data in a single transaction. The transaction navigation box shows the complex business object with its components or sub-components, like master-detail data. Through view cluster, one can actually perform the operations like:
u2022 Navigate among the object at various hierarchies
u2022 Display table entries
u2022 Create new table entries
u2022 Change the existing ones
u2022 Delete entries
u2022 Create / View / Edit child data for a combination of master and detail data
u2022 Print a customized list
u2022 Analyze tables
u2022 Save work at any level in the object hierarchy
07-30-2008 8:33 PM
07-30-2008 8:50 PM
Can't we create Maintenance views for tables which don't have language as a key. I have seen 95% of the Maintenance views for Text Tables.
A