CRMS4_PSOA_I_U_SEARCH

Social Application Item Union | view: CRMS4_PSOAIUSRCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_PREQ_I, CRMS4D_PSOA_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
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
header_activation_status Activation 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
ordered_prod 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
header_activation_status_desc Short Text for Fixed Values DDTEXT
sold_to_party Applicant BU_PARTNER
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
beneficiary null
paym_recipient null
Master Data Relations Join Conditions
Business Trans. Cat. CRMS4_PSOA_I_U_SEARCH.OBJECT_TYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY