SAP ABAP View /SAPCEM/V_BD (Requisition Note Item (Database View for Selection))
Hierarchy
☛
ECC-DIMP (Software Component) DIMP
⤷
IS-EC-CEM (Application Component) Construction Equipment Management
⤷
/SAPCEM/DISPO (Package) CEM Planning
ECC-DIMP (Software Component) DIMP⤷
IS-EC-CEM (Application Component) Construction Equipment Management⤷
/SAPCEM/DISPO (Package) CEM Planning
Basic Data
| View Type | D | Database View |
| Database View | /SAPCEM/V_BD | |
| Short Description | Requisition Note Item (Database View for Selection) | |
| Root table | /SAPCEM/BDKO | Header Data for Requisition Note |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | /SAPCEM/BDKO |
/SAPCEM/BDKO | ||
| 2 | /SAPCEM/BDPO |
|||
| 3 | KNA1 |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | /SAPCEM/BDKO |
MANDT | JL | EQ | 0 | 0 | ||||
| 2 | /SAPCEM/BDPO |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 3 | /SAPCEM/BDKO |
/SAPCEM/BDNUM | JL | EQ | 0 | 0 | ||||
| 4 | /SAPCEM/BDPO |
/SAPCEM/BDNUM | JR | EQ | AND | 0 | 0 | |||
| 5 | KNA1 |
MANDT | JL | EQ | 0 | 0 | ||||
| 6 | /SAPCEM/BDKO |
MANDT | JR | EQ | AND | 0 | 0 | |||
| 7 | KNA1 |
KUNNR | JL | EQ | 0 | 0 | ||||
| 8 | /SAPCEM/BDKO |
/SAPCEM/EMPFAE | JR | EQ | 0 | 0 | ||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 |  * |
/SAPCEM/BDPO |
* | |||||
| 2 | MANDT |
/SAPCEM/BDPO |
MANDT | MANDT | Client | |||
| 3 | /SAPCEM/BDNUM |
/SAPCEM/BDPO |
/SAPCEM/BDNUM | /SAPCEM/BDNUM | Number of Requisition Note | |||
| 4 | /SAPCEM/BDPOS |
/SAPCEM/BDPO |
/SAPCEM/BDPOS | /SAPCEM/BDPOS | Requisition Note Item | |||
| 5 | /SAPCEM/UEPOS |
/SAPCEM/BDPO |
/SAPCEM/UEPOS | /SAPCEM/UEPOS | Higher-Level Item | |||
| 6 | /SAPCEM/KLART |
/SAPCEM/BDPO |
/SAPCEM/KLART | KLASSENART | Class Type | |||
| 7 | /SAPCEM/KLASS |
/SAPCEM/BDPO |
/SAPCEM/KLASS | KLASSE_D | Class number | |||
| 8 | /SAPCEM/EQUNR |
/SAPCEM/BDPO |
/SAPCEM/EQUNR | EQUNR | Equipment Number | |||
| 9 | /SAPCEM/MENGE |
/SAPCEM/BDPO |
/SAPCEM/MENGE | /SAPCEM/MENGE | Requirements Quantity | |||
| 10 | /SAPCEM/MEINS |
/SAPCEM/BDPO |
/SAPCEM/MEINS | MEINS | Base Unit of Measure | |||
| 11 | /SAPCEM/BDBEG |
/SAPCEM/BDPO |
/SAPCEM/BDBEG | /SAPCEM/BDBEG | Requirement Start: Date | |||
| 12 | /SAPCEM/BDBEGU |
/SAPCEM/BDPO |
/SAPCEM/BDBEGU | /SAPCEM/BDBEGU | Req. Start: Time | |||
| 13 | /SAPCEM/BDEND |
/SAPCEM/BDPO |
/SAPCEM/BDEND | /SAPCEM/BDEND | Requirement End | |||
| 14 | /SAPCEM/BDENDU |
/SAPCEM/BDPO |
/SAPCEM/BDENDU | /SAPCEM/BDENDU | Requirement End: Time | |||
| 15 | /SAPCEM/STATU |
/SAPCEM/BDPO |
/SAPCEM/STATU | /SAPCEM/STATUS | Requirement Status | |||
| 16 | /SAPCEM/BEDID |
/SAPCEM/BDPO |
/SAPCEM/BEDID | BEDID | ID of the capacity requirements record | |||
| 17 | /SAPCEM/BEDZL |
/SAPCEM/BDPO |
/SAPCEM/BEDZL | CIM_COUNT | Internal counter | |||
| 18 | /SAPCEM/KTEXT |
/SAPCEM/BDPO |
/SAPCEM/KTEXT | /SAPCEM/KTEXT_BEDARFSPOSITION | Short Text for Requirements Item | |||
| 19 | /SAPCEM/BDZUO |
/SAPCEM/BDPO |
/SAPCEM/BDZUO | /SAPCEM/BEDARFSZUORDNUNG | Requirements Assignment | |||
| 20 | PERNR |
/SAPCEM/BDPO |
PERNR | J_3GPERNR | Personal Number | |||
| 21 | ERNAM |
/SAPCEM/BDPO |
ERNAM | ERNAM | Name of Person who Created the Object | |||
| 22 | ERZET |
/SAPCEM/BDPO |
ERZET | ERZET | Entry time | |||
| 23 | ERDAT |
/SAPCEM/BDPO |
ERDAT | ERDAT | Date on which the record was created | |||
| 24 | UNAME |
/SAPCEM/BDPO |
UNAME | AENAM | Name of Person Who Changed Object | |||
| 25 | AEZET |
/SAPCEM/BDPO |
AEZET | AEZET | Time last change was made | |||
| 26 | AEDTM |
/SAPCEM/BDPO |
AEDTM | AEDAT | Last Changed On | |||
| 27 | J_3GBELNRI |
/SAPCEM/BDPO |
J_3GBELNRI | J_3GBELNRI | Document Number | |||
| 28 | J_3GPOSNRI |
/SAPCEM/BDPO |
J_3GPOSNRI | J_3GBELPOS | Document Item | |||
| 29 | J_3GUPOSNR |
/SAPCEM/BDPO |
J_3GUPOSNR | J_3GUPOSNR | Sub-Item Number | |||
| 30 | /SAPCEM/SPLITPOS |
/SAPCEM/BDPO |
/SAPCEM/SPLITPOS | /SAPCEM/SPLIT | Superior Item of Split | |||
| 31 | * |
/SAPCEM/BDKO |
* | |||||
| 32 | - |
/SAPCEM/BDKO |
MANDT | MANDT | Client | |||
| 33 | - |
/SAPCEM/BDKO |
/SAPCEM/BDNUM | /SAPCEM/BDNUM | Number of Requisition Note | |||
| 34 | /SAPCEM/VKORG |
/SAPCEM/BDKO |
/SAPCEM/VKORG | /SAPCEM/VKORG | Sales Organization, but Obsolete | |||
| 35 | /SAPCEM/VTWEG |
/SAPCEM/BDKO |
/SAPCEM/VTWEG | /SAPCEM/VTWEG | Distribution Channel, but Obsolete | |||
| 36 | /SAPCEM/SPART |
/SAPCEM/BDKO |
/SAPCEM/SPART | /SAPCEM/SPART | Division, but Obsolete | |||
| 37 | /SAPCEM/EMPFAE |
/SAPCEM/BDKO |
/SAPCEM/EMPFAE | J_3GEMPFAE | Recipient | |||
| 38 | /SAPCEM/AGEXT |
/SAPCEM/BDKO |
/SAPCEM/AGEXT | J_3GEMPDEB | Debtor of Recipient | |||
| 39 | /SAPCEM/WEEXT |
/SAPCEM/BDKO |
/SAPCEM/WEEXT | J_3GEMPEXT | External Ship-To Party - Recipient | |||
| 40 | /SAPCEM/EXNUM |
/SAPCEM/BDKO |
/SAPCEM/EXNUM | /SAPCEM/EXNUM | External Number of Requisition Note | |||
| 41 | /SAPCEM/PARNR |
/SAPCEM/BDKO |
/SAPCEM/PARNR | PARNR | Number of contact person | |||
| 42 | PSPNR |
/SAPCEM/BDKO |
PSPNR | PS_POSNR | WBS Element | |||
| 43 | ERNAM_K |
/SAPCEM/BDKO |
ERNAM | ERNAM | Name of Person who Created the Object | |||
| 44 | ERZET_K |
/SAPCEM/BDKO |
ERZET | ERZET | Entry time | |||
| 45 | ERDAT_K |
/SAPCEM/BDKO |
ERDAT | ERDAT | Date on which the record was created | |||
| 46 | UNAME_K |
/SAPCEM/BDKO |
UNAME | AENAM | Name of Person Who Changed Object | |||
| 47 | AEZET_K |
/SAPCEM/BDKO |
AEZET | AEZET | Time last change was made | |||
| 48 | AEDTM_K |
/SAPCEM/BDKO |
AEDTM | AEDAT | Last Changed On | |||
| 49 | /SAPCEM/BDBEG_K |
/SAPCEM/BDKO |
/SAPCEM/BDBEG | /SAPCEM/BDBEG | Requirement Start: Date | |||
| 50 | /SAPCEM/BDEND_K |
/SAPCEM/BDKO |
/SAPCEM/BDEND | /SAPCEM/BDEND | Requirement End | |||
| 51 | /SAPCEM/BEDID_K |
/SAPCEM/BDKO |
/SAPCEM/BEDID | BEDID | ID of the capacity requirements record | |||
| 52 | /SAPCEM/KTEXT_K |
/SAPCEM/BDKO |
/SAPCEM/KTEXT | /SAPCEM/KTEXT_BEDARFSKOPF | Short text for Requirements Header | |||
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 | 20131127 |
| SAP Release Created in |
