SAP ABAP View CC_DB_VIEW (Selection for CC)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR-OA (Application Component) Vendor Outline Agreements
     ⤷ MM_P2P_BSI_CC (Package) Central Contract Management

Basic Data

View Type	D	Database View
Database View	CC_DB_VIEW
Short Description	Selection for CC
Root table	BBP_CTR_ITEM_MAP	Mapping of EBP Items to ERP Items

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	BBP_CTR_ITEM_MAP	BBP_CTR_ITEM_MAP
2	EKPO
3	EKKO
4	LFA1

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EKPO	MANDT	JL	EQ				0	0
2	BBP_CTR_ITEM_MAP	MANDT	JR	EQ			AND	0	0
3	EKKO	MANDT	JL	EQ				0	0
4	EKPO	MANDT	JR	EQ			AND	0	0
5	LFA1	MANDT	JL	EQ				0	0
6	EKKO	MANDT	JR	EQ			AND	0	0
7	EKPO	SRM_CONTRACT_ID	JL	EQ				0	0
8	BBP_CTR_ITEM_MAP	OBJECT_ID	JR	EQ			AND	0	0
9	EKPO	SRM_CONTRACT_ITM	JL	EQ				0	0
10	BBP_CTR_ITEM_MAP	NUMBER_INT	JR	EQ			AND	0	0
11	EKPO	EBELN	JL	EQ				0	0
12	BBP_CTR_ITEM_MAP	BE_OBJECT_ID	JR	EQ			AND	0	0
13	EKPO	EBELP	JL	EQ				0	0
14	BBP_CTR_ITEM_MAP	BE_NUMBER_INT	JR	EQ			AND	0	0
15	EKKO	MANDT	JL	EQ				0	0
16	BBP_CTR_ITEM_MAP	MANDT	JR	EQ			AND	0	0
17	EKKO	EBELN	JL	EQ				0	0
18	EKPO	EBELN	JR	EQ			AND	0	0
19	LFA1	LIFNR	JL	EQ				0	0
20	EKKO	LIFNR	JR	EQ			AND	0	0
21	EKKO	STATU		EQ	'K'		AND	0	0
22	EKKO	BSTYP		EQ	'K'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	BBP_CTR_ITEM_MAP	MANDT		☐	MANDT	☐	Client
2	EBELN	EKPO	EBELN		☐	EBELN	☐	Purchasing Document Number
3	EBELP	EKPO	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
4	TXZ01	EKPO	TXZ01		☐	TXZ01	☐	Short Text
5	MATNR	EKPO	MATNR		☐	MATNR	☐	Material Number
6	KTMNG	EKPO	KTMNG		☐	KTMNG	☐	Target Quantity
7	KTWRT	EKKO	KTWRT		☐	KTWRT	☐	Target Value for Header Area per Distribution
8	MENGE	EKPO	MENGE		☐	BSTMG	☐	Purchase Order Quantity
9	MEINS	EKPO	MEINS		☐	BSTME	☐	Order unit
10	NETPR	EKPO	NETPR		☐	BPREI	☐	Net Price in Purchasing Document (in Document Currency)
11	PEINH	EKPO	PEINH		☐	EPEIN	☐	Price unit
12	SRM_CONTRACT_ID	EKPO	SRM_CONTRACT_ID		☐	SRM_CONTRACT_ID	☐	Central Contract
13	SRM_CONTRACT_ITM	EKPO	SRM_CONTRACT_ITM		☐	SRM_CONTRACT_ITEM	☐	Central Contract Item Number
14	BUKRS	EKKO	BUKRS		☐	BUKRS	☐	Company Code
15	BSTYP	EKKO	BSTYP		☐	EBSTYP	☐	Purchasing Document Category
16	STATU	EKKO	STATU		☐	ESTAK	☐	Status of Purchasing Document
17	LIFNR	EKKO	LIFNR		☐	ELIFN	☐	Vendor's account number
18	NAME1	LFA1	NAME1		☐	NAME1_GP	☐	Name 1
19	ZTERM	EKKO	ZTERM		☐	DZTERM	☐	Terms of payment key
20	EKORG	EKKO	EKORG		☐	EKORG	☐	Purchasing organization
21	EKGRP	EKKO	EKGRP		☐	BKGRP	☐	Purchasing Group
22	WAERS	EKKO	WAERS		☐	WAERS	☐	Currency Key
23	WKURS	EKKO	WKURS		☐	WKURS	☐	Exchange Rate
24	KDATB	EKKO	KDATB		☐	KDATB	☐	Start of Validity Period
25	KDATE	EKKO	KDATE		☐	KDATE	☐	End of Validity Period
26	HIERARCHY_EXISTS	EKKO	HIERARCHY_EXISTS		☐	HIERARCHY_EXISTS	☐	Part of a Contract Hierarchy
27	THRESHOLD_EXISTS	EKKO	THRESHOLD_EXISTS		☐	EX_RATE_THRESHOLD	☐	Threshold Value for Exchange Rates Exists
28	LEGAL_CONTRACT	EKKO	LEGAL_CONTRACT		☐	LEGAL_CONTRACT_ID	☐	Legal Contract Number
29	DESCRIPTION	EKKO	DESCRIPTION		☐	CONTRACT_DESCRIPTION	☐	Contract Name
30	AEDAT	EKKO	AEDAT		☐	ERDAT	☐	Date on which the record was created
31	RELEASE_DATE	EKKO	RELEASE_DATE		☐	RELEASE_DATE	☐	Release Date of Contract
32	WERKS	EKPO	WERKS		☐	EWERK	☐	Plant
33	LOEKZ	EKPO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
34	PSTYP	EKPO	PSTYP		☐	PSTYP	☐	Item category in purchasing document

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	20140121
SAP Release Created in	604