CRMD_PS_GPDITEM

Gross Payment Docment Item Data | #itemdata | Component: S4CRM: Social Entitlements & Payments Processing
Column Name Description
MANDT FK Client
VERSIONID FK Version of a Social Services Object
ITEMID Social Services Business Object Item ID
Column Name Description
💲 Currency Key (CURRENCY):
AMOUNT Amount
Column Name Description
Column Name Description
BEGDA Begin Gross Payment Item
ENDDA End Gross Payment Item
TRUE_BEGDA Social Services Begin Date
TRUE_ENDDA Social Services End Date
DUE_DATE Due Date
DUE_PERIOD_BEGDA Begin Payment Period
DUE_PERIOD_ENDDA End Payment Period
DUE_PER_BEG_ORIG Start Date of Payment Period
DUE_PER_END_ORIG End Date of Payment Period
DUE_DATE_NC Due Date Net Calculation Execution
NC_GPD_ENDDA Net Calculation for GPD Item Performed Until (End Date)
Column Name Description
PROCESS_CATEGORY Gross Payment Item Process Category Show values
ENTITLEMENT_CAT Entitlement Category (Entitled or Not Entitled) Show values
ACTIVATION_STATUS Activation Status Show values
DEDUCT_PARTIAL Partial Deduction Show values
SCOPE_CREATION_MODE Decision Unit Category Show values
IS_REDUCTION Item is a Reduction Item Show values
ENTITLEMENT_RELEASE_MODE Release Mode for Entitlement Item Show values
Column Name Description Domain name
SXP_OBJECTID Social Service Business Object Identifier SYSGUID
GED_VERSIONID Gross Entitlement Document Version ID SYSUUID
GED_ITEMID Gross Entitlement Item ID SYSUUID
BENEFIT_ID Internal Unique ID of Product SYSUUID
BENEFIT_ID_EXT Benefit ID (external representation) CRM_ORDERED_PROD
BENE_BENEFICIARY Benefit Beneficiary (GUID) SYSUUID
PAYM_RECIPIENT Payment Recipient (GUID) SYSUUID
ITM_TYPE Item Category (CRM) CRMS4_PS_CRM_ITEM_TYPE
TAX_CATEGORY Tax Category CRMS4_PS_TAX_CAT
CALC_TIMESTAMP Time Stamp of Calculation CRMS4_PS_TSTMP
OBSOLETED_AT Obsolete Time Stamp CRMS4_PS_TSTMP
ORIGINAL_GPI Original Gross Payment Item SYSUUID
DELIMITATING_GPI Delimitation Gross Payment Item SYSUUID
SXP_VERSIONID Social Services Object Version SYSUUID
SXP_ITEMID Social Services Business Object Item ID SYSUUID
SXP_ITEMID_PRED Social Services Business Object Item ID SYSUUID
SXP_KIND Business Trans. Cat. CRMS4_PS_BUS_TYPE_HEADER
SXP_TYPE Business Transaction Type CRM_PROCESS_TYPE
ALT_PAYEE_GUID Alternative Payee GUID SYSUUID
ALT_PAY_ADDRGUID Alternate Payment Address as GUID SYSUUID
ALT_PAY_BANK_ID Alternate Payment Bank ID CHAR4
DEDUCT_PERCENT Deduction Percentage CRMS4_PS_PERCENTAGE
DEDUCT_PRIORITY Priority for Items with the Same Deduction Type CRMS4_PS_NET_DEDUCT_PRIORITY
DEDUCT_TO_PARTY Deduct-To Party (GUID) SYSUUID
DEDUCT_TO_PAR_NO Deduct-To Party (Business Partner Number) BU_PARTNER
CREATED_AT Created at (Timestamp) TZNTSTMPS
CHANGE_AT Changed at (Timestamp) TZNTSTMPS
SCOPE_PARTNER_ID Business Partner ID for Decision Unit BU_PARTNER
SCOPE_ADDITIONAL_KEY Additional Attribute of Decision Unit CRMS4_PS_DU_ATTRIBUTE
SCOPE_DESCRIPTION Decision Unit Description CRMS4_PS_DU_T
RED_REF_GUID Internal Unique ID of Product SYSUUID
RED_REF_PRODUCT Reference Benefit ID CRM_ORDERED_PROD
DUMMY_GPDITEM_PS Single-Character Flag CHAR1
Master Data Relations Join Conditions
Alternative Payee Number
  • Alternative Payee Number
  • Client
  • CRMD_PS_GPDITEM.ALT_PAYEE_NO == BUT000.PARTNER
  • CRMD_PS_GPDITEM.MANDT == BUT000.CLIENT
Alternate Payment Address ID
  • Alternate Payment Address ID
  • ?
  • ?
  • CRMD_PS_GPDITEM.MANDT == ADRC.CLIENT
  • CRMD_PS_GPDITEM.ALT_PAY_ADDR_ID == ADRC.ADDRNUMBER
  • CRMD_PS_GPDITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • CRMD_PS_GPDITEM.[column in domain "AD_NATION"] == ADRC.NATION
Payment Method for Outgoing Payments
  • Payment Method for Outgoing Payments
  • ?
  • Client
  • CRMD_PS_GPDITEM.ALT_PAY_METHOD == TFK042Z.ZLSCH
  • CRMD_PS_GPDITEM.[column in domain "LAND1"] == TFK042Z.LAND1
  • CRMD_PS_GPDITEM.MANDT == TFK042Z.MANDT
Benefit Beneficiary Number
  • Benefit Beneficiary Number
  • Client
  • CRMD_PS_GPDITEM.BENE_BENEFI_NO == BUT000.PARTNER
  • CRMD_PS_GPDITEM.MANDT == BUT000.CLIENT
Currency Key
  • CRMD_PS_GPDITEM.MANDT == TCURC.MANDT
  • CRMD_PS_GPDITEM.CURRENCY == TCURC.WAERS
Due Date Rule
  • Due Date Rule
  • ?
Deduction Type
Entitlement Frequency Type
  • ?
  • Entitlement Frequency Type
Client CRMD_PS_GPDITEM.MANDT == T000.MANDT
Payment Family
  • Payment Family
  • Client
Payment Recipient Number
  • Payment Recipient Number
  • Client
  • CRMD_PS_GPDITEM.PAYM_RECIPI_NO == BUT000.PARTNER
  • CRMD_PS_GPDITEM.MANDT == BUT000.CLIENT
Payment Frequency Type
  • ?
  • Payment Frequency Type