CRMD_PS_GEDITEM - Gross Entitlement Determination Item Data

Gross Entitlement Determination Item Data information is stored in SAP table CRMD_PS_GEDITEM.
It is part of development package CRMS4_PS_DDIC in software component CRM-S4-IPS-SEP. This development package consists of objects that can be grouped under "Social Services DDIC Objects".

Fields for table CRMD_PS_GEDITEM

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
VERSIONID	Version of a Social Services Object	X	CRMS4_PS_VERS_GUID	RAW	16	CRMD_PS_GED
ITEMID	Social Services Business Object Item ID	X	CRMS4_PS_ITEM_GUID	RAW	16
.INCLUDE				CRMS4S_PS_GEDITEM_CON	0
BEGDA	Social Services Begin Date		CRMS4_PS_BEGDA	DATS	16
ENDDA	Social Services End Date		CRMS4_PS_ENDDA	DATS	16
SXP_ITEM_GUID	Reference from GED Item to SXP Item		CRMS4_PS_REF_GED_SXP_ITEMID	RAW	16
BENEFIT_ID	Benefit ID		CRMS4_PS_BENEFIT_ID	RAW	16
BENEFIT_ID_EXT	Benefit ID (external representation)		CRMS4_PS_BENEFIT_ID_EXT	CHAR	108
AMOUNT	Amount		CRMS4_PS_AMOUNT	CURR	7
CURRENCY	Currency Key		CRM_PS_4S_CURRENCY	CUKY	10	TCURC
FREQUENCY_TYPE	Entitlement Frequency Type		CRMS4_PS_ENT_FRQ_TYPE	CHAR	8	BSPER_FRQ_TYPE
BENE_BENEFICIARY	Benefit Beneficiary (GUID)		CRMS4_PS_BENEFICIARY_GUID_RAW	RAW	16
BENE_BENEFI_NO	Benefit Beneficiary Number		CRMS4_PS_BENEFICIARY_ID	CHAR	20	BUT000
PAYM_RECIPIENT	Payment Recipient (GUID)		CRMS4_PS_PAYMENT_REC_GUID_RAW	RAW	16
PAYM_RECIPI_NO	Payment Recipient Number		CRMS4_PS_PAYMENT_REC_ID	CHAR	20	BUT000
TAX_CATEGORY	Tax Category		CRMS4_PS_TAX_CAT	CHAR	8
HOLD_FLAG	Item Is on Hold		CRMS4_PS_HOLD_FLAG	CHAR	2
RELEASE_STATUS	Release Status for GED		CRMS4_PS_RELEASE_STATUS	CHAR	2
DEDUCTION_TYPE	Deduction Type		CRMS4_PS_DEDUCT_TYPE	CHAR	8	CRMC_PS_DDT
ITM_TYPE	Item Category (CRM)		CRMS4_PS_CRM_ITEM_TYPE	CHAR	8	*
TYPE_USAGE	Usage Type (Automatic/Manual/Adjusted)		CRMS4_PS_ITEM_CREATION_MODE	CHAR	8
ENTITLEMENT_CAT	Entitlement Category (Entitled or Not Entitled)		CRMS4_PS_ENTITLE_CAT	CHAR	2
.INCLUDE				CRMS4S_PS_DEDUCT_INFO	0
DEDUCT_PERCENT	Deduction Percentage		CRMS4_PS_PERCENTAGE	DEC	4
DEDUCT_PARTIAL	Partial Deduction		CRMS4_PS_PARTIAL_DED	CHAR	2
DEDUCT_PRIORITY	Priority for Items with the Same Deduction Type		CRMS4_PS_NET_DEDUCT_PRIORITY	NUMC	6
DEDUCT_TO_PARTY	Deduct-To Party (GUID)		CRMS4_PS_DEDUCT_TO_PARTY_GUID	RAW	16
DEDUCT_TO_PAR_NO	Deduct-To Party (Business Partner Number)		CRMS4_PS_DEDUCT_TO_PARTY_ID	CHAR	20	*
DEDUCT_PAYM_FAM	Payment Family		CRM_PS_4S_PAYMENT_FAMILY	CHAR	8	CRMC_PS_PMNT_F
DEDUCT_DDR_TYPE	Due Date Rule		CRMS4_PS_DDR_TYPE	CHAR	8	BSPER_DDR_TYPE
.INCLUDE				CRMS4S_PS_ALT_PAY_INFO	0
ALT_PAYEE_GUID	Alternative Payee GUID		CRMS4_PS_ALT_PAYEE_GUID_RAW	RAW	16
ALT_PAYEE_NO	Alternative Payee Number		CRMS4_PS_ALTERNATIVE_PAYEE_ID	CHAR	20	BUT000
ALT_PAY_METHOD	Payment Method for Outgoing Payments		CRMS4_PS_PAYMENT_METHOD_OUT	CHAR	2	TFK042Z
ALT_PAY_ADDR_ID	Alternate Payment Address ID		CRMS4_PS_ALT_PAYM_ADDRESS_ID	CHAR	20	ADRC
ALT_PAY_ADDRGUID	Alternate Payment Address as GUID		CRMS4_PS_ALT_PAYM_ADD_GUID_RAW	RAW	16
ALT_PAY_BANK_ID	Alternate Payment Bank ID		CRMS4_PS_ALT_PAYM_BANK_ID	CHAR	8
PREQ_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
.INCLUDE				CRMS4S_PS_SXP_DU_H_WRK	0
SCOPE_PARTNER_ID	Business Partner ID for Decision Unit		CRMS4_PS_DU_PARTNER_ID	CHAR	20	*
SCOPE_ADDITIONAL_KEY	Additional Attribute of Decision Unit		CRMS4_PS_DU_ATTRIBUTE	CHAR	64
SCOPE_DESCRIPTION	Decision Unit Description		CRMS4_PS_DU_T	CHAR	100
SCOPE_CREATION_MODE	Decision Unit Category		CRMS4_PS_DU_CREATION_MODE	CHAR	2
.INCLUDE				CRMS4S_PS_REDUCTION	0
RED_REF_GUID	Internal Unique ID of Product		CRMT_PRODUCT_GUID_DB	RAW	16
RED_REF_PRODUCT	Reference Benefit ID		CRMS4_PS_RED_REF_PRODUCT	CHAR	108
IS_REDUCTION	Item is a Reduction Item		CRMS4_PS_IS_REDUCTION	CHAR	2
.INCLUDE				CRMS4S_PS_PREQ	0
ENTITLEMENT_RELEASE_MODE	Release Mode for Entitlement Item		CRMS4_PS_ENT_I_REL_MODE	CHAR	2
.INCLUDE				CRMS4S_PS_GEDITEM_INCL_EEW_PS	0
DUMMY_GEDITEM_PS	Single-Character Flag		CHAR1	CHAR	2