SAP ABAP Table SDCUSTVIEW_O2C (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SDCUSTVIEW_O2C	Table Relationship Diagram
Short Description	Generated Table for View

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	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KUNNR	☑	KUNNR	KUNNR	CHAR	10	0	Customer Number
3	VKORG	☑	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	VTWEG	☑	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	SPART	☑	SPART	SPART	CHAR	2	0	Division	TSPA
6	DATE_FROM	☑	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
7	NATION	☑	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	TSADV
8	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
9	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVBVK
10	MCOD1	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
11	MCOD2	☐	MCDD2	CHAR25	CHAR	25	0	Search Term for Matchcode Search
12	MCOD3	☐	MCDD3	CHAR25	CHAR	25	0	Search term for matchcode search
13	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
14	NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
15	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
16	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
17	MC_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
18	STREET_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
19	PCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
20	CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
21	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
22	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
23	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
24	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
25	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
26	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
27	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
28	KDGRP	☐	KDGRP	KDGRP	CHAR	2	0	Customer group	T151
29	KLABC	☐	KLABC	KLABC	CHAR	2	0	Customer classification (ABC analysis)
30	AUFSDZ	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
31	AUFSDV	☐	AUFSD_V	KAUFS	CHAR	2	0	Customer order block (sales area)	TVAST
32	LIFSDZ	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
33	LIFSDV	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)	TVLS
34	FAKSDZ	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
35	FAKSDV	☐	FAKSD_V	FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)	TVFS
36	LOEVMZ	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
37	LOEVMV	☐	LOEVM_V	XFELD	CHAR	1	0	Deletion flag for customer (sales level)
38	NODEL	☐	NODEL_X	XFELD	CHAR	1	0	Central deletion block for master record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SDCUSTVIEW_O2C	AUFSDV	TVAST	AUFSP	REF	C	CN
2	SDCUSTVIEW_O2C	AUFSDZ	TVAST	AUFSP	REF	C	CN
3	SDCUSTVIEW_O2C	COUNTRY	T005	LAND1	REF	C	CN
4	SDCUSTVIEW_O2C	FAKSDV	TVFS	FAKSP	REF	C	CN
5	SDCUSTVIEW_O2C	FAKSDZ	TVFS	FAKSP	REF	C	CN
6	SDCUSTVIEW_O2C	KDGRP	T151	KDGRP	REF	C	CN
7	SDCUSTVIEW_O2C	KTOKD	T077D	KTOKD	REF	1	CN
8	SDCUSTVIEW_O2C	KUKLA	TKUKL	KUKLA	REF	C	CN
9	SDCUSTVIEW_O2C	LIFSDV	TVLS	LIFSP	REF	C	CN
10	SDCUSTVIEW_O2C	LIFSDZ	TVLS	LIFSP	REF	C	CN
11	SDCUSTVIEW_O2C	MANDT	T000	MANDT	KEY	1	CN
12	SDCUSTVIEW_O2C	NATION	TSADV	NATION	KEY	1	CN
13	SDCUSTVIEW_O2C	REGION	T005S	BLAND	REF	C	CN
14	SDCUSTVIEW_O2C	SPART	TSPA	SPART	KEY	1	CN
15	SDCUSTVIEW_O2C	VKBUR	TVBUR	VKBUR	REF	C	CN
16	SDCUSTVIEW_O2C	VKGRP	TVBVK	VKGRP	REF	C	CN
17	SDCUSTVIEW_O2C	VKORG	TVKO	VKORG	KEY	1	CN
18	SDCUSTVIEW_O2C	VTWEG	TVTW	VTWEG	KEY	1	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in