SAP ABAP Table CPEC_SD_VALTERM (Area of Validity for Commodity Pricing Term in SD)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-BF-CPE (Application Component) CPE in SD
     ⤷ CPE_SD_CUST_ERP (Package) CPE Customizing for Sales and Distribution

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	CPEC_SD_VALTERM	Table Relationship Diagram
Short Description	Area of Validity for Commodity Pricing Term in SD

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	LOGSYS	☑	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
3	TERMID	☑	CPET_TERMID	CPE_TERMID	CHAR	10	0	CPE Term - Key
4	COND_TYPE	☑	KSCHL	KSCHL	CHAR	4	0	Condition Type	*
5	.INCLUDE	☑				0	0	Area of Validity for Commodity Pricing Parts in SD
6	SALESORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
7	DIS_CHANNEL	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
8	DIVISION	☑	SPART	SPART	CHAR	2	0	Division	TSPA
9	CUST_GROUP	☑	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
10	PRICE_GRP	☑	KONDA	KONDA	CHAR	2	0	Price Group (Customer)	T188
11	PROD_PR_GROUP	☑	KONDM_V	KONDM	CHAR	2	0	Material pricing group	T178

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CPEC_SD_VALTERM	CUST_GROUP	T151	KDGRP		C	CN
2	CPEC_SD_VALTERM	DIS_CHANNEL	TVTW	VTWEG		C	CN
3	CPEC_SD_VALTERM	DIVISION	TSPA	SPART		C	CN
4	CPEC_SD_VALTERM	LOGSYS	TBDLS	LOGSYS
5	CPEC_SD_VALTERM	PRICE_GRP	T188	KONDA		C	CN
6	CPEC_SD_VALTERM	PROD_PR_GROUP	T178	KONDM		C	CN
7	CPEC_SD_VALTERM	SALESORG	TVKO	VKORG		C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	2004_1_470