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
⤷ 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
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 |