SAP ABAP Table SDCUSTVIEW1_O2C (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SDCUSTVIEW1_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	DATE_FROM	☑	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
4	NATION	☑	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	TSADV
5	MCOD1	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
6	MCOD2	☐	MCDD2	CHAR25	CHAR	25	0	Search Term for Matchcode Search
7	MCOD3	☐	MCDD3	CHAR25	CHAR	25	0	Search term for matchcode search
8	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
9	NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
10	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
11	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
12	MC_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
13	STREET_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
14	PCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
15	CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
16	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	T005
17	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
18	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
19	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
20	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group
21	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	T077D
22	KUKLA	☐	KUKLA	KUKLA	CHAR	2	0	Customer classification	TKUKL
23	AUFSDZ	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	TVAST
24	LIFSDZ	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	TVLS
25	FAKSDZ	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	TVFS
26	LOEVMZ	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
27	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	SDCUSTVIEW1_O2C	AUFSDZ	TVAST	AUFSP	REF	C	CN
2	SDCUSTVIEW1_O2C	COUNTRY	T005	LAND1	REF	C	CN
3	SDCUSTVIEW1_O2C	FAKSDZ	TVFS	FAKSP	REF	C	CN
4	SDCUSTVIEW1_O2C	KTOKD	T077D	KTOKD	REF	1	CN
5	SDCUSTVIEW1_O2C	KUKLA	TKUKL	KUKLA	REF	C	CN
6	SDCUSTVIEW1_O2C	LIFSDZ	TVLS	LIFSP	REF	C	CN
7	SDCUSTVIEW1_O2C	MANDT	T000	MANDT	KEY	1	CN
8	SDCUSTVIEW1_O2C	NATION	TSADV	NATION	KEY	1	CN
9	SDCUSTVIEW1_O2C	REGION	T005S	BLAND	REF	C	CN

History

Last changed by/on	SAP	20140121
SAP Release Created in