SAP ABAP Table DEMO_SCUSTOM (Create Control Table Flight Customers)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-TWB-TST-ECA (Application Component) eCATT Extended Computer Aided Test Tool
     ⤷ SECATT_DEMO (Package) eCATT: Tutorial, Training Objects, Examples

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DEMO_SCUSTOM	Table Relationship Diagram
Short Description	Create Control Table Flight Customers

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	S_MANDT	MANDT	CLNT	3	0	Client	T000
2	ID	☑	S_CUSTOMER	S_BUSPANUM	NUMC	8	0	Customer Number	SBUSPART
3	NAME	☐	S_CUSTNAME	S_CUSTNAME	CHAR	25	0	Customer name
4	FORM	☐	S_FORM	S_TEXT15	CHAR	15	0	Form of address
5	STREET	☐	S_STREET	S_STREET	CHAR	30	0	Street
6	POSTBOX	☐	S_POSTBOX	S_POSTBOX	CHAR	10	0	PO Box
7	POSTCODE	☐	POSTCODE	POSTCODE	CHAR	10	0	Postal Code
8	CITY	☐	CITY	CITY	CHAR	25	0	City
9	COUNTRY	☐	S_COUNTRY	S_COUNTRY	CHAR	3	0	Country code
10	REGION	☐	S_REGION	S_REGION	CHAR	3	0	Region
11	TELEPHONE	☐	S_PHONENO	S_PHONE	CHAR	30	0	Telephone number of flight customer
12	CUSTTYPE	☐	S_CUSTTYPE	S_CUSTTYPE	CHAR	1	0	Customer type
13	DISCOUNT	☐	S_DISCOUNT	S_DISCOUNT	NUMC	3	0	Discount rate
14	LANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
15	EMAIL	☐	S_EMAIL	S_EMAIL	CHAR	40	0	Customer e-mail address
16	WEBUSER	☐	S_WEBNAME	S_WEBNAME	CHAR	25	0	Web user name for customer
17	SETSTATE	☐	S_SET	S_SET	CHAR	10	0	Status of Table Entry

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DEMO_SCUSTOM	ID	SBUSPART	BUSPARTNUM	KEY	1	C
2	DEMO_SCUSTOM	LANGU	T002	SPRAS
3	DEMO_SCUSTOM	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in	630