SAP ABAP Class CL_DEMO_AMDP_VS_OPEN_SQL (Compare AMDP with Open SQL)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-ABA-LA (Application Component) Syntax, Compiler, Runtime
     ⤷ SABAPDEMOS (Package) Demos for ABAP Documentation, not meant for productive use

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Interface implementation (CLASS c. INTERFACES i_ref)	IF_AMDP_MARKER_HDB	Marker Interface for DB Procedures	20131029

Properties

Class	CL_DEMO_AMDP_VS_OPEN_SQL
Short Description	Compare AMDP with Open SQL
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	SABAPDEMOS	Demos for ABAP Documentation, not meant for productive use
Created	20131029	SAP
Last change	20141121
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_DEMO_AMDP_VS_OPEN_SQL has no forward declaration.

Interfaces

#	Interface	Abstract	Final	Description	Created on
1	IF_AMDP_MARKER_HDB	☐	☐	Marker Interface for DB Procedures	20131029

Friends

Class CL_DEMO_AMDP_VS_OPEN_SQL has no friend class.

Attributes

Class CL_DEMO_AMDP_VS_OPEN_SQL has no attribute.

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	AMDP	Instance method	Public	Method		20131029
2	OPEN_SQL_FOR_ALL_ENTRIES	Instance method	Public	Method		20131111
3	OPEN_SQL_NESTED_SELECT	Instance method	Public	Method		20131111
4	OPEN_SQL_SUBQUERY	Instance method	Public	Method		20131111

Events

Class CL_DEMO_AMDP_VS_OPEN_SQL has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	TT_CUSTOMER_INFO	Public	See coding			20131029	tt_customer_info TYPE STANDARD TABLE OF ty_customer_info
2	TT_INVOICE_HEADER	Public	See coding			20131029	tt_invoice_header TYPE STANDARD TABLE OF ty_invoice_header WITH KEY invoice_guid
3	TT_INVOICE_ITEM	Public	See coding			20131029	tt_invoice_item TYPE STANDARD TABLE OF ty_invoice_item
4	TY_CUSTOMER_INFO	Public	See coding			20131029	BEGIN OF ty_customer_info, customer_guid TYPE snwd_bpa-node_key, customer_id TYPE snwd_bpa-bp_id, customer_name TYPE snwd_bpa-company_name, country TYPE snwd_ad-country, postal_code TYPE snwd_ad-postal_code, city TYPE snwd_ad-city, END OF ty_customer_info
5	TY_INVOICE_HEADER	Public	See coding			20131029	BEGIN OF ty_invoice_header, invoice_guid TYPE snwd_so_inv_head-node_key, created_at TYPE snwd_so_inv_head-created_at, paid_at TYPE snwd_so_inv_head-changed_at, buyer_guid TYPE snwd_so_inv_head-buyer_guid, END OF ty_invoice_header
6	TY_INVOICE_ITEM	Public	See coding			20131029	BEGIN OF ty_invoice_item, item_guid TYPE snwd_so_inv_item-node_key, invoice_guid TYPE snwd_so_inv_head-node_key, product_guid TYPE snwd_so_inv_item-product_guid, gross_amount TYPE snwd_so_inv_item-gross_amount, currency_code TYPE snwd_so_inv_item-currency_code, END OF ty_invoice_item

Method Signatures

Method AMDP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CUSTOMER_INFO	Value transfer	☐	Type reference (TYPE)	TT_CUSTOMER_INFO			20131029
2	Exporting	ET_INVOICE_HEADER	Value transfer	☐	Type reference (TYPE)	TT_INVOICE_HEADER			20131029
3	Exporting	ET_INVOICE_ITEM	Value transfer	☐	Type reference (TYPE)	TT_INVOICE_ITEM			20131029
4	Importing	IV_CLNT	Value transfer	☐	Type reference (TYPE)	SY-MANDT			20131029
5	Importing	IV_PAYMENT_DATE	Value transfer	☐	Type reference (TYPE)	D			20131029

Method AMDP on class CL_DEMO_AMDP_VS_OPEN_SQL has no exception.

Method OPEN_SQL_FOR_ALL_ENTRIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CUSTOMER_INFO	Value transfer	☐	Type reference (TYPE)	TT_CUSTOMER_INFO			20131111
2	Exporting	ET_INVOICE_HEADER	Value transfer	☐	Type reference (TYPE)	TT_INVOICE_HEADER			20131111
3	Exporting	ET_INVOICE_ITEM	Value transfer	☐	Type reference (TYPE)	TT_INVOICE_ITEM			20131111
4	Importing	IV_PAYMENT_DATE	Value transfer	☐	Type reference (TYPE)	D			20131111

Method OPEN_SQL_FOR_ALL_ENTRIES on class CL_DEMO_AMDP_VS_OPEN_SQL has no exception.

Method OPEN_SQL_NESTED_SELECT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CUSTOMER_INFO	Value transfer	☐	Type reference (TYPE)	TT_CUSTOMER_INFO			20131111
2	Exporting	ET_INVOICE_HEADER	Value transfer	☐	Type reference (TYPE)	TT_INVOICE_HEADER			20131111
3	Exporting	ET_INVOICE_ITEM	Value transfer	☐	Type reference (TYPE)	TT_INVOICE_ITEM			20131111
4	Importing	IV_PAYMENT_DATE	Value transfer	☐	Type reference (TYPE)	D			20131111

Method OPEN_SQL_NESTED_SELECT on class CL_DEMO_AMDP_VS_OPEN_SQL has no exception.

Method OPEN_SQL_SUBQUERY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CUSTOMER_INFO	Value transfer	☐	Type reference (TYPE)	TT_CUSTOMER_INFO			20131111
2	Exporting	ET_INVOICE_HEADER	Value transfer	☐	Type reference (TYPE)	TT_INVOICE_HEADER			20131111
3	Exporting	ET_INVOICE_ITEM	Value transfer	☐	Type reference (TYPE)	TT_INVOICE_ITEM			20131111
4	Importing	IV_PAYMENT_DATE	Value transfer	☐	Type reference (TYPE)	D			20131111

Method OPEN_SQL_SUBQUERY on class CL_DEMO_AMDP_VS_OPEN_SQL has no exception.

History

Last changed by/on	SAP	20141121
SAP Release Created in	740