SAP ABAP Table CRMT_PRP_ORG_H_WRK (PPR Organisational Data: Working Structure)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-MD-PPR (Application Component) Partner/Product Range
⤷ CRM_PRP_ORG_H (Package) Organisational Data for Partner/Product Ranges (PPRs)
⤷ CRM-MD-PPR (Application Component) Partner/Product Range
⤷ CRM_PRP_ORG_H (Package) Organisational Data for Partner/Product Ranges (PPRs)
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_PRP_ORG_H_WRK | Table Relationship Diagram |
Short Description | PPR Organisational Data: Working Structure |
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 | PPR organisational data (flat): working structure | |||||
2 | .INCLUDE | 0 | 0 | PRP Organisational Data | |||||
3 | .INCLUDE | 0 | 0 | PPR organisational data: primary key fields | |||||
4 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
5 | GUID | CRMT_PRP_GUID | SYSUUID | RAW | 16 | 0 | Internal, Unique Identifier for PPR Objects | ||
6 | .INCLUDE | 0 | 0 | PPR Organisational Data: Fields manipulated externally | |||||
7 | TYPE | CRMT_PRP_REFERENCE_TYPE | CRM_PRP_REFERENCE_TYPE | CHAR | 2 | 0 | Reference Type of the PPR | CRMC_PRP_REFTYP | |
8 | SALES_ORG | CRMT_SALES_ORG | HROBJEC_14 | CHAR | 14 | 0 | Sales Organization ID | ||
9 | SALES_OFFICE | CRMT_SALES_OFFICE | HROBJEC_14 | CHAR | 14 | 0 | Sales Office | ||
10 | SALES_GROUP | CRMT_SALES_GROUP | HROBJEC_14 | CHAR | 14 | 0 | Sales Group | ||
11 | SALES_ORG_RESP | CRMT_SALES_ORG_RESP | HROBJEC_14 | CHAR | 14 | 0 | Organizational Unit (Sales) | ||
12 | DIS_CHANNEL | CRMT_DISTRIBUTION_CHANNEL | CRM_DISTRIBUTION_CHANNEL | CHAR | 2 | 0 | Distribution Channel | CRMC_DISTCHAN | |
13 | DIVISION | CRMT_DIVISION | CRM_DIVISION | CHAR | 2 | 0 | Division | CRMC_DIVISION | |
14 | SERVICE_ORG | CRMT_SERVICE_ORG | HROBJEC_14 | CHAR | 14 | 0 | Service Organization | ||
15 | PROCESS_TYPE | CRMT_PROCESS_TYPE | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | CRMC_PROC_TYPE | |
16 | PARTNER_FUNCTION | COMT_PARTNER_FCT | COM_PARTNER_FCT | CHAR | 8 | 0 | Partner Function | CRMC_PARTNER_FCT | |
17 | .INCLUDE | 0 | 0 | PPR organisational data: fields manipulated internally | |||||
18 | PARENT_GUID | CRMT_PRP_GUID | SYSUUID | RAW | 16 | 0 | Internal, Unique Identifier for PPR Objects | ||
19 | .INCLUDE | 0 | 0 | Partner/Product Ranges (PPRs): Administrative Data | |||||
20 | VALID_FROM | COMT_VALID_FROM | BCOS_TSTMP | DEC | 15 | 0 | Valid From (Time Stamp) | ||
21 | VALID_TO | COMT_VALID_TO | BCOS_TSTMP | DEC | 15 | 0 | Valid To (Time Stamp) | ||
22 | UPNAME | COMT_UPNAME | UNAME | CHAR | 12 | 0 | Name of the User Who Last Changed the Set | ||
23 | HISTEX | COMT_HISTEX | COM_BOOLEAN | CHAR | 1 | 0 | History Exists | ||
24 | EXT_AVAILABLE | CRMT_PRP_EXT_AVAILABLE | CRM_BOOLEAN | CHAR | 1 | 0 | Flag to label, if a PPR Obj. Ext. (EXT_H,EXT_I) is available | ||
25 | .INCLUDE | 0 | 0 | PRP organisational data: structure of dynamic fields | |||||
26 | PROCESSING_MODE | CRMT_MODE | CRM_MODE | CHAR | 1 | 0 | Processing Mode of Transaction | ||
27 | DELETED_FLAG | CRMT_DELETED_FLAG | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator whether the object is marked for deletion | ||
28 | SALES_ORG_SHORT | CRMT_SALES_ORG_SHORT | TEXT12 | CHAR | 12 | 0 | Sales Organization: Description of Department | ||
29 | SALES_ORG_DSCR | CRMT_DESCRIPTION_40 | TEXT40 | CHAR | 40 | 0 | Description (40 Characters) | ||
30 | SALES_OFFICE_DSCR | CRMT_DESCRIPTION_40 | TEXT40 | CHAR | 40 | 0 | Description (40 Characters) | ||
31 | SALES_GROUP_DSCR | CRMT_DESCRIPTION_40 | TEXT40 | CHAR | 40 | 0 | Description (40 Characters) | ||
32 | SALES_ORG_RESP_DSCR | CRMT_DESCRIPTION_40 | TEXT40 | CHAR | 40 | 0 | Description (40 Characters) | ||
33 | DIS_CHANNEL_DSCR | CRMT_DESCRIPTION_40 | TEXT40 | CHAR | 40 | 0 | Description (40 Characters) | ||
34 | DIVISION_DSCR | CRMT_DESCRIPTION_40 | TEXT40 | CHAR | 40 | 0 | Description (40 Characters) | ||
35 | SERVICE_ORG_DSCR | CRMT_PRP_SERVICE_ORG_DESCR | TEXT40 | CHAR | 40 | 0 | Identifier: Service Organization | ||
36 | PARTNER_FCT_TEXT | TEXT30 | TEXT30 | CHAR | 30 | 0 | Text (30 Characters) | ||
37 | PROCESS_TEXT | CRMT_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Description | ||
38 | ERRONEOUS_FLAG | CRMT_BOOLEAN | CRM_BOOLEAN | CHAR | 1 | 0 | Logical Variable | ||
39 | NUMBER_INT | CRMT_PRP_ORG_H_NO | NUMC10 | NUMC | 10 | 0 | Number for arranging PPR Organisational Data Entries | ||
40 | PRP_RANK | CRMT_PRP_RANK | CRM_PRP_RANK | NUMC | 10 | 0 | Rank Indicator of a PPR | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_PRP_ORG_H_WRK | DIS_CHANNEL | CRMC_DISTCHAN | DISTCHAN | KEY | C | CN |
2 | CRMT_PRP_ORG_H_WRK | DIVISION | CRMC_DIVISION | DIVISION | KEY | C | CN |
3 | CRMT_PRP_ORG_H_WRK | PARTNER_FUNCTION | CRMC_PARTNER_FCT | PARTNER_FCT | KEY | C | CN |
4 | CRMT_PRP_ORG_H_WRK | PROCESS_TYPE | CRMC_PROC_TYPE | PROCESS_TYPE | KEY | C | CN |
5 | CRMT_PRP_ORG_H_WRK | TYPE | CRMC_PRP_REFTYP | REFERENCE_TYPE | KEY | C | CN |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 20C |