CRMS4D_PSSP_I - Social Service Plan Item

Social Service Plan Item information is stored in SAP table CRMS4D_PSSP_I.
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_I

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		CRMS4S_KEY_I	0
.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
NUMBER_INT	Shortened Item Number in Document	X	CRMS4_NUMBER_INT	NUMC	12
.INCLUDE				CRMS4S_PSSP_I_ORDERADM_I	0
ITEM_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
CREATED_AT_I	Created At (Output in User Time Zone)		COMT_CREATED_AT_USR	DEC	8
CREATED_BY_I	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT_I	Changed At (Output in User Time Zone)		COMT_CHANGED_AT_USR	DEC	8
CHANGED_BY_I	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
OBJTYPE_I	CRM Item Object Type		CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CHAR	20	*
HEADER_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
PARENT	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
ALTERNATIVE	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
PRODUCT	Internal Unique ID of Product		CRMT_PRODUCT_GUID_DB	RAW	16
ORDERED_PROD	Product Name Entered		CRMT_ORDERED_PROD_DB	CHAR	108
PARTNER_PROD	Product Number of Business Partner		CRMT_ITEM_DESCR_PARTNER	CHAR	80
DESCRIPTION_I	Product Description		CRMT_PRSHTEXTX_DB	CHAR	80
ITM_LANGUAGE	Short Text Language for an Item		CRMT_ITEM_LANGU	LANG	2
NUMBER_EXT	External Item Number		CRMT_ITEM_NO_EXT	NUMC	20
ITM_TYPE	Item Category		CRMT_ITEM_TYPE_DB	CHAR	8	*
ORDER_DATE	Posting Date		CRMT_ORDER_DATE	DEC	8
ITM_USAGE	Usage of Higher-Level Item		CRMT_ITEM_USAGE	CHAR	4
ITM_TYPE_USAGE	Item Category Usage		CRMT_IT_TYPE_USAGE	CHAR	8	*
PRODUCT_KIND	Product Technical Type		CRMT_PRODUCT_KIND	CHAR	2
REVACC_REFID	Revenue Accounting Reference ID		CRMT_REVACC_REFID	CHAR	60
REVACC_REFTYPE	Revenue Accounting Reference Type		CRMT_REVACC_REFTYPE	CHAR	6
REVACC_RELEVANT_TYPE	Revenue Accounting Type		CRMT_REVACC_RELEVANT_TYPE	CHAR	2
PRODUCT_ID	Product Number		PRODUCTNUMBER	CHAR	80
ITEM_GUID_CHAR	32 Character CRM Object GUID (Converted)		CRMT_OBJECT_GUID32	CHAR	64
.INCLUDE				CRMS4S_PSSP_I_H	0
.INCLUDE				CRMS4S_PSSP_I_ORDERADM_H	0
PROCESS_TYPE	Business Transaction Type		CRMT_PROCESS_TYPE_DB	CHAR	8	*
.INCLUDE				CRMS4S_PSSP_I_DATES_H	0
CONTSTART_H	Contract Start Date		CRMS4_PS_CONTSTART	DEC	8
CONTEND_H	Contract End Date		CRMS4_PS_CONTEND	DEC	8
.INCLUDE				CRMS4S_PSSP_I_STATUS_H	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
.INCLUDE				CRMS4S_PSSP_I_PARTNER_H	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_ITEM_SET_FIELDS	0
ITEM_NO_APPT	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_PARTNER	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_QUALIF	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_REFOBJ	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_SUBJECT	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_SURVEY	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_BILLPLAN	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_PAYPLAN	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
.INCLUDE				CRMS4S_PSSP_I_DATES	0
CONTSTART_I	Contract Start Date		CRMS4_PS_CONTSTART	DEC	8
CONTEND_I	Contract End Date		CRMS4_PS_CONTEND	DEC	8
CONTEND_OLD_I	Previous Contract End Date		CRMS4_PS_CONTEND_OLD	DEC	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_I_PARTNER	0
BENEFICIARY	Beneficiary		CRMS4_PS_BENEFICIARY	CHAR	20	*
PAYMENT_RECIPIENT	Payment Recipient		CRMS4_PS_PAYMENT_RECIPIENT	CHAR	20	*
ALTERNATIVE_PAYEE	Alternative Payee		CRMS4_PS_ALTERNATIVE_PAYEE	CHAR	20	*
.INCLUDE				CRMS4S_PSSP_I_DOC_FLOW	0
PREDECESSOR_I	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMS4S_PSSP_I_PS_SOCIAL_I	0
PARTNER_ID	Business Partner ID		CRM_PS_SCOPE_PARTNER_ID	CHAR	20	*
ADDITIONAL_KEY	Decision Unit Additional Attribute		CRM_PS_SCOPE_ADDITIONAL_KEY	CHAR	64
PAY_METHOD	Payment Method for Outgoing Payments		CRM_PS_4S_PAY_METHOD_OUT	CHAR	10
PAY_ADDRESS_ID	Payment Address GUID		CRM_PS_4S_PAY_ADDR_ID	RAW	16
PAY_BANK_ID	Payment Bank ID		CRM_PS_4S_PAY_BANK_ID	CHAR	8
PAY_COUNTRY	Company Country/Region		LAND	CHAR	6	*
ALT_PAY_METHOD	Payment Method for Outgoing Payments		CRM_PS_4S_PAY_METHOD_OUT	CHAR	10
ALT_PAY_ADDRESS_ID	Payment Address GUID		CRM_PS_4S_PAY_ADDR_ID	RAW	16
ALT_PAY_BANK_ID	Alternate Payment Bank ID		CRMS4_PS_ALT_PAYM_BANK_ID	CHAR	8
ALT_PAY_COUNTRY	Company Country/Region		LAND	CHAR	6	*
.INCLUDE				CRMS4S_PSSP_I_PS_SOCSRV_I	0
AMOUNT	Amount		CRMS4_PS_AMOUNT	CURR	7
CURRENCY	Currency Key		CRM_PS_4S_CURRENCY	CUKY	10	*
ENTITLEMENT_FREQUENCY	Frequency Type		CRMT_4S_FRQ_TYPE	CHAR	8	*
DDR_RP	Due Date Rule		BSPERIOD_DDR_TYPE	CHAR	8	*
DDR_OP	Due Date Rule		BSPERIOD_DDR_TYPE	CHAR	8	*
DDR_UP	Due Date Rule		BSPERIOD_DDR_TYPE	CHAR	8	*
RED_REF_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
RED_REF_PRODUCT	Product Name Entered		CRMT_ORDERED_PROD	CHAR	108
.INCLUDE				CRMS4S_PSSP_I_STATUS	0
STAT_RELEASED_I	Social Service Plan Item: Release Status		CRMS4_PS_PSSP_STAT_RELEASED_I	CHAR	2
STAT_ENTITLED	Social Service Plan Item: Status 'Entitled'		CRMS4_PS_PSSP_STAT_ENTITLED	CHAR	2
STAT_CREATION	Social Service Plan Item: Creation Status		CRMS4_PS_PSSP_STAT_CREATION	CHAR	2
STAT_REDUCTION_I	Social Service Plan Item: Reduction Status		CRMS4_PS_PSSP_STAT_REDUCTION_I	CHAR	2
STAT_ENT_RELEASE_MODE	Social Service Plan Item: Entitlement Release Mode		CRMS4_PS_PSSP_STAT_ENT_REL_MOD	CHAR	2
.INCLUDE				CRMS4S_PSSP_I_INCL_EEW_PS	0
PSSP_I_DUMMY_PS	Single-Character Flag		CHAR1	CHAR	2