SAP ABAP Table /BEV1/CLDEB (Customer Information)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ SD-SLS-PLL-OBS (Application Component) Remaining Beverage - Obsolete Objects
     ⤷ /BEV1/CL (Package) Container Logistics - Obsolete Objects

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	/BEV1/CLDEB	Table Relationship Diagram
Short Description	Customer Information

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	/BEV1/CLMANDT	/BEV1/CLMANDT	CLNT	3	0	Client
2	KUNNR	☑	/BEV1/CLKUNNR	/BEV1/CLKUNNR	CHAR	10	0	Customer number
3	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
4	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
5	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
6	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
7	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
8	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
9	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
10	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
11	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
12	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
13	PFORT	☐	PFORT_GP	TEXT35	CHAR	35	0	PO Box city
14	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
15	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
16	STRAS	☐	STRAS	TEXT30	CHAR	30	0	House number and street
17	COTGR	☐	/BEV1/CLCOTGR	/BEV1/CLCOTGR	NUMC	3	0	Container Size
18	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
19	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
20	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
21	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
22	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
23	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
24	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
25	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
26	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
27	CODE	☐	/BEV1/CLCODE	/BEV1/CLCODE	CHAR	4	0	Port Code
28	MAXGE	☐	/BEV1/CLMAXGE	/BEV1/CLMAXGE	DEC	12	3	Maximum Weight for Loading
29	STEUNR	☐	/BEV1/CLSTEUNR	/BEV1/CLSTEUNR	CHAR	20	0	Excise Duty Number
30	KAISCH	☐	/BEV1/CLKAISCH	/BEV1/CLKAISCH	INT1	3	0	Quay Note
31	DOOR	☐	/BEV1/CLDOOR	/BEV1/CLDOOR	CHAR	4	0	Door/Ramp
32	FREIGT	☐	/BEV1/CLFREIGHT	/BEV1/CLFREIGHT	CHAR	40	0	Freight Data
33	PAID	☐	/BEV1/CLPAID	/BEV1/CLPAID	CURR	13	2	Freight amount
34	SALES	☐	/BEV1/CLSALES	/BEV1/CLSALES	CHAR	4	0	Representative
35	NACHL	☐	/BEV1/CLNACHL	/BEV1/CLNACHL	CHAR	4	0	Follow-Up Code
36	JA	☐	/BEV1/CLSOND	CHAR1	CHAR	1	0	Checkbox: Special Packaging Required
37	GRENZE	☐	/BEV1/CLGRENZE	/BEV1/CLGRENZE	CHAR	2	0	Offices of Transit
38	VERPTX	☐	/BEV1/CLVERPTX	/BEV1/CLVERPTX	CHAR	50	0	Text for Special Packaging
39	KUNDE	☐	/BEV1/CLKUNDE	/BEV1/CLKUNDE	CHAR	20	0	Customer's Customer Number
40	ERGEI	☐	ERGEI	MEINS	UNIT	3	0	Unit of weight (allowed packaging weight)	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/BEV1/CLDEB	ERGEI	T006	MSEHI
2	/BEV1/CLDEB	MATNR	MARA	MATNR
3	/BEV1/CLDEB	SPRAS	T002	SPRAS

History

Last changed by/on	SAP	20130529
SAP Release Created in