SAP ABAP View BBPV_LA_CLTAUC (View of client status and client auction tables)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_LA (Package) SRM Live Auction

Basic Data

View Type	D	Database View
Database View	BBPV_LA_CLTAUC
Short Description	View of client status and client auction tables
Root table	BBPD_LA_CLTSTAT	Client status

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BBPD_LA_CLTSTAT	BBPD_LA_CLTSTAT
2	BBPD_LA_CLTOBJ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	BBPD_LA_CLTSTAT	CLIENT	JL	EQ				0	0
2	BBPD_LA_CLTOBJ	CLIENT	JR	EQ			AND	0	0
3	BBPD_LA_CLTSTAT	GUID	JL	EQ				0	0
4	BBPD_LA_CLTOBJ	CLIENT_GUID	JR	EQ			AND	0	0
5	BBPD_LA_CLTSTAT	CONNCT_STATUS		EQ	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	BBPD_LA_CLTOBJ	CLIENT		☐	EC_CLIENT	☐	Client
2	GUID	BBPD_LA_CLTOBJ	GUID		☐	BBP_GUID	☐	Globally Unique identifier
3	CLIENT_GUID	BBPD_LA_CLTSTAT	GUID		☐	BBP_GUID	☐	Globally Unique identifier
4	AUC_GUID	BBPD_LA_CLTOBJ	AUC_GUID		☐	BBP_GUID	☐	Globally Unique identifier
5	LANGUAGE	BBPD_LA_CLTSTAT	LANGUAGE		☐	SPRAS	☐	Language Key
6	PARTNER_GUID	BBPD_LA_CLTSTAT	PARTNER_GUID		☐	BBP_GUID	☐	Globally Unique identifier
7	CONNCT_STATUS	BBPD_LA_CLTSTAT	CONNCT_STATUS		☐	BBP_LA_CONNECTION	☐	Connection status
8	CLIENT_TYPE	BBPD_LA_CLTSTAT	CLIENT_TYPE		☐	BBP_LA_CLIENT_TYPE	☐	Client type
9	SEQ_NO	BBPD_LA_CLTSTAT	SEQ_NO		☐	BBP_LA_SEQ_NO	☐	Message sequence number
10	CHANGED_AT	BBPD_LA_CLTSTAT	CHANGED_AT		☐	BBPTIMEST	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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