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