SAP ABAP Table CAPP_REL (Relationships)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ CA (Application Component) Cross-Application Components
⤷ CAPP (Package) Master Data Selection: BOM/Work Plan/Recipe
⤷ CA (Application Component) Cross-Application Components
⤷ CAPP (Package) Master Data Selection: BOM/Work Plan/Recipe
Basic Data
Table Category | INTTAB | Structure |
Structure | CAPP_REL | Table Relationship Diagram |
Short Description | Relationships |
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 | .INCLUDE | 0 | 0 | Relationships | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PLNTY | PLNTY | PLNTY | CHAR | 1 | 0 | Task List Type | * | |
4 | PLNNR | AOB_PLNNR | PLNNR | CHAR | 8 | 0 | Number of the Standard Network | ||
5 | PLNAL | PLNAL | ALTNR | CHAR | 2 | 0 | Group Counter | ||
6 | PLNKN | PLNKN | KNTNR | NUMC | 8 | 0 | Number of the task list node | ||
7 | PLNRN | AOB_PLNNR | PLNNR | CHAR | 8 | 0 | Number of the Standard Network | ||
8 | ALNRN | PLNAL | ALTNR | CHAR | 2 | 0 | Group Counter | ||
9 | KNNRN | PLNKN | KNTNR | NUMC | 8 | 0 | Number of the task list node | ||
10 | AOBAR | AOBAR | AOBAR | CHAR | 2 | 0 | Type of relationship | ||
11 | MIMAX | DAUMIMAX | XFELD | CHAR | 1 | 0 | Indicates whether maximum time interval will be considered | ||
12 | ZAEHL | CIM_COUNT | CIM_COUNT | NUMC | 8 | 0 | Internal counter | ||
13 | DATUV | CIM_DATE | DATUM | DATS | 8 | 0 | Valid-from date | ||
14 | TECHV | TECHV | TECHS | CHAR | 12 | 0 | Technical status from | ||
15 | AENNR | AENNR | AENNR | CHAR | 12 | 0 | Change Number | AENR | |
16 | ZEINH | AOBDAUEH | MEINS | UNIT | 3 | 0 | Unit for the time interval between relationships | T006 | |
17 | DAUER | AOBDAUER | AOBDAUER | QUAN | 5 | 1 | Time interval between relationships | ||
18 | DAUKZ | AOBDAUKZ | AOBDAUKZ | CHAR | 1 | 0 | Indicator for the duration of the relationship | ||
19 | VORNC | VORG_NACH | XFELD | CHAR | 1 | 0 | Indicator: maintained after successor | ||
20 | NCVOR | NACH_VORG | XFELD | CHAR | 1 | 0 | Indicates whether data after predecessor is maintained | ||
21 | LOEKZ | LOEKZ | XFELD | CHAR | 1 | 0 | Asset class marked for deletion | ||
22 | KALID | WFCID | WFCID | CHAR | 2 | 0 | Factory Calendar | TFACD | |
23 | PRZNT | AOB_PRZNT | AOB_PRZNT | NUMC | 3 | 0 | % used to calc. time interval between predecessor/successor | ||
24 | PROVG | AOB_PROVG | AOB_PROVG | CHAR | 1 | 0 | Key for defining time intervals in a relationship | ||
25 | ARBID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
26 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
27 | ANDAT | ANDAT | DATUM | DATS | 8 | 0 | Date Record Created on | ||
28 | ANNAM | ANNAM | USNAM | CHAR | 12 | 0 | User Who Created Record | ||
29 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
30 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
31 | DAUERMAX | AOBDAUERM | AOBDAUER | QUAN | 5 | 1 | Maximum time interval for relationship | ||
32 | DATUB | DATUB | DATUM | DATS | 8 | 0 | Valid-to date | ||
33 | AENNR_AUS | AENNR | AENNR | CHAR | 12 | 0 | Change Number | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CAPP_REL | AENNR | AENR | AENNR | REF | C | C |
2 | CAPP_REL | KALID | TFACD | IDENT | REF | C | CN |
3 | CAPP_REL | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | CAPP_REL | WERKS | T001W | WERKS | REF | 1 | CN |
5 | CAPP_REL | ZEINH | T006 | MSEHI | REF | C | CN |
History
Last changed by/on | SAP | 20031111 |
SAP Release Created in |