SAP ABAP Table TRQV_LOT_ATTR (Generated Table for View TRQV_LOT_ATTR)
Basic Data
Table Category | VIEW | General view structure |
General view structure | TRQV_LOT_ATTR | Table Relationship Diagram |
Short Description | Generated Table for View TRQV_LOT_ATTR |
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 | ||
2 | OS_GUID | TPM_POSITION_LOT | TPM_DB_OS_GUID | CHAR | 32 | 0 | Lot | ||
3 | POSITION_DATE | TPM_POSITION_DATE | TPM_POSITION_DATE | DATS | 8 | 0 | Position Value Date | ||
4 | ORIGIN_DATE | TPM_ORIGIN_DATE | TPM_ORIGIN_DATE | DATS | 8 | 0 | Original Position Acquisition Date | ||
5 | BUSTRANSID | TPM_BUSTRANSID | SYSUUID | RAW | 16 | 0 | Identifier of the Distributor Business Transaction | ||
6 | LOT_ID | TPM_LOT_ID | SYSUUID | RAW | 16 | 0 | Identifier of the Lot | ||
7 | COMPANY_CODE | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
8 | VALUATION_AREA | TPM_VAL_AREA | TPM_VAL_AREA | CHAR | 3 | 0 | Valuation Area | TRGC_VAL_AREA | |
9 | DEAL_NUMBER | TB_RFHA | T_RFHA | CHAR | 13 | 0 | Financial Transaction | ||
10 | BUSTRANSCAT | TPM_BUSTRANSCAT | TPM_BUSTRANSCAT | NUMC | 4 | 0 | Business Transaction Category | TRDTS_BT_CAT | |
11 | PRODUCT_GROUP | TPM_PRODUCT_GROUP | TPM_PRODUCT_GROUP | NUMC | 3 | 0 | Product Group | ||
12 | PRODUCT_CATEGORY | SANLF | VVSANLF | NUMC | 3 | 0 | Product Category | TZAF | |
13 | BUSTRANS_STATE | TPM_BUSTRANS_STATE | TPM_BUSTRANS_STATE | CHAR | 1 | 0 | Status of Distributor Business Transaction | ||
14 | CREATE_DATE | TPM_BT_CREATE_DATE | DATUM | DATS | 8 | 0 | Creation Date of the Operative Business Transaction | ||
15 | CREATE_TIME | TPM_BT_CREATE_TIME | UZEIT | TIMS | 6 | 0 | Creation Time of the Operative Business Transaction |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | TRQV_LOT_ATTR | BUSTRANSCAT | TRDTS_BT_CAT | BUSTRANSCAT | KEY | 1 | CN |
2 | TRQV_LOT_ATTR | COMPANY_CODE | T001 | BUKRS | KEY | 1 | CN |
3 | TRQV_LOT_ATTR | PRODUCT_CATEGORY | TZAF | SANLF | KEY | 1 | CN |
4 | TRQV_LOT_ATTR | VALUATION_AREA | TRGC_VAL_AREA | VALUATION_AREA | KEY | 1 | CN |
History
Last changed by/on | SAP | 20070913 |
SAP Release Created in |