CRMD_PS_GEDITEM

Gross Entitlement Determination 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 Social Services Begin Date
ENDDA Social Services End Date
Column Name Description
HOLD_FLAG Item Is on Hold Show values
RELEASE_STATUS Release Status for GED Show values
TYPE_USAGE Usage Type (Automatic/Manual/Adjusted) Show values
ENTITLEMENT_CAT Entitlement Category (Entitled or Not Entitled) 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_ITEM_GUID Reference from GED Item to SXP Item SYSUUID
BENEFIT_ID Benefit ID SYSUUID
BENEFIT_ID_EXT Benefit ID (external representation) CRM_ORDERED_PROD
BENE_BENEFICIARY Benefit Beneficiary (GUID) SYSUUID
PAYM_RECIPIENT Payment Recipient (GUID) SYSUUID
TAX_CATEGORY Tax Category CRMS4_PS_TAX_CAT
ITM_TYPE Item Category (CRM) CRMS4_PS_CRM_ITEM_TYPE
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
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
PREQ_GUID GUID of a CRM Order Object SYSUUID
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_GEDITEM_PS Single-Character Flag CHAR1
Master Data Relations Join Conditions
Alternative Payee Number
  • Alternative Payee Number
  • Client
  • CRMD_PS_GEDITEM.ALT_PAYEE_NO == BUT000.PARTNER
  • CRMD_PS_GEDITEM.MANDT == BUT000.CLIENT
Alternate Payment Address ID
  • Alternate Payment Address ID
  • ?
  • ?
  • CRMD_PS_GEDITEM.MANDT == ADRC.CLIENT
  • CRMD_PS_GEDITEM.ALT_PAY_ADDR_ID == ADRC.ADDRNUMBER
  • CRMD_PS_GEDITEM.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • CRMD_PS_GEDITEM.[column in domain "AD_NATION"] == ADRC.NATION
Payment Method for Outgoing Payments
  • Payment Method for Outgoing Payments
  • ?
  • Client
  • CRMD_PS_GEDITEM.ALT_PAY_METHOD == TFK042Z.ZLSCH
  • CRMD_PS_GEDITEM.[column in domain "LAND1"] == TFK042Z.LAND1
  • CRMD_PS_GEDITEM.MANDT == TFK042Z.MANDT
Benefit Beneficiary Number
  • Benefit Beneficiary Number
  • Client
  • CRMD_PS_GEDITEM.BENE_BENEFI_NO == BUT000.PARTNER
  • CRMD_PS_GEDITEM.MANDT == BUT000.CLIENT
Currency Key
  • CRMD_PS_GEDITEM.MANDT == TCURC.MANDT
  • CRMD_PS_GEDITEM.CURRENCY == TCURC.WAERS
Deduction Type
Due Date Rule
  • Due Date Rule
  • ?
Payment Family
  • Payment Family
  • Client
Entitlement Frequency Type
  • ?
  • Entitlement Frequency Type
Client CRMD_PS_GEDITEM.MANDT == T000.MANDT
Payment Recipient Number
  • Payment Recipient Number
  • Client
  • CRMD_PS_GEDITEM.PAYM_RECIPI_NO == BUT000.PARTNER
  • CRMD_PS_GEDITEM.MANDT == BUT000.CLIENT