CRMS4D_PSSP_H - Social Service Plan Header

Social Service Plan Header information is stored in SAP table CRMS4D_PSSP_H.
It is part of development package CRMS4_PS_1O_PERSISTENCY in software component CRM-S4-IPS-SSP. This development package consists of objects that can be grouped under "One Order Persistency Objects for Social Services".

Fields for table CRMS4D_PSSP_H

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		CRMS4S_KEY_H	0
CLIENT	Client	X	MANDT	CLNT	6	T000
OBJTYPE_H	Business Trans. Cat.	X	CRMT_SUBOBJECT_CATEGORY_DB	CHAR	20	CRMC_SUBOB_CAT
OBJECT_ID	Transaction ID	X	CRMT_OBJECT_ID_DB	CHAR	20
.INCLUDE				CRMS4S_PSSP_H_ORDERADM_H	0
HEADER_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
PROCESS_TYPE	Business Transaction Type		CRMT_PROCESS_TYPE_DB	CHAR	8	*
POSTING_DATE	Posting Date for a Business Transaction		CRMT_POSTING_DATE	DATS	16
DESCRIPTION_H	Transaction Description		CRMT_PROCESS_DESCRIPTION	CHAR	80
DESCR_LANGUAGE	Language Key of Description		CRMT_PROCESS_DESCRIPTION_LANGU	LANG	2	*
TEMPLATE_TYPE	Template Type of CRM Transaction		CRMT_TEMPLATE_TYPE_DB	CHAR	2
CREATED_AT_H	Created At (Output in User Time Zone)		COMT_CREATED_AT_USR	DEC	8
CREATED_BY_H	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT_H	Changed At (Output in User Time Zone)		COMT_CHANGED_AT_USR	DEC	8
CHANGED_BY_H	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
HEAD_CHANGED_AT	Time of Last Change to the Transaction		CRMT_CHANGED_AT	DEC	8
BTX_CLASS	CRM Business Transaction Classification		CRMT_TRANSACTION_CLASSIFICATN	CHAR	2
AUTH_SCOPE	Authorization Scope		CRM_AUTH_SCOPE	NUMC	12	*
ARCHIVING_FLAG	Indicator Whether the Business Transaction Can Be Archived		CRMT_ARCHIVING_FLAG	CHAR	2
OBJECT_ID_OK	Indicator That Transaction ID Is Correct		CRMT_OBJECT_ID_OK	CHAR	2
VERIFY_DATE	Time Period of Last Archiving Attempt		CRMT_VERIFY_DATE	DEC	8
PRICING_DOCUMENT	Number of the Document Condition		KNUMV	CHAR	20
PRICING_PROCEDURE	Procedure (Pricing, Output Control, Acct. Det., Costing,...)		KALSM_D	CHAR	12	*
HEADER_GUID_CHAR	32 Character CRM Object GUID (Converted)		CRMT_OBJECT_GUID32	CHAR	64
SDM_STATUS_DURA	SDM status of duration migration		CRMS4_SDM_STATUS_DURA	CHAR	4
.INCLUDE				CRMS4S_PSSP_H_DATES	0
CONTSTART_H	Contract Start Date		CRMS4_PS_CONTSTART	DEC	8
CONTEND_H	Contract End Date		CRMS4_PS_CONTEND	DEC	8
APPROVEDATE_H	Approval Date		CRMS4_PS_APPROVEDATE	DEC	8
LATEAPPROVAL_H	Latest Approval Date		CRMS4_PS_LATEAPPROVAL	DEC	8
DECISION_H	Decision Date		CRMS4_PS_DECISIONDATE	DEC	8
.INCLUDE				CRMS4S_PSSP_H_CHNGPROC_H	0
BUSINESS_PROCESS	Business Transaction		J_VORGANG	CHAR	8	*
CHNG_PROCESS	Change Process		CRMT_LEAS_CHNG	CHAR	8	*
CHNG_PROCESS_SUB	Change of Lease: Sub-Change Process		CRMT_LEAS_CHNG_SUB1	CHAR	8	*
.INCLUDE				CRMS4S_PSSP_C_ORGMAN	0
DIS_CHANNEL	Distribution Channel		CRMT_DISTRIBUTION_CHANNEL	CHAR	4	TVTW
DIVISION	Division		CRMT_DIVISION	CHAR	4	TSPA
SERVICE_ORG_ORI	Origin Indicator: Service Organization		CRMT_SERVICE_ORG_ORIGIN	CHAR	2
SERVICE_ORGR_ORI	Origin Indicator: Service Scenario Organizational Unit		CRMT_SERVICE_ORG_RESP_ORIGIN	CHAR	2
SALES_ORG_ORI	Origin Indicator: Sales Organization		CRMT_SALES_ORG_ORIGIN	CHAR	2
DIS_CHANNEL_ORI	Origin Indicator: Distribution Channel		CRMT_DIS_CHANNEL_ORIGIN	CHAR	2
SALES_OFF_ORI	Origin Indicator: Sales Office		CRMT_SALES_OFFICE_ORIGIN	CHAR	2
SALES_GROUP_ORI	Origin Indicator: Sales Group		CRMT_SALES_GROUP_ORIGIN	CHAR	2
SALES_ORGR_ORI	Origin Indicator: Sales Scenario Organizational Unit		CRMT_SALES_ORG_RESP_ORIGIN	CHAR	2
DIVISION_ORI	Origin Flag: Division		CRMT_DIVISION_ORIGIN	CHAR	2
SALES_ORG	Sales Organization ID		CRMT_SALES_ORG	CHAR	28
SALES_OFFICE	Sales Office		CRMT_SALES_OFFICE	CHAR	28
SALES_GROUP	Sales Group		CRMT_SALES_GROUP	CHAR	28
SALES_ORG_RESP	Organizational Unit (Sales)		CRMT_SALES_ORG_RESP	CHAR	28
SERVICE_ORG	Service Organization		CRMT_SERVICE_ORG	CHAR	28
SERVICE_ORG_RESP	Organizational Unit (Service)		CRMT_SERVICE_ORG_RESP	CHAR	28
.INCLUDE				CRMS4S_ORGMAN_SALES_SD	0
SALES_ORG_SD	Sales Organization		VKORG	CHAR	8
SALES_OFFICE_SD	Sales office		VKBUR	CHAR	8	*
SALES_GROUP_SD	Sales group		VKGRP	CHAR	6	*
.INCLUDE				CRMS4S_PSSP_H_PARTNER	0
MAIN_PARTNER	Main Partner		CRMS4_PS_MAIN_PARTNER	CHAR	20	*
PERSON_RESP	Employee Responsible		CRMS4_PS_EMPLOYEE_RESP	CHAR	20	*
APPROVED_BY	Approved By		CRMS4_PS_APPROVED_BY	CHAR	20	*
REJECTED_BY	Rejected By		CRMS4_PS_REJECTED_BY	CHAR	20	*
.INCLUDE				CRMS4S_INBOX_PARTNER	0
INBOX_ASSIGNED_TO	Employee Responsible		CRMT_PERSON_RESP	CHAR	20	BUT000
INBOX_GROUP_ASSIGNED	Responsible Group		CRMT_RESPONSIBLE_GROUP	CHAR	20	BUT000
INBOX_ACCOUNT	Sales Partners		CRMT_SALESPARTNER	CHAR	20	BUT000
INBOX_CONTACT_PERSON	Customer Contact Person		CRMT_CONTACT_PERSON	CHAR	20	BUT000
.INCLUDE				CRMS4S_PSSP_H_DOC_FLOW	0
PREDECESSOR_H	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMS4S_PSSP_H_SALES	0
.INCLUDE				CRMS4S_PSSP_C_SALES	0
REGION	Region (State, Province, County)		CRMT_REGION	CHAR	6	T005S
INDUSTRY	Industry Sector		CRMT_INDUSTRY	CHAR	8	T016
CUST_GROUP1	Customer Group 1		CRMT_CUST_GROUP1	CHAR	6	TVV1
CUST_GROUP2	Customer Group 2		CRMT_CUST_GROUP2	CHAR	6	TVV2
CUST_GROUP3	Customer Group 3		CRMT_CUST_GROUP3	CHAR	6	TVV3
CUST_GROUP4	Customer Group 4		CRMT_CUST_GROUP4	CHAR	6	TVV4
CUST_GROUP5	Customer Group 5		CRMT_CUST_GROUP5	CHAR	6	TVV5
PO_NUMBER_SOLD	Sold-To Party's External Reference Number		CRMT_PO_NUMBER_SOLD	CHAR	70
PO_DATE_SOLD	Reference Document Date		CRMT_PO_DATE_SOLD	DATS	16
YOUR_REF_SOLD	Sold-to Party Reference		CRMT_YOUR_REFERENCE_SOLD	CHAR	24
PO_NUMBER_SHIP	Ship-To Party's External Reference Number		CRMT_PO_NUMBER_SHIP	CHAR	70
PO_DATE_SHIP	Ship-To Party's Reference Document Date		CRMT_PO_DATE_SHIP	DATS	16
YOUR_REF_SHIP	Ship-To Party Reference		CRMT_YOUR_REFERENCE_SHIP	CHAR	24
USAGE_TYPE	Usage Indicator		CRMT_USAGE	CHAR	6	TVLV
SUBMISSION	Collective Number for Quotations		CRMT_SUBMISSION	CHAR	20
REJECTION	Cancellation Reason Code		CRMT_REJECTION_CODE	CHAR	4	TVAG
PROBABILITY	Order Probability		CRMT_ORDER_PROBABILITY	NUMC	6
DATE_QTY_FIXED	Fixed Date and Quantity		CRMT_DATE_QTY_FIXED	CHAR	2
REQ_DLV_DATE_H	Requested Delivery Date Header		CRMT_REQ_DLV_DATE	DEC	8
REQ_TIMEZONE_H	Time Zone Requested Delivery Date Header		CRMT_REQ_DATE_TIMEZONE	CHAR	12	TTZZ
RULE_REQ_DATE_H	Rule Reqested Delivery Date Header		CRMT_RULE_REQ_DATE	RAW	16	TIMERULEH
.INCLUDE				CRMS4S_PSSP_H_PS_SOCIAL_H	0
ROOT_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
BENEFIT_PROG	Benefit Program		CRM_PS_BENEFIT_PROG	CHAR	8	*
PAYMENT_FAMILY	Payment Family		CRMS4_PS_PAY_FAM	CHAR	8	*
MR_DATE_ID	Date ID		LAUFD_KK	DATS	16
MR_IDENT	Run ID		LAUFI_KK	CHAR	12
DFLW_ID	Transaction ID		CRMT_OBJECT_ID	CHAR	20
.INCLUDE				CRMS4S_PSSP_H_STATUS	0
STAT_LIFECYCLE	Life Cycle Status		CRMS4_STAT_LIFECYCLE	CHAR	8
STAT_RELEASED	Release Status		CRMS4_STAT_RELEASED	CHAR	2
STAT_ACTIVATION_H	Activation Status		CRMS4_PS_STAT_ACTIVATION	CHAR	2
STAT_APPROVAL_H	Approval Status		CRMS4_PS_STAT_APPROVAL	CHAR	4
STAT_SOCIAL_LIFECYCLE_H	Social Service Plan Header: Lifecycle		CRMS4_PS_PSSP_STAT_LIFECYCLE_H	CHAR	4
STAT_REDUCTION_H	Social Service Plan Header: Reduction Decision		CRMS4_PS_PSSP_STAT_REDUCTION_H	CHAR	2
STAT_RERUN_REQUIRED	Social Service Plan Header: Status 'Rerun Required'		CRMS4_PS_PSSP_STAT_RERUN_REQ	CHAR	2
STAT_ARCHIVABLE	Archivable		CRMS4_STAT_ARCHIVABLE	CHAR	2
STAT_OPEN	Status "Open"		CRMS4_STAT_OPEN	CHAR	2
STAT_ARCHIVED	Archived		CRMS4_STAT_ARCHIVED	CHAR	2
STAT_MR_FAILED	Social Service Plan Header: Status 'MRC failed'		CRMS4_PS_PSSP_STAT_MR_FAILED	CHAR	2
INBOX_STATUS	Status of Agent Inbox Item		CRMT_AUI_STATUS	NUMC	8
.INCLUDE				CRMS4S_PSSP_H_INCL_EEW_PS	0
PSSP_H_DUMMY_PS	Single-Character Flag		CHAR1	CHAR	2