CRMD_PS_GPDITEM - Gross Payment Docment Item Data

Gross Payment Docment Item Data information is stored in SAP table CRMD_PS_GPDITEM.
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_GPDITEM

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_GPD
ITEMID	Social Services Business Object Item ID	X	CRMS4_PS_ITEM_GUID	RAW	16
.INCLUDE				CRMS4S_PS_GPDITEM_CON	0
SXP_OBJECTID	Social Service Business Object Identifier		CRMS4_PS_OBJECT_GUID	RAW	16
GED_VERSIONID	Gross Entitlement Document Version ID		CRMS4_PS_GED_VERSION_GUID	RAW	16
GED_ITEMID	Gross Entitlement Item ID		CRMS4_PS_GEDITEM_GUID	RAW	16
BEGDA	Begin Gross Payment Item		CRMS4_PS_GPI_BEGDA	DATS	16
ENDDA	End Gross Payment Item		CRMS4_PS_GPI_ENDDA	DATS	16
TRUE_BEGDA	Social Services Begin Date		CRMS4_PS_BEGDA	DATS	16
TRUE_ENDDA	Social Services End Date		CRMS4_PS_ENDDA	DATS	16
BENEFIT_ID	Internal Unique ID of Product		CRMT_PRODUCT_GUID_DB	RAW	16
BENEFIT_ID_EXT	Benefit ID (external representation)		CRMS4_PS_BENEFIT_ID_EXT	CHAR	108
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
PROCESS_CATEGORY	Gross Payment Item Process Category		CRMS4_PS_PAYMENT_CATEGORY	CHAR	2
PAYMENT_FAMILY	Payment Family		CRM_PS_4S_PAYMENT_FAMILY	CHAR	8	CRMC_PS_PMNT_F
AMOUNT	Amount		CRMS4_PS_AMOUNT	CURR	7
CURRENCY	Currency Key		CRM_PS_4S_CURRENCY	CUKY	10	TCURC
ENTITLEMENT_FREQ	Entitlement Frequency Type		CRMS4_PS_ENT_FRQ_TYPE	CHAR	8	BSPER_FRQ_TYPE
ENTITLEMENT_CAT	Entitlement Category (Entitled or Not Entitled)		CRMS4_PS_ENTITLE_CAT	CHAR	2
ITM_TYPE	Item Category (CRM)		CRMS4_PS_CRM_ITEM_TYPE	CHAR	8	*
PMNT_FRQ_TYPE	Payment Frequency Type		CRMS4_PS_PAYMENT_FRQ_TYPE	CHAR	8	BSPER_FRQ_TYPE
DDR_TYPE	Due Date Rule		CRMS4_PS_DDR_TYPE	CHAR	8	BSPER_DDR_TYPE
DUE_DATE	Due Date		CRM_PS_4S_DUE_DATE	DATS	16
DUE_PERIOD_BEGDA	Begin Payment Period		CRMS4_PS_PAYMENT_BEGIN	DATS	16
DUE_PERIOD_ENDDA	End Payment Period		CRMS4_PS_PAYMENT_END	DATS	16
DUE_PER_BEG_ORIG	Start Date of Payment Period		CRMS4_PS_DUE_PERIOD_BEGDA_ORIG	DATS	16
DUE_PER_END_ORIG	End Date of Payment Period		CRMS4_PS_DUE_PERIOD_ENDDA_ORIG	DATS	16
TAX_CATEGORY	Tax Category		CRMS4_PS_TAX_CAT	CHAR	8
CALC_TIMESTAMP	Time Stamp of Calculation		CRMS4_PS_CALCULATED_AT	DEC	8
OBSOLETED_AT	Obsolete Time Stamp		CRMS4_PS_OBSOLETED_AT	DEC	8
ORIGINAL_GPI	Original Gross Payment Item		CRMS4_PS_ORIGINAL_GPI_GUID	RAW	16
DELIMITATING_GPI	Delimitation Gross Payment Item		CRMS4_PS_GPI_DELIMITATION_DATE	RAW	16
ACTIVATION_STATUS	Activation Status		CRMS4_PS_ACTIVATION_STATUS	CHAR	2
SXP_VERSIONID	Social Services Object Version		CRMS4_PS_VERSIONID_RAW	RAW	16
SXP_ITEMID	Social Services Business Object Item ID		CRMS4_PS_ITEM_ID_RAW	RAW	16
SXP_ITEMID_PRED	Social Services Business Object Item ID		CRMS4_PS_ITEM_ID_RAW	RAW	16
SXP_KIND	Business Trans. Cat.		CRMS4_PS_BUS_TYPE_HEADER	CHAR	20
SXP_TYPE	Business Transaction Type		CRMT_PROCESS_TYPE	CHAR	8
DUE_DATE_NC	Due Date Net Calculation Execution		CRMS4_PS_DUE_DATE_NC	DATS	16
NC_GPD_ENDDA	Net Calculation for GPD Item Performed Until (End Date)		CRMS4_PS_NC_GPD_ENDDA	DATS	16
.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
.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	*
DEDUCTION_TYPE	Deduction Type		CRMS4_PS_DEDUCT_TYPE	CHAR	8	CRMC_PS_DDT
CREATED_AT	Created at (Timestamp)		CRMS4_PS_CREATED_AT	DEC	8
CHANGE_AT	Changed at (Timestamp)		CRMS4_PS_CHANGED_AT	DEC	8
.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_GPDITEM_INCL_EEW_PS	0
DUMMY_GPDITEM_PS	Single-Character Flag		CHAR1	CHAR	2