The CRMS4D_PSDP_H table in SAP ERP or S/4HANA stores Social Deduction Plan Header data. There are total 84 fields in CRMS4D_PSDP_H table. The Social Deduction Plan Header table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CRMS4D_PSDP_H table. It is in One Order Persistency Objects for Social Services (CRMS4_PS_1O_PERSISTENCY) ABAP package and is part of the S4CRM: Social Service Plan (CRM-S4-IPS-SSP) module.
SAP CRMS4D_PSDP_H Table Fields
Following is the list of fields that are available in SAP CRMS4D_PSDP_H table. The primary key fields of the table are CLIENT (Client), OBJTYPE_H (Business Trans. Cat.), OBJECT_ID (Transaction ID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| OBJTYPE_H | Business Trans. Cat. | CRMT_SUBOBJECT_CATEGORY_DB | CRMC_SUBOB_CAT | CHAR (10) |
| OBJECT_ID | Transaction ID | CRMT_OBJECT_ID_DB | CHAR (10) | |
| HEADER_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| PROCESS_TYPE | Business Transaction Type | CRMT_PROCESS_TYPE_DB | * | CHAR (4) |
| DESCRIPTION_H | Transaction Description | CRMT_PROCESS_DESCRIPTION | CHAR (40) | |
| DESCR_LANGUAGE | Language Key of Description | CRMT_PROCESS_DESCRIPTION_LANGU | * | LANG (1) |
| TEMPLATE_TYPE | Template Type of CRM Transaction | CRMT_TEMPLATE_TYPE_DB | CHAR (1) | |
| CREATED_AT_H | Created At (Output in User Time Zone) | COMT_CREATED_AT_USR | DEC (15) | |
| CREATED_BY_H | User that Created the Transaction | CRMT_CREATED_BY | CHAR (12) | |
| CHANGED_AT_H | Changed At (Output in User Time Zone) | COMT_CHANGED_AT_USR | DEC (15) | |
| CHANGED_BY_H | Transaction Last Changed By | CRMT_CHANGED_BY | CHAR (12) | |
| HEAD_CHANGED_AT | Time of Last Change to the Transaction | CRMT_CHANGED_AT | DEC (15) | |
| BTX_CLASS | CRM Business Transaction Classification | CRMT_TRANSACTION_CLASSIFICATN | CHAR (1) | |
| AUTH_SCOPE | Authorization Scope | CRM_AUTH_SCOPE | * | NUMC (6) |
| ARCHIVING_FLAG | Indicator Whether the Business Transaction Can Be Archived | CRMT_ARCHIVING_FLAG | CHAR (1) | |
| OBJECT_ID_OK | Indicator That Transaction ID Is Correct | CRMT_OBJECT_ID_OK | CHAR (1) | |
| VERIFY_DATE | Time Period of Last Archiving Attempt | CRMT_VERIFY_DATE | DEC (15) | |
| PRICING_DOCUMENT | Number of the Document Condition | KNUMV | CHAR (10) | |
| PRICING_PROCEDURE | Procedure (Pricing, Output Control, Acct. Det., Costing,…) | KALSM_D | * | CHAR (6) |
| CONTSTART_H | Contract Start Date | CRMS4_PS_CONTSTART | DEC (15) | |
| CONTEND_H | Contract End Date | CRMS4_PS_CONTEND | DEC (15) | |
| APPROVEDATE_H | Approval Date | CRMS4_PS_APPROVEDATE | DEC (15) | |
| DECISION_H | Decision Date | CRMS4_PS_DECISIONDATE | DEC (15) | |
| BUSINESS_PROCESS | Business Transaction | J_VORGANG | * | CHAR (4) |
| CHNG_PROCESS | Change Process | CRMT_LEAS_CHNG | * | CHAR (4) |
| CHNG_PROCESS_SUB | Change of Lease: Sub-Change Process | CRMT_LEAS_CHNG_SUB1 | * | CHAR (4) |
| DIS_CHANNEL | Distribution Channel | CRMT_DISTRIBUTION_CHANNEL | TVTW | CHAR (2) |
| DIVISION | Division | CRMT_DIVISION | TSPA | CHAR (2) |
| SERVICE_ORG_ORI | Origin Indicator: Service Organization | CRMT_SERVICE_ORG_ORIGIN | CHAR (1) | |
| SERVICE_ORGR_ORI | Origin Indicator: Service Scenario Organizational Unit | CRMT_SERVICE_ORG_RESP_ORIGIN | CHAR (1) | |
| SALES_ORG_ORI | Origin Indicator: Sales Organization | CRMT_SALES_ORG_ORIGIN | CHAR (1) | |
| DIS_CHANNEL_ORI | Origin Indicator: Distribution Channel | CRMT_DIS_CHANNEL_ORIGIN | CHAR (1) | |
| SALES_OFF_ORI | Origin Indicator: Sales Office | CRMT_SALES_OFFICE_ORIGIN | CHAR (1) | |
| SALES_GROUP_ORI | Origin Indicator: Sales Group | CRMT_SALES_GROUP_ORIGIN | CHAR (1) | |
| SALES_ORGR_ORI | Origin Indicator: Sales Scenario Organizational Unit | CRMT_SALES_ORG_RESP_ORIGIN | CHAR (1) | |
| DIVISION_ORI | Origin Flag: Division | CRMT_DIVISION_ORIGIN | CHAR (1) | |
| SALES_ORG | Sales Organization ID | CRMT_SALES_ORG | CHAR (14) | |
| SALES_OFFICE | Sales Office | CRMT_SALES_OFFICE | CHAR (14) | |
| SALES_GROUP | Sales Group | CRMT_SALES_GROUP | CHAR (14) | |
| SALES_ORG_RESP | Organizational Unit (Sales) | CRMT_SALES_ORG_RESP | CHAR (14) | |
| SERVICE_ORG | Service Organization | CRMT_SERVICE_ORG | CHAR (14) | |
| SERVICE_ORG_RESP | Organizational Unit (Service) | CRMT_SERVICE_ORG_RESP | CHAR (14) | |
| MAIN_PARTNER | Main Partner | CRMS4_PS_MAIN_PARTNER | * | CHAR (10) |
| PERSON_RESP | Employee Responsible | CRMS4_PS_EMPLOYEE_RESP | * | CHAR (10) |
| APPROVED_BY | Approved By | CRMS4_PS_APPROVED_BY | * | CHAR (10) |
| REJECTED_BY | Rejected By | CRMS4_PS_REJECTED_BY | * | CHAR (10) |
| INBOX_ASSIGNED_TO | Employee Responsible | CRMT_PERSON_RESP | BUT000 | CHAR (10) |
| INBOX_GROUP_ASSIGNED | Responsible Group | CRMT_RESPONSIBLE_GROUP | BUT000 | CHAR (10) |
| INBOX_ACCOUNT | Sales Partners | CRMT_SALESPARTNER | BUT000 | CHAR (10) |
| INBOX_CONTACT_PERSON | Customer Contact Person | CRMT_CONTACT_PERSON | BUT000 | CHAR (10) |
| REGION | Region (State, Province, County) | CRMT_REGION | T005S | CHAR (3) |
| INDUSTRY | Industry Sector | CRMT_INDUSTRY | T016 | CHAR (4) |
| CUST_GROUP1 | Customer Group 1 | CRMT_CUST_GROUP1 | TVV1 | CHAR (3) |
| CUST_GROUP2 | Customer Group 2 | CRMT_CUST_GROUP2 | TVV2 | CHAR (3) |
| CUST_GROUP3 | Customer Group 3 | CRMT_CUST_GROUP3 | TVV3 | CHAR (3) |
| CUST_GROUP4 | Customer Group 4 | CRMT_CUST_GROUP4 | TVV4 | CHAR (3) |
| CUST_GROUP5 | Customer Group 5 | CRMT_CUST_GROUP5 | TVV5 | CHAR (3) |
| PO_NUMBER_SOLD | Sold-To Party’s External Reference Number | CRMT_PO_NUMBER_SOLD | CHAR (35) | |
| PO_DATE_SOLD | Reference Document Date | CRMT_PO_DATE_SOLD | DATS (8) | |
| YOUR_REF_SOLD | Sold-to Party Reference | CRMT_YOUR_REFERENCE_SOLD | CHAR (12) | |
| PO_NUMBER_SHIP | Ship-To Party’s External Reference Number | CRMT_PO_NUMBER_SHIP | CHAR (35) | |
| PO_DATE_SHIP | Ship-To Party’s Reference Document Date | CRMT_PO_DATE_SHIP | DATS (8) | |
| YOUR_REF_SHIP | Ship-To Party Reference | CRMT_YOUR_REFERENCE_SHIP | CHAR (12) | |
| USAGE_TYPE | Usage Indicator | CRMT_USAGE | TVLV | CHAR (3) |
| SUBMISSION | Collective Number for Quotations | CRMT_SUBMISSION | CHAR (10) | |
| REJECTION | Cancellation Reason Code | CRMT_REJECTION_CODE | TVAG | CHAR (2) |
| PROBABILITY | Order Probability | CRMT_ORDER_PROBABILITY | NUMC (3) | |
| DATE_QTY_FIXED | Fixed Date and Quantity | CRMT_DATE_QTY_FIXED | CHAR (1) | |
| REQ_DLV_DATE_H | Requested Delivery Date Header | CRMT_REQ_DLV_DATE | DEC (15) | |
| REQ_TIMEZONE_H | Time Zone Requested Delivery Date Header | CRMT_REQ_DATE_TIMEZONE | * | CHAR (6) |
| RULE_REQ_DATE_H | Rule Reqested Delivery Date Header | CRMT_RULE_REQ_DATE | * | RAW (16) |
| PREDECESSOR_H | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| ROOT_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW (16) | |
| STAT_LIFECYCLE | Life Cycle Status | CRMS4_STAT_LIFECYCLE | CHAR (4) | |
| STAT_RELEASED | Release Status | CRMS4_STAT_RELEASED | CHAR (1) | |
| STAT_ACTIVATION_H | Activation Status | CRMS4_PS_STAT_ACTIVATION | CHAR (1) | |
| STAT_APPROVAL_H | Approval Status | CRMS4_PS_STAT_APPROVAL | CHAR (2) | |
| STAT_SOCIAL_LIFE_CYCLE_H | Social Deduction Plan Header: Lifecycle | CRMS4_PS_PSDP_STAT_LIFECYCLE_H | CHAR (2) | |
| STAT_ARCHIVABLE | Archivable | CRMS4_STAT_ARCHIVABLE | CHAR (1) | |
| STAT_ARCHIVED | Archived | CRMS4_STAT_ARCHIVED | CHAR (1) | |
| STAT_OPEN | Status “Open” | CRMS4_STAT_OPEN | CHAR (1) | |
| INBOX_STATUS | Status of Agent Inbox Item | CRMT_AUI_STATUS | NUMC (4) | |
| PSDP_H_DUMMY_PS | Single-Character Flag | CHAR1 | CHAR (1) |
