SAP Table CACS_S_CRM_SALES_ORDER_CONTRA

Additional CRM Fields (Construction) From Sales Order Area

CACS_S_CRM_SALES_ORDER_CONTRA (Additional CRM Fields (Construction) From Sales Order Area) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link CACS_S_CRM_SALES_ORDER_CONTRA to other SAP tables.

Source: CACS_S_CRM_SALES_ORDER_CONTRA (Additional CRM Fields (Construction) From Sales Order Area)

CACS_S_CRM_SALES_ORDER_CONTRA table fields

Field		Data element	Datatype	Length	Decimals
CLIENT	Client	MANDT	CLNT	3	0
GUID	Transaction GUID	CACS_CRM_PROZESS_GUID_32	CHAR	32	0
OBJECT_ID	Transaction Number	CACS_CRM_OBJECT_ID	CHAR	10	0
PROCESS_TYPE	Business Transaction Type	CACS_CRM_PROCESS_TYPE	CHAR	4	0
POSTING_DATE	Posting Date of Business Transaction	CACS_CRM_POSTING_DATE	DATS	8	0
LOGICAL_SYSTEM	Logical System	CACS_CRM_LOGSYS	CHAR	10	0
OBJECT_TYPE	Business Transaction Category	CACS_CRM_SUBOBJECT_CATEGORY	CHAR	10	0
ITEM_GUID	Transaction GUID	CACS_CRM_PROZESS_GUID_32	CHAR	32	0
ORDER_DATE	Posting Date	CACS_CRM_OPPT_ORDER_DATE	DATS	8	0
NUMBER_INT	Document Item Number	CACS_CRM_ITEM_NO	NUMC	10	0
ITEM_OBJECT_TYPE	Object Type in CRM Posting Item	CACS_CRM_SWO_OBJTYP_PROCESS_IT	CHAR	10	0
ITM_TYPE	Posting Item Category	CACS_CRM_ITEM_TYPE	CHAR	4	0
SOLD_TO_PARTY	Customer	CACS_CRM_SOLD_TO_PART	CHAR	10	0
SALES_ORG_RESP	Object ID	OBJEKTID	NUMC	8	0
SALES_ORG	Object ID	OBJEKTID	NUMC	8	0
SALES_OFFICE	Object ID	OBJEKTID	NUMC	8	0
SALES_GROUP	Object ID	OBJEKTID	NUMC	8	0
DIS_CHANNEL	Distribution Channel	CACS_CRM_DISTRIBUTION_CHANNEL	CHAR	2	0
DIVISION	Unit	CACS_CRM_DIVISION	CHAR	2	0
CUST_GROUP1	Customer group 1	CACS_CRM_CUST_GROUP1	CHAR	3	0
CUST_GROUP2	Customer group 2	CACS_CRM_CUST_GROUP2	CHAR	3	0
CUST_GROUP3	Customer group 3	CACS_CRM_CUST_GROUP3	CHAR	3	0
CUST_GROUP4	Customer group 4	CACS_CRM_CUST_GROUP4	CHAR	3	0
CUST_GROUP5	Customer group 5	CACS_CRM_CUST_GROUP5	CHAR	3	0
INDUSTRY	Industry Sector	CACS_CRM_INDUSTRY	CHAR	4	0
PCAT_HDR_ID	Product - Catalog Number	CACS_COM_PCAT_ID	CHAR	30	0
PCAT_VRT_ID	Catalog Variant Number	CACS_COM_PCAT_VRT_ID	CHAR	30	0
PCAT_CTY_ID	Catalog - Sales Territory Number	CACS_COM_PCAT_CTY_ID	CHAR	30	0
PRODUCT_ID	Product ID	CACS_COM_PRODUCT_ID	CHAR	40	0
CATEGORY_ID	Category ID	CACS_COM_CATEGORY_ID	CHAR	20	0
CATALOG_ID	Selected Catalog ID	CACS__CATALOG	CHAR	20	0
PROCESS_QTY_UNIT	Sales Unit	CACS_CRM_PROCESS_QTY_UNIT	UNIT	3	0
PROD_PR_GROUP	Product Group	CACS_CRM_PROD_PR_GROUP	CHAR	2	0
PRC_GROUP1	Product Group 1	CACS_CRM_PRC_GROUP1	CHAR	3	0
PRC_GROUP2	Product Group 2	CACS_CRM_PRC_GROUP2	CHAR	3	0
PRC_GROUP3	Product Group 3	CACS_CRM_PRC_GROUP3	CHAR	3	0
PRC_GROUP4	Product Group 4	CACS_CRM_PRC_GROUP4	CHAR	3	0
PRC_GROUP5	Product Group 5	CACS_CRM_PRC_GROUP5	CHAR	3	0
CURRENCY	Currency	CACS_CRM_CURRENCY	CUKY	5	0
TARGET_VALUE	Invoice Amount for a Contract	CACS_CRM_TARGET_VALUE	CURR	19	2
NET_VALUE	Net Value of Total Contract	CACS_CRM_NET_VALUE	CURR	15	2
SUBTOTAL1	Subtotal 1	CACS_CRM_SUBTOTAL1	CURR	15	2
SUBTOTAL2	Subtotal 2	CACS_CRM_SUBTOTAL2	CURR	15	2
SUBTOTAL3	Subtotal 3	CACS_CRM_SUBTOTAL3	CURR	15	2
SUBTOTAL4	Subtotal 4	CACS_CRM_SUBTOTAL4	CURR	15	2
SUBTOTAL5	Subtotal 5	CACS_CRM_SUBTOTAL5	CURR	15	2
SUBTOTAL6	Subtotal 6	CACS_CRM_SUBTOTAL6	CURR	15	2
CREDIT_INDICATOR	Credit/Debit Indicator	CACS_CRM_CREDIT_INDICATOR	CHAR	1	0
GROSS_VALUE	Total Contract Value	CACS_CRM_GROSS_VALUE	CURR	15	2
CALL_OF_QTY_CUM	Quantity Call from Contract	CACS_CRM_CALL_OF_QTY_CUM	QUAN	15	3
CALL_OF_UNIT_CUM	Unit of Measure Called Up	CACS_CRM_CALL_OF_QTY_UNIT_CUM	UNIT	3	0
CALL_OF_VAL_CUM	Value Calledd from Contract	CACS_CRM_CALL_OF_VALUE_CUM	CURR	19	2
TARGET_QUAN_CUM	Total Target Quantity	CACS_CRM_TARGET_QUAN_CUM	QUAN	13	3
TGT_QTY_UNIT_CUM	Target Quantity Unit	CACS_CRM_TARGET_QTY_UNIT_CUM	UNIT	3	0
DELIVERY_QTY_CUM	Delivery Quantity of the Article	CACS_CRM_DELIVERED_QTY_CUM	QUAN	15	3
INVOICED_QTY_CUM	Invoiced Quantity of Article	CACS_CRM_INVOICED_QTY_CUM	QUAN	15	3
DELIVERY_VAL_CUM	Delivery Value of the Article	CACS_CRM_DELIVERED_VAL_CUM	CURR	15	2
INVOICED_VAL_CUM	Invoice Value of Article	CACS_CRM_INVOICED_VAL_CUM	CURR	15	2
ORDER_QTY	Purchase Order Quantity	CACS_CRM_QTY_ORDER	QUAN	13	3
CONFIRMED_QTY	Complete Quantity	CACS_CRM_QTY_CONFIRMED	QUAN	13	3
COMM_TRI_DATE	Date of Commission Run Start	CACS_CRM_COMMISS_TRIGGER_DATE	DATS	8	0
COMM_TRI_STATUS	Start Type for Commission (Posted, Delievered etc.)	CACS_CRM_COMMISS_TRIGGER_TYPE	CHAR	2	0
COMM_BAS_VAL	Commission Basis Value	CACS_CRM_COMMBAS_VALUE_CUM	CURR	15	2
COMM_BASIS_TYPE	Commission Value Basis Type	CACS_CRM_COMMISS_BASIS_VAL_TYP	CHAR	2	0
CRMDUMMY	Dummy function in length 1	DUMMY	CHAR	1	0
INCENTIVE_BAS	Bonus Basis Value	INCENTIVE_BASIS_VALUE_CUM	CURR	15	2