CRMS4_PSSP_I_SEARCH

Social Service Plan Item | view: CRMS4_PSSPISRCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_PSSP_I, BUT000
Column Name Description
object_type FK Business Trans. Cat.
object_id Transaction ID
number_int Shortened Item Number in Document
Column Name Description
💲 Currency Key (currency):
amount Amount
Column Name Description
Column Name Description
header_valid_from null
header_valid_to null
valid_from null
valid_to null
old_valid_to null
Column Name Description
itm_usage Usage of Higher-Level Item Show values
product_kind Product Technical Type Show values
revacc_relevant_type Revenue Accounting Type Show values
release_status Social Service Plan Item: Release Status Show values
entitlement_status Social Service Plan Item: Status 'Entitled' Show values
creation_status Social Service Plan Item: Creation Status Show values
release_mode Social Service Plan Item: Entitlement Release Mode Show values
is_reduction Social Service Plan Item: Reduction Status Show values
stat_released Release Status Show values
STAT_ACTIVATION Activation Status Show values
STAT_APPROVAL Approval Status Show values
stat_lifecycle Life Cycle Status Show values
Column Name Description Domain name
item_guid GUID of a CRM Order Object SYSUUID
created_at_i Created At (Output in User Time Zone) COM_TSTMP
created_by_i User that Created the Transaction UNAME
changed_at_i Changed At (Output in User Time Zone) COM_TSTMP
changed_by_i Transaction Last Changed By UNAME
objtype_i CRM Item Object Type CRM_OJ_NAME_PROCESS_ITEM
header_guid GUID of a CRM Order Object SYSUUID
parent GUID of a CRM Order Object SYSUUID
alternative GUID of a CRM Order Object SYSUUID
product Internal Unique ID of Product SYSUUID
product_id Product Name Entered CRM_ORDERED_PROD
benefit Product Name Entered CRM_ORDERED_PROD
partner_prod Product Number of Business Partner PRSHTEXT40
description Product Description CRM_PRSHTEXT40_DB
description_uc null
itm_language Short Text Language for an Item SYLANGU
number_ext External Item Number
item_type Item Category CRM_ITEM_TYPE
order_date Posting Date BCOS_TSTMP
itm_type_usage Item Category Usage CRM_IT_TYPE_USAGE
revacc_refid Revenue Accounting Reference ID
revacc_reftype Revenue Accounting Reference Type
process_type Business Transaction Type CRM_PROCESS_TYPE
header_valid_from_tstmp Contract Start Date BCOS_TSTMP
header_valid_to_tstmp Contract End Date BCOS_TSTMP
item_no_appt Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_partner Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_qualif Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_refobj Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_subject Shortened Item Number in Document CRMS4_NUMBER_INT
item_no_survey Shortened Item Number in Document CRMS4_NUMBER_INT
valid_from_tstmp Contract Start Date BCOS_TSTMP
valid_to_tstmp Contract End Date BCOS_TSTMP
old_valid_to_tstmp Previous Contract End Date BCOS_TSTMP
beneficiary Beneficiary BU_PARTNER
beneficiary_guid Business Partner GUID SYSUUID
beneficiary_firstname Search Help Field 2 (Name 2/First Name) CHAR35
beneficiary_lastname Search Help Field 1 (Name 1/Last Name) CHAR35
BENEFICIARY_LIST null
paym_recipient Payment Recipient BU_PARTNER
paym_recipient_guid Business Partner GUID SYSUUID
paym_recipient_firstname Search Help Field 2 (Name 2/First Name) CHAR35
paym_recipient_lastname Search Help Field 1 (Name 1/Last Name) CHAR35
PAYM_RECIPIENT_LIST null
alt_payee Alternative Payee BU_PARTNER
alt_payee_guid Business Partner GUID SYSUUID
alt_payee_firstname Search Help Field 2 (Name 2/First Name) CHAR35
alt_payee_lastname Search Help Field 1 (Name 1/Last Name) CHAR35
ALT_PAYEE_LIST null
sold_to_party Main Partner BU_PARTNER
sold_to_party_firstname Search Help Field 2 (Name 2/First Name) CHAR35
sold_to_party_lastname Search Help Field 1 (Name 1/Last Name) CHAR35
SOLD_TO_PARTY_LIST null
predecessor_item_guid GUID of a CRM Order Object SYSUUID
decision_unit_partner_id Business Partner ID BU_PARTNER
decision_unit_add_key Decision Unit Additional Attribute CRM_PS_SCOPE_ADDITIONAL_KEY
paym_recipient_method Payment Method for Outgoing Payments CHAR5
paym_payment_address_id Payment Address GUID SYSUUID
paym_payment_bank_id Payment Bank ID CHAR4
paym_payment_country Company Country/Region LAND1
alt_payee_payment_method Payment Method for Outgoing Payments CHAR5
alt_payee_address_id Payment Address GUID SYSUUID
alt_payee_bank_id Alternate Payment Bank ID CHAR4
alt_payee_country Company Country/Region LAND1
entitlement_frequency Frequency Type BSPERIOD_FRQ_TYPE
ddr_rp Due Date Rule BSPERIOD_DDR_TYPE
ddr_op Due Date Rule BSPERIOD_DDR_TYPE
ddr_up Due Date Rule BSPERIOD_DDR_TYPE
red_ref_guid GUID of a CRM Order Object SYSUUID
red_ref_product Product Name Entered CRM_ORDERED_PROD
release_status_desc Short Text for Fixed Values DDTEXT
entitlement_status_desc Short Text for Fixed Values DDTEXT
creation_status_desc Short Text for Fixed Values DDTEXT
release_mode_desc Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Business Trans. Cat. CRMS4_PSSP_I_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY