PSSCD_SXPITEM - SXP Item Data

SXP Item Data information is stored in SAP table PSSCD_SXPITEM.
It is part of development package PSSC_DDIC in software component IS-PS-4S. This development package consists of objects that can be grouped under "Social Services DDIC Objects".

Fields for table PSSCD_SXPITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
VERSIONID	Social Services Object Version	X	PSSCSXPOBJECTVERSIONID	RAW	16	PSSCD_SXP
ITEMID	Social Services Business Object Item ID	X	PSSCSXPITEMID	RAW	16
.INCLUDE				PSSCS_SXPITEMCONTENT	0
.INCLUDE				PSSCS_CONTROL_I_SXP	0
BEGDA	Social Services Begin Date		PSSCBEGDA	DATS	16
ENDDA	Social Services End Date		PSSCENDDA	DATS	16
AMOUNT	Amount		PSSC_AMOUNT	CURR	7
CURRENCY	Item Currency		PSSC_CURRENCY	CUKY	10	TCURC
REF_GUID	Social Services Reference to Previous SXP Item ID		PSSC_SXPITEM_REF_PREV_VERS	RAW	16
.INCLUDE				PSSCS_ALT_PAY_INFO	0
ALT_PAYEE_GUID	Alternative Payee GUID		PSSC_ALTERNATIVE_PAYEE_GUID	RAW	16
ALT_PAYEE_NO	Alternative Payee Number		PSSC_ALTERNATIVE_PAYEE_NO	CHAR	20	BUT000
ALT_PAY_METHOD	Payment Method for Outgoing Payments		PSSC_PAYM_METHOD_OUT	CHAR	2	TFK042Z
ALT_PAY_ADDR_ID	Alternate Payment Address ID		PSSC_ALT_PAYM_ADDRESS_ID	CHAR	20	ADRC
ALT_PAY_ADDRGUID	Alternate Payment Address as GUID		PSSC_ALT_PAYM_ADDRESS_GUID	RAW	16
ALT_PAY_BANK_ID	Alternate Payment Bank ID		PSSC_ALT_PAYM_BANK_ID	CHAR	8
.INCLUDE				PSSCS_DEDUCT_INFO	0
DEDUCT_PERCENT	Deduction Percentage		PSSC_PERCENTAGE	DEC	4
DEDUCT_PARTIAL	Partial Deduction		PSSC_PARTIAL_DEDUCTION	CHAR	2
DEDUCT_PRIORITY	Priority for items with same deduction type		PSSC_PRIORITY	NUMC	6
DEDUCT_TO_PARTY	Deduct-To Party (GUID)		PSSC_DEDUCT_TO_PARTY	RAW	16
DEDUCT_TO_PAR_NO	Deduct-To Party (Business Partner Number)		PSSC_DEDUCT_TO_PARTY_NO	CHAR	20	*
DEDUCT_PAYM_FAM	Payment Family		PSSC_PAYMENT_FAMILY	CHAR	8	PSSCC_PMNT_FAM
DEDUCT_DDR_TYPE	Due Date Rule		PSSC_DDR_TYPE	CHAR	8	BSPER_DDR_TYPE
.INCLUDE				PSSCS_SXPITEM_CD	0
CREATED_AT	Created At (Output in User Time Zone)		COMT_CREATED_AT_USR	DEC	8
CREATED_BY	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT	Changed At (Output in User Time Zone)		COMT_CHANGED_AT_USR	DEC	8
CHANGED_BY	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
OBJECT_TYPE	CRM Item Object Type		PSSC_OBJECT_TYPE_ITM	CHAR	20
HEADER	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
PRODUCT	Internal Unique ID of Product		CRMT_PRODUCT_GUID_DB	RAW	16
DESCRIPTION	Product Description		CRMT_PRSHTEXTX_DB	CHAR	80
ITM_LANGUAGE	Short Text Language for an Item		CRMT_ITEM_LANGU	LANG	2
NUMBER_INT	Item Number in Document		CRMT_ITEM_NO	NUMC	20
NUMBER_EXT	External Item Number		CRMT_ITEM_NO_EXT	NUMC	20
ITM_TYPE	Item Category (CRM)		PSSC_CRM_ITEM_TYPE	CHAR	8	PSSCC_ITM_TYPE
LOG_SYSTEM_EXT	Logical System		CRMT_LOGSYS	CHAR	20	*
ORDERED_PROD	Product Name Entered		CRMT_ORDERED_PROD_DB	CHAR	108
.INCLUDE				INCL_EEW_ORDERADM_I	0
ORDERADM_I_DUMMY	Dummy function in length 1		DUMMY	CHAR	2
.INCLUDE				CI_EEW_ORDERADM_I	0
.INCLUDE				PSSCS_SXP_PARTNER_I	0
BENE_BENEFICIARY	Benefit Beneficiary (GUID)		PSSC_BENEFIT_BENEFICIARY	RAW	16
BENE_BENEFI_NO	Benefit Beneficiary Number		PSSC_BENE_BENEFI_NO	CHAR	20	BUT000
PAYM_RECIPIENT	Payment Recipient (GUID)		PSSC_PAYMENT_RECIPIENT	RAW	16
PAYM_RECIPI_NO	Payment Recipient Number		PSSC_PAYMENT_RECIPIENT_NO	CHAR	20	BUT000
MORE_PMT_RCPNTS	Boolean for Social Services		PSSCBOOLEAN	CHAR	2
.INCLUDE				PSSCS_SXP_STATUS_I	0
ACTIVATED	Status Active		PSSCACTIVE	CHAR	2
ADJUSTED	Adjusted		PSSCADJUSTED	CHAR	2
AUTOMATIC	Automatic		PSSCAUTOMATIC	CHAR	2
REJECTED	Rejected		PSSCREJECTED	CHAR	2
NOT_ENTITLED	Not Entitled		PSSCNOTENTITLED	CHAR	2
.INCLUDE				PSSCS_SXP_SCOPE_H_WRK	0
SCOPE_PARTNER_ID	Business Partner ID for Decision Unit		PSSC_SCOPE_PARTNER_ID	CHAR	20	*
SCOPE_ADDITIONAL_KEY	Additional Attribute of Decision Unit		PSSC_SCOPE_ATTRIBUTE	CHAR	64
SCOPE_DESCRIPTION	Decision Unit Description		PSSC_SCOPE_DESCRIPTION	CHAR	100
SCOPE_CREATION_MODE	Decision Unit Category		PSSC_SCOPE_CREATION_MODE	CHAR	2
.INCLUDE				PSSCS_REDUCTION	0
RED_REF_GUID	Internal Unique ID of Product		CRMT_PRODUCT_GUID_DB	RAW	16
RED_REF_PRODUCT	Reference Benefit ID		PSSC_RED_REF_PRODUCT	CHAR	108
IS_REDUCTION	Item is a Reduction Item		PSSC_IS_REDUCTION	CHAR	2
.INCLUDE				PSSCS_PREQ	0
ENTITLEMENT_RELEASE_MODE	Release Mode for Entitlement Item		PSSC_ENT_ITM_REL_MODE	CHAR	2