Skip to content

SAP Data Profiles & Relationships

Home
Getting Started
Source Profiles
Source Profiles
- Source Table Profiles
Marts
Marts
- Mart Profiles
Relationships
Relationships
- Table Relationships
Dependencies & Build Order
Dependencies & Build Order
Data Quality
Data Quality
- Data Quality
- Record Counts
Domains
Domains
- Domain Groupings

Data Profile: adr6¶

Generated: 2025-11-26 21:27:17.589940 Schema: raw.adr6 Total Rows: 275,751 Columns: 17 Completeness: 100.00%

Source Files¶

File	Rows	Size
20251105001841_adr6_6120.csv	275,751	102.6 MB
Total	275,751	102.6 MB

Column Summary¶

#	Column	Type	PostgreSQL	Nullable	Nulls	Unique
1	CLIENT	integer	INTEGER	No	0.00%	0
2	ADDRNUMBER	string	VARCHAR(15)	No	0.00%	0
3	PERSNUMBER	string	VARCHAR(15)	No	0.00%	0
4	DATE_FROM	string	VARCHAR(12)	No	0.00%	0
5	CONSNUMBER	string	VARCHAR(4)	No	0.00%	0
6	FLGDEFAULT	string	VARCHAR(1)	No	0.00%	0
7	FLG_NOUSE	string	VARCHAR(1)	No	0.00%	0
8	HOME_FLAG	string	VARCHAR(1)	No	0.00%	0
9	SMTP_ADDR	string	VARCHAR(361)	Yes	0.00%	0
10	SMTP_SRCH	string	VARCHAR(360)	No	0.00%	0
11	DFT_RECEIV	string	VARCHAR(1)	Yes	0.00%	0
12	R3_USER	string	VARCHAR(28)	No	0.00%	0
13	ENCODE	string	VARCHAR(1)	No	0.00%	0
14	TNEF	string	VARCHAR(1)	No	0.00%	0
15	VALID_FROM	string	VARCHAR(21)	No	0.00%	0
16	VALID_TO	string	VARCHAR(21)	No	0.00%	0
17	_DATAAGING	string	VARCHAR(21)	No	0.00%	0

Detailed Column Profiles¶

1. CLIENT¶

Type: integer → INTEGER
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	20
Avg Length	0.0
Buffered Length	30 (50% buffer)
Min	100.0
Max	100.0
Mean	0.00
Median	0.00
Std Dev	0.00
Decimal Places	0

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751 - Range: 100 to 100 - Type Conversion: 100.0% success (239562/239562)

Sample Values:

100, 100, 100, 100, 100

2. ADDRNUMBER¶

Type: string → VARCHAR(15)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	10
Avg Length	0.0
Buffered Length	15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

0000994655, 0000974364, 0000977148, 0000977149, 0000974706

3. PERSNUMBER¶

Type: string → VARCHAR(15)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	10
Avg Length	0.0
Buffered Length	15 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

          ,           ,           ,           ,

4. DATE_FROM¶

Type: string → VARCHAR(12)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	8
Avg Length	0.0
Buffered Length	12 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

00010101, 00010101, 00010101, 00010101, 00010101

5. CONSNUMBER¶

Type: string → VARCHAR(4)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	3
Avg Length	0.0
Buffered Length	4 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

001, 001, 001, 001, 001

6. FLGDEFAULT¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	1
Avg Length	0.0
Buffered Length	1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

X, X, X, X, X

7. FLG_NOUSE¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	1
Avg Length	0.0
Buffered Length	1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

 ,  ,  ,  ,

8. HOME_FLAG¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	1
Avg Length	0.0
Buffered Length	1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

X, X, X, X, X

9. SMTP_ADDR¶

Type: string → VARCHAR(361)
Nullable: Yes

Metric	Value
Total Rows	275,751
Non-null	275,748 (100.0%)
Null	3 (0.00%)
Unique	0 (0.0%)
Min Length	0
Max Length	241
Avg Length	0.0
Buffered Length	361 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

[email protected]                                                                                                                                                                                                                              , [email protected]                                                                                                                                                                                                                              , [email protected]                                                                                                                                                                                                                              , [email protected]                                                                                                                                                                                                                              , [email protected]

10. SMTP_SRCH¶

Type: string → VARCHAR(360)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	240
Avg Length	0.0
Buffered Length	360 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

[email protected] , [email protected] , [email protected] , [email protected] , [email protected]

11. DFT_RECEIV¶

Type: string → VARCHAR(1)
Nullable: Yes

Metric	Value
Total Rows	275,751
Non-null	275,748 (100.0%)
Null	3 (0.00%)
Unique	0 (0.0%)
Min Length	0
Max Length	1
Avg Length	0.0
Buffered Length	1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

 ,  ,  ,  ,

12. R3_USER¶

Type: string → VARCHAR(28)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	19
Avg Length	0.0
Buffered Length	28 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

 ,  ,  ,  ,

13. ENCODE¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	1
Avg Length	0.0
Buffered Length	1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

 ,  ,  ,  ,

14. TNEF¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	1
Avg Length	0.0
Buffered Length	1 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

 ,  ,  ,  ,

15. VALID_FROM¶

Type: string → VARCHAR(21)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	14
Avg Length	0.0
Buffered Length	21 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

              ,               ,               ,               ,

16. VALID_TO¶

Type: string → VARCHAR(21)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	14
Avg Length	0.0
Buffered Length	21 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

              ,               ,               ,               ,

17. _DATAAGING¶

Type: string → VARCHAR(21)
Nullable: No

Metric	Value
Total Rows	275,751
Non-null	275,751 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	14
Avg Length	0.0
Buffered Length	21 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 275,751 - Parse Success: 275,751 / 275,751

Sample Values:

00000000, 00000000, 00000000, 00000000, 00000000

PostgreSQL DDL¶

See adr6_schema.sql

Generated by duckdb-profiler v0.1.0