| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | HERKUNFT | IS-M/AM: Origin Key | nvarchar | 2 | 0 | CHAR | (N' ') | No | | ISM_PRDH_HERKUNFT | Allow NULL? |
| 3 | PRODUKT | IS-M/AM: Product | nvarchar | 11 | 0 | CHAR | (N' ') | No | JJTPRDH_PROD | ISM_PRDH_PROD | Allow NULL? |
| 4 | GFELD | IS-M/AM: Product Hierarchy: Business Area | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJJPRDH_TGFELD | ISM_PRDH_GFELD | Allow NULL? |
| 5 | AGROL | IS-M/AM: Product Hierarchy: Agency Role | nvarchar | 2 | 0 | CHAR | (N' ') | No | TJJPRDH_TAGROL | ISM_PRDH_AGROL | Allow NULL? |
| 6 | FAGNR | IS-M/AM: Product Hierarchy: External Agency Number | nvarchar | 11 | 0 | CHAR | (N' ') | No | | ISM_PRDH_FAGNR | Allow NULL? |
| 7 | DATAB | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEGDA | Allow NULL? |
| 8 | DATBIS | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ENDDA | Allow NULL? |
| 9 | FAGBEZ | IS-M/AM: Product Hierarchy: External Agency Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISM_PRDH_AG_BEZ | Allow NULL? |
| 10 | FAGORT | IS-M/AM: Product Hierarchy: External Agency: City | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISM_PRDH_AG_ORT | Allow NULL? |
| 11 | FAGPLZ | IS-M/AM: Product Hierarchy: Agency Postal Code | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ISM_PRDH_FGPAG_PLZ | Allow NULL? |
| 12 | FAGLAND | IS-M/AM Prd.Hier: External BP / Agency: Country Indicator | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ISM_PRDH_FGPAG_LAND | Allow NULL? |
| 13 | PRODBEZ | IS-M/AM: Product Description at Agencies | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISM_PRDH_BEZ_PROD_AG | Allow NULL? |
| 14 | STATUS_KZ | IS-M/AM: External BP / Agency: Status | char | 1 | 0 | CHAR | (N' ') | Yes | | ISM_PRDH_FGPAG_STATUS | Allow NULL? |