SAP ABAP Table JJTPRDH_PRFAG (IS-M/AM Prd.Hier.(S&P): Product/External Agency Assignment)
Hierarchy
☛
IS-M (Software Component) SAP MEDIA
⤷
IS-M (Application Component) SAP Media
⤷
JAS (Package) Application development R/3 Publishing Advertising System***
IS-M (Software Component) SAP MEDIA⤷
IS-M (Application Component) SAP Media⤷
JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | JJTPRDH_PRFAG |
Table Relationship Diagram 
|
| Short Description | IS-M/AM Prd.Hier.(S&P): Product/External Agency Assignment |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| 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 | HERKUNFT |
ISM_PRDH_HERKUNFT | CHAR002 | CHAR | 2 | 0 | IS-M/AM: Origin Key | ||
| 3 | PRODUKT |
ISM_PRDH_PROD | ISM_PRDH_PRODUKT | CHAR | 11 | 0 | IS-M/AM: Product | JJTPRDH_PROD | |
| 4 | GFELD |
ISM_PRDH_GFELD | CHAR002 | CHAR | 2 | 0 | IS-M/AM: Product Hierarchy: Business Area | TJJPRDH_TGFELD | |
| 5 | AGROL |
ISM_PRDH_AGROL | CHAR002 | CHAR | 2 | 0 | IS-M/AM: Product Hierarchy: Agency Role | TJJPRDH_TAGROL | |
| 6 | FAGNR |
ISM_PRDH_FAGNR | ISM_PRDH_FGPAG_NR | CHAR | 11 | 0 | IS-M/AM: Product Hierarchy: External Agency Number | ||
| 7 | DATAB |
BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
| 8 | DATBIS |
ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
| 9 | FAGBEZ |
ISM_PRDH_AG_BEZ | CHAR030 | CHAR | 30 | 0 | IS-M/AM: Product Hierarchy: External Agency Name | ||
| 10 | FAGORT |
ISM_PRDH_AG_ORT | CHAR030 | CHAR | 30 | 0 | IS-M/AM: Product Hierarchy: External Agency: City | ||
| 11 | FAGPLZ |
ISM_PRDH_FGPAG_PLZ | CHAR005 | CHAR | 5 | 0 | IS-M/AM: Product Hierarchy: Agency Postal Code | ||
| 12 | FAGLAND |
ISM_PRDH_FGPAG_LAND | CHAR003 | CHAR | 3 | 0 | IS-M/AM Prd.Hier: External BP / Agency: Country Indicator | ||
| 13 | PRODBEZ |
ISM_PRDH_BEZ_PROD_AG | CHAR030 | CHAR | 30 | 0 | IS-M/AM: Product Description at Agencies | ||
| 14 | STATUS_KZ |
ISM_PRDH_FGPAG_STATUS | ISM_PRDH_FGPAG_STATUS | CHAR | 1 | 0 | IS-M/AM: External BP / Agency: Status |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | JJTPRDH_PRFAG | AGROL |  TJJPRDH_TAGROL |
AGROL |
KEY | 1 | CN |
| 2 | JJTPRDH_PRFAG | GFELD | TJJPRDH_TGFELD |
GFELD |
KEY | 1 | CN |
| 3 | JJTPRDH_PRFAG | MANDT | T000 |
MANDT |
KEY | 1 | CN |
| 4 | JJTPRDH_PRFAG | PRODUKT | JJTPRDH_PROD |
PRODUKT |
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20050224 |
| SAP Release Created in | 471 |
