CRMS4D_MAGR_I

Items of Master Agreement | #transactional | Component: S4CRM: Subscription Order Management
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
POSTING_DATE Posting Date for a Business Transaction
Column Name Description
PRODUCT_KIND Product Technical Type Show values
SALES_ORG_ORI Origin Indicator: Sales Organization Show values
DIS_CHANNEL_ORI Origin Indicator: Distribution Channel Show values
DIVISION_ORI Origin Flag: Division 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
SERVICE_ORG_ORI Origin Indicator: Service Organization Show values
SERVICE_ORGR_ORI Origin Indicator: Service Scenario Organizational Unit Show values
STAT_RELEASED Release Status Show values
STAT_CANCELLED Cancellation Status Show values
STAT_LIFECYCLE Life Cycle Status Show values
STAT_ARCHIVABLE Archivable Show values
STAT_ARCHIVED Archived Show values
EXIST_VCKEY Indicator Variant Key Available for Item Show values
ROOT_CONFIG Root Configuration Indicator Show values
FIX_CONFIG Indicator for Fixing Product Configuration Show values
IS_BUN_COMP Indicator for identifying bundle component Show values
Column Name Description Domain name
ITEM_GUID GUID of a CRM Order Object SYSUUID
CREATED_AT_I Created At TZNTSTMPS
CREATED_BY_I User that Created the Transaction UNAME
CHANGED_AT_I Changed At TZNTSTMPS
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
PRODUCT Internal Unique ID of Product SYSUUID
ORDERED_PROD Product Name Entered CRM_ORDERED_PROD
DESCRIPTION_I Product Description CRM_PRSHTEXT40_DB
ITM_LANGUAGE Short Text Language for an Item SYLANGU
ITM_TYPE Item Category CRM_ITEM_TYPE
ORDER_DATE Posting Date BCOS_TSTMP
PRODUCT_ID Product Number MATNR
ITEM_GUID_CHAR 32 Character CRM Object GUID (Converted)
DESCRIPTION_H Transaction Description CRM_PROCESS_DESCRIPTION
CREATED_AT_H Created At (Output in User Time Zone) COM_TSTMP
CREATED_BY_H User that Created the Transaction UNAME
CHANGED_AT_H Changed At (Output in User Time Zone) COM_TSTMP
CHANGED_BY_H Transaction Last Changed By UNAME
AC_OBJECT_TYPE Object Type for Settlement Account Assignment CRMT_OBJECT_TYPE
AC_ASSIGNMENT Settlement Account Assignment CRMT_AC_ASSIGN
AC_PERCENTAGE Percentage of Costs to Be Distributed DEC3_2
CONTSTART Contract Start date DEC15
CONTEND Contract End Date DEC15
SALES_ORG Sales Organization ID HROBJEC_14
DIS_CHANNEL Distribution Channel VTWEG
DIVISION Division SPART
SALES_OFFICE Sales Office HROBJEC_14
SALES_GROUP Sales Group HROBJEC_14
SALES_ORG_RESP Organizational Unit (Sales) HROBJEC_14
SALES_ORG_SD Sales Organization VKORG
SALES_OFFICE_SD Sales office VKBUR
SALES_GROUP_SD Sales group VKGRP
SERVICE_ORG Service Organization HROBJEC_14
SERVICE_ORG_RESP Organizational Unit (Service) HROBJEC_14
REJECTION Cancellation Reason Code ABGRU_VA
INT_OBJ_NO Configuration (Internal Object Number) IB_INSTANCE
PRODUCT_ID_MA Custom Specific ID for Product or Product Range CRMT_ISX_PRVMA_PROD_ID
CTR_CHANGE_ITEM_GUID GUID of a CRM Order Object SYSUUID
CCM_VERSION Version CRM_IST_CCM_VERSION
BILLCYCLE Billing Cycle CYCLE_KK
BCDETRULE Billing Cycle Determination Rule ID CRMD_ISX_BC_RULE_ID
PARTNER_RULE Partner Validation Rule for Master Agreement CRMT_ISX_PARTNER_RULE
SHARING_GROUP_ID Sharing Group ID CRMS4_SOM_SHARING_GROUP_ID
PAYER Payer 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
MAGR_I_DUMMY_PS Single-Character Flag CHAR1
Master Data Relations Join Conditions
Client CRMS4D_MAGR_I.CLIENT == T000.MANDT
Language Key of Description CRMS4D_MAGR_I.DESCR_LANGUAGE == T002.SPRAS
Business Trans. Cat. CRMS4D_MAGR_I.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Business Transaction Type