Can we modify data in data base table using view?

Answer Posted / sivaramakrishna

Data base view: On multiple tables using inner join, using this view we can read the table data only can't maintain.

Projection view: On single table to minimize the data base interface using this view we read and maintain the data of single table

Help view: On multiple tables , specially designed for search help.Mostly we don't use help views except for search help.

Maintenance view:On multiple tables using inner join, using this view we can read the data and maintain the data also. But as sap suggested mostly we don't use this view .

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to analysis Background Job for performance Issue?

760


Explain the different types of data dictionary objects?

514


Explain sap abap 3-tier architecture?

729


Does every abap/4 have a modular structure? : abap modularization

693


How does the system handle roll areas for external program components?

619






What is narrow casting and wide casting?

1129


What are interface/conversion programs in SAP?

586


What is the collect statement? How is it different from append?

517


What are conversion routines? : abap data dictionary

582


Which transaction code can I use to analyze the performance of abap program?

550


Explain what are the problems in processing batch input sessions? How is batch input process different from processing on line?

575


Explain about the tables exists in a data dictionary and what are they? : abap data dictionary

625


What are the payroll related infotypes? : abap hr

569


Can you give the Example for the structure of an ABAP program? REPORT... NODES: SPFLI, SFLIGHT. DATA:... INITIALIZATION. AT SELECTION-SCREEN. START-OF-SELECTION. GET SPFLI... GET SFLIGHT... GET SPFLI LATE. END-OF-SELECTION. FORM... ENDFORM.

600


Mention the various databases integrities?

609