CRMS4_PSDP_I_SEARCH

Social Deduction Plan Item | view: CRMS4_PSDPISRCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_PSDP_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 (deduction_currency):
deduction_amount Amount
Column Name Description
Column Name Description
header_valid_from null
header_valid_to null
valid_from null
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
stat_activation_h Activation Status Show values
deduct_partial Partial Deduction Show values
stat_approval Approval Status Show values
stat_activation Activation Status Show values
stat_lifecycle Life Cycle Status Show values
stat_released Release Status Show values
creation_status Social Deduction Plan Item: Creation 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
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
deduct_from Deduct-From Party BU_PARTNER
deduct_to Deduct-To Party BU_PARTNER
sold_to_party Main Partner BU_PARTNER
deduct_from_list null
deduct_to_list null
sold_to_party_list null
predecessor_item_guid GUID of a CRM Order Object SYSUUID
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 PYMET_KK
alt_payee_address_id Alternate Payment Address ID AD_ADDRNUM
alt_payee_bank_id Alternate Payment Bank ID CHAR4
alt_payee_country Company Country/Region LAND1
deduct_pay_fam Payment Family CRM_4S_PMNT_FAM
deduct_percent Deduction Percentage CRMS4_PS_PERCENTAGE
deduct_ddr Due Date Rule BSPERIOD_DDR_TYPE
deduct_priority Priority for Items with the Same Deduction Type CRMS4_PS_NET_DEDUCT_PRIORITY
deduct_pay_frq_type Payment Frequency Type BSPERIOD_FRQ_TYPE
release_status_desc Short Text for Fixed Values DDTEXT
creation_status_desc Short Text for Fixed Values DDTEXT
Master Data Relations Join Conditions
Business Trans. Cat. CRMS4_PSDP_I_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY