SAP ABAP Table /SAPCEM/V_BD (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | /SAPCEM/V_BD |
Table Relationship Diagram 
|
| Short Description | Generated Table for View |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  MANDT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | /SAPCEM/BDNUM |
/SAPCEM/BDNUM | /SAPCEM/BDNUM | CHAR | 10 | 0 | Number of Requisition Note | /SAPCEM/BDKO | |
| 3 | /SAPCEM/BDPOS |
/SAPCEM/BDPOS | /SAPCEM/BDPOS | NUMC | 5 | 0 | Requisition Note Item | ||
| 4 | /SAPCEM/UEPOS |
/SAPCEM/UEPOS | /SAPCEM/BDPOS | NUMC | 5 | 0 | Higher-Level Item | ||
| 5 | /SAPCEM/KLART |
KLASSENART | KLASSENART | CHAR | 3 | 0 | Class Type | TCLA | |
| 6 | /SAPCEM/KLASS |
KLASSE_D | KLASSE | CHAR | 18 | 0 | Class number | ||
| 7 | /SAPCEM/EQUNR |
EQUNR | EQUNR | CHAR | 18 | 0 | Equipment Number | EQUI | |
| 8 | /SAPCEM/MENGE |
/SAPCEM/MENGE | MENG13 | QUAN | 13 | 3 | Requirements Quantity | ||
| 9 | /SAPCEM/MEINS |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
| 10 | /SAPCEM/BDBEG |
/SAPCEM/BDBEG | DATUM | DATS | 8 | 0 | Requirement Start: Date | ||
| 11 | /SAPCEM/BDBEGU |
/SAPCEM/BDBEGU | T | TIMS | 6 | 0 | Req. Start: Time | ||
| 12 | /SAPCEM/BDEND |
/SAPCEM/BDEND | DATUM | DATS | 8 | 0 | Requirement End | ||
| 13 | /SAPCEM/BDENDU |
/SAPCEM/BDENDU | T | TIMS | 6 | 0 | Requirement End: Time | ||
| 14 | /SAPCEM/STATU |
/SAPCEM/STATUS | /SAPCEM/STATUS | CHAR | 1 | 0 | Requirement Status | ||
| 15 | /SAPCEM/BEDID |
BEDID | BEDID | NUMC | 12 | 0 | ID of the capacity requirements record | KBKO | |
| 16 | /SAPCEM/BEDZL |
CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
| 17 | /SAPCEM/KTEXT |
/SAPCEM/KTEXT_BEDARFSPOSITION | TEXT40 | CHAR | 40 | 0 | Short Text for Requirements Item | ||
| 18 | /SAPCEM/BDZUO |
/SAPCEM/BEDARFSZUORDNUNG | /SAPCEM/BEDARFSZUORDNUNG | CHAR | 1 | 0 | Requirements Assignment | ||
| 19 | PERNR |
J_3GPERNR | J_3GPERNR | NUMC | 8 | 0 | Personal Number | ||
| 20 | ERNAM |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 21 | ERZET |
ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
| 22 | ERDAT |
ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
| 23 | UNAME |
AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
| 24 | AEZET |
AEZET | UZEIT | TIMS | 6 | 0 | Time last change was made | ||
| 25 | AEDTM |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 26 | J_3GBELNRI |
J_3GBELNRI | J_3GBELNR | CHAR | 10 | 0 | Document Number | J_3GBELK | |
| 27 | J_3GPOSNRI |
J_3GBELPOS | J_3GPOSNR | NUMC | 5 | 0 | Document Item | J_3GBELP | |
| 28 | J_3GUPOSNR |
J_3GUPOSNR | NUMC2 | NUMC | 2 | 0 | Sub-Item Number | ||
| 29 | /SAPCEM/SPLITPOS |
/SAPCEM/SPLIT | /SAPCEM/BDPOS | NUMC | 5 | 0 | Superior Item of Split | ||
| 30 | /SAPCEM/VKORG |
/SAPCEM/VKORG | VKORG | CHAR | 4 | 0 | Sales Organization, but Obsolete | TVTA | |
| 31 | /SAPCEM/VTWEG |
/SAPCEM/VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel, but Obsolete | TVTA | |
| 32 | /SAPCEM/SPART |
/SAPCEM/SPART | SPART | CHAR | 2 | 0 | Division, but Obsolete | TVTA | |
| 33 | /SAPCEM/EMPFAE |
J_3GEMPFAE | KUNNR | CHAR | 10 | 0 | Recipient | KNA1 | |
| 34 | /SAPCEM/AGEXT |
J_3GEMPDEB | KUNNR | CHAR | 10 | 0 | Debtor of Recipient | KNA1 | |
| 35 | /SAPCEM/WEEXT |
J_3GEMPEXT | KUNNR | CHAR | 10 | 0 | External Ship-To Party - Recipient | KNA1 | |
| 36 | /SAPCEM/EXNUM |
/SAPCEM/EXNUM | /SAPCEM/EXNUM | CHAR | 10 | 0 | External Number of Requisition Note | ||
| 37 | /SAPCEM/PARNR |
PARNR | PARNR | NUMC | 10 | 0 | Number of contact person | ||
| 38 | PSPNR |
PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | PRPS | |
| 39 | ERNAM_K |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 40 | ERZET_K |
ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
| 41 | ERDAT_K |
ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
| 42 | UNAME_K |
AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
| 43 | AEZET_K |
AEZET | UZEIT | TIMS | 6 | 0 | Time last change was made | ||
| 44 | AEDTM_K |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
| 45 | /SAPCEM/BDBEG_K |
/SAPCEM/BDBEG | DATUM | DATS | 8 | 0 | Requirement Start: Date | ||
| 46 | /SAPCEM/BDEND_K |
/SAPCEM/BDEND | DATUM | DATS | 8 | 0 | Requirement End | ||
| 47 | /SAPCEM/BEDID_K |
BEDID | BEDID | NUMC | 12 | 0 | ID of the capacity requirements record | KBKO | |
| 48 | /SAPCEM/KTEXT_K |
/SAPCEM/KTEXT_BEDARFSKOPF | TEXT40 | CHAR | 40 | 0 | Short text for Requirements Header |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /SAPCEM/V_BD | /SAPCEM/AGEXT |  KNA1 |
KUNNR |
|||
| 2 | /SAPCEM/V_BD | /SAPCEM/BDNUM | /SAPCEM/BDKO |
/SAPCEM/BDNUM |
1 | CN | |
| 3 | /SAPCEM/V_BD | /SAPCEM/BEDID | KBKO |
BEDID |
|||
| 4 | /SAPCEM/V_BD | /SAPCEM/BEDID_K | KBKO |
BEDID |
|||
| 5 | /SAPCEM/V_BD | /SAPCEM/EMPFAE | KNA1 |
KUNNR |
|||
| 6 | /SAPCEM/V_BD | /SAPCEM/EQUNR | EQUI |
EQUNR |
|||
| 7 | /SAPCEM/V_BD | /SAPCEM/KLART | TCLA |
KLART |
|||
| 8 | /SAPCEM/V_BD | /SAPCEM/MEINS | T006 |
MSEHI |
|||
| 9 | /SAPCEM/V_BD | /SAPCEM/SPART | TVTA |
SPART |
|||
| 10 | /SAPCEM/V_BD | /SAPCEM/VKORG | TVTA |
VKORG |
|||
| 11 | /SAPCEM/V_BD | /SAPCEM/VTWEG | TVTA |
VTWEG |
|||
| 12 | /SAPCEM/V_BD | /SAPCEM/WEEXT | KNA1 |
KUNNR |
|||
| 13 | /SAPCEM/V_BD | J_3GBELNRI | J_3GBELK |
J_3GBELNRI |
KEY | ||
| 14 | /SAPCEM/V_BD | J_3GPOSNRI | J_3GBELP |
J_3GPOSNRI |
|||
| 15 | /SAPCEM/V_BD | MANDT | T000 |
MANDT |
|||
| 16 | /SAPCEM/V_BD | PSPNR | PRPS |
PSPNR |
History
| Last changed by/on | SAP | 20131127 |
| SAP Release Created in |
