SAP ABAP Table /BEV1/CLDEB_S (Recording of 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	INTTAB	Structure
Structure	/BEV1/CLDEB_S	Table Relationship Diagram
Short Description	Recording of Customer Information

Delivery and Maintenance

Pool/cluster
Delivery Class
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	/BEV1/CLDEB
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	T005
15	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
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	/BEV1/CLHAF
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	/BEV1/CLT900
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	/BEV1/CLT902
35	NACHL	☐	/BEV1/CLNACHL	/BEV1/CLNACHL	CHAR	4	0	Follow-Up Code	/BEV1/CLT901
36	JA	☐	/BEV1/CLSOND	CHAR1	CHAR	1	0	Checkbox: Special Packaging Required
37	GRENZE	☐	/BEV1/CLGRENZE	/BEV1/CLGRENZE	CHAR	2	0	Offices of Transit	/BEV1/CLT998
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_S	CODE	/BEV1/CLHAF	CODE
2	/BEV1/CLDEB_S	DOOR	/BEV1/CLT900	DOOR		C	CN
3	/BEV1/CLDEB_S	ERGEI	T006	MSEHI
4	/BEV1/CLDEB_S	GRENZE	/BEV1/CLT998	GRENZE
5	/BEV1/CLDEB_S	KUNNR	/BEV1/CLDEB	KUNNR
6	/BEV1/CLDEB_S	LAND1	T005	LAND1
7	/BEV1/CLDEB_S	MATNR	MARA	MATNR
8	/BEV1/CLDEB_S	NACHL	/BEV1/CLT901	NACHL		C	CN
9	/BEV1/CLDEB_S	REGIO	T005S	BLAND
10	/BEV1/CLDEB_S	SALES	/BEV1/CLT902	SALES		C	CN
11	/BEV1/CLDEB_S	SPRAS	T002	SPRAS

History

Last changed by/on	SAP	20130529
SAP Release Created in