CRMS4D_PREQ_I

Payment Request Item | #transactional | Component: S4CRM: Social Service Plan
Column Name Description
CLIENT FK Client
OBJTYPE_H FK Business Trans. Cat.
OBJECT_ID Transaction ID
NUMBER_INT Shortened Item Number in Document
Column Name Description
Column Name Description
Column Name Description
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
STAT_LIFECYCLE Life Cycle Status Show values
STAT_RELEASED Release Status Show values
STAT_APPROVAL_H Approval Status Show values
SERVICE_ORG_ORI Origin Indicator: Service Organization Show values
SERVICE_ORGR_ORI Origin Indicator: Service Scenario Organizational Unit Show values
SALES_ORG_ORI Origin Indicator: Sales Organization Show values
DIS_CHANNEL_ORI Origin Indicator: Distribution Channel Show values
SALES_OFF_ORI Origin Indicator: Sales Office Show values
SALES_GROUP_ORI Origin Indicator: Sales Group Show values
SALES_ORGR_ORI Origin Indicator: Sales Scenario Organizational Unit Show values
DIVISION_ORI Origin Flag: Division 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_I Product Description CRM_PRSHTEXT40_DB
ITM_LANGUAGE Short Text Language for an Item SYLANGU
NUMBER_EXT External Item Number
ITM_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
PRODUCT_ID Product Number MATNR
ITEM_GUID_CHAR 32 Character CRM Object GUID (Converted)
PROCESS_TYPE Business Transaction Type CRM_PROCESS_TYPE
CONTSTART_H Contract Start Date BCOS_TSTMP
CONTEND_H Contract End Date BCOS_TSTMP
PERSON_RESP Employee Responsible BU_PARTNER
APPLICANT Applicant BU_PARTNER
APPROVED_BY Approved By BU_PARTNER
REJECTED_BY Rejected By 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
ITEM_NO_BILLPLAN Shortened Item Number in Document CRMS4_NUMBER_INT
ITEM_NO_PAYPLAN Shortened Item Number in Document CRMS4_NUMBER_INT
CONTSTART_I Contract Start Date BCOS_TSTMP
CONTEND_I Contract End Date BCOS_TSTMP
SALES_ORG Sales Organization ID HROBJEC_14
SALES_OFFICE Sales Office HROBJEC_14
SALES_GROUP Sales Group HROBJEC_14
SALES_ORG_RESP Organizational Unit (Sales) HROBJEC_14
SERVICE_ORG Service Organization HROBJEC_14
SERVICE_ORG_RESP Organizational Unit (Service) HROBJEC_14
SALES_ORG_SD Sales Organization VKORG
SALES_OFFICE_SD Sales office VKBUR
SALES_GROUP_SD Sales group VKGRP
BENEFICIARY Beneficiary BU_PARTNER
PAYMENT_RECIPIENT Payment Recipient BU_PARTNER
PREQ_I_DUMMY_PS Single-Character Flag CHAR1
PARTNER_ID Business Partner ID BU_PARTNER
ADDITIONAL_KEY Decision Unit Additional Attribute CRM_PS_SCOPE_ADDITIONAL_KEY
Master Data Relations Join Conditions
Client CRMS4D_PREQ_I.CLIENT == T000.MANDT
Distribution Channel
  • Distribution Channel
  • Client
  • CRMS4D_PREQ_I.DIS_CHANNEL == TVTW.VTWEG
  • CRMS4D_PREQ_I.CLIENT == TVTW.MANDT
Division
  • CRMS4D_PREQ_I.CLIENT == TSPA.MANDT
  • CRMS4D_PREQ_I.DIVISION == TSPA.SPART
Business Trans. Cat. CRMS4D_PREQ_I.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY