ABAPFIELD_DESCRIPTOR - FIELD DESCRIPTOR
CL_GUI_FRONTEND_SERVICES - Frontend Services CPI1466 during BackupThis documentation is copyright by SAP AG.
Field descriptor
Variants:
1. f
2. dbtab~field
3. tabalias~field
Effect
Used in the SELECT,OPEN CURSOR,UPDATE and DELETE commands to uniquely identify columns (fields) ofdatabase tables andviews specified in FROM clauses.
Variant 1
f
Effect
Identifies the field f of a database table or view specified in the FROMclause. The name f may only occur once in all database tables or views, that is, it mustbe unique. You use this variant particularly when there is only one table specified in the FROM clause. If the uniqueness of the field cannot be guaranteed, you must use variant 2 or 3.
Example
Output a list of all customers whose names begin with 'A':
DATA: WA_SCUSTOM TYPE SCUSTOM.
SELECT * FROM SCUSTOM INTO WA_SCUSTOM WHERE NAME LIKE 'A%'.
WRITE: / WA_SCUSTOM-ID, WA_SCUSTOM-NAME.
ENDSELECT.
Variant 2
dbtab~field
Effect
Identifies field f in the database table or view dbtab specified in the FROMclause. The combination dbtab~field must be unique. You can use this variantif table dbtab only appears once in the FROM clause. If this uniqueness cannot be assured, you must use variant 3.
Example
Output a list of all customers whose names begin with 'A':
DATA: WA_SCUSTOM TYPE SCUSTOM.
SELECT * FROM SCUSTOM INTO WA_SCUSTOM
WHERE SCUSTOM~NAME LIKE 'A%'.
WRITE: / WA_SCUSTOM-ID, WA_SCUSTOM-NAME.
ENDSELECT.
Variant 3,,tabalias~field
Effect
Identifies field f in the table or view with the alias name tabalias specified in the FROM clause.
Example
Output a list of all customers whose name begins with 'A':
DATA: WA_SCUSTOM TYPE SCUSTOM.
SELECT * FROM SCUSTOM AS T INTO WA_SCUSTOM WHERE T~NAME LIKE 'A%'.
WRITE: / WA_SCUSTOM-ID, WA_SCUSTOM-NAME.
ENDSELECT.
Additional help
BAL Application Log Documentation General Data in Customer Master
This documentation is copyright by SAP AG.
Length: 3885 Date: 20120522 Time: 055414 triton ( 148 ms )
