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: adr2¶

Generated: 2025-11-26 21:26:48.290724 Schema: raw.adr2 Total Rows: 548,060 Columns: 18 Completeness: 100.00%

Source Files¶

File	Rows	Size
20251105001801_adr2_6120.csv	548,060	121.8 MB
Total	548,060	121.8 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	COUNTRY	string	VARCHAR(4)	No	0.00%	0
7	FLGDEFAULT	string	VARCHAR(1)	No	0.00%	0
8	FLG_NOUSE	string	VARCHAR(1)	No	0.00%	0
9	HOME_FLAG	string	VARCHAR(1)	No	0.00%	0
10	TEL_NUMBER	string	VARCHAR(45)	No	0.00%	0
11	TEL_EXTENS	string	VARCHAR(15)	No	0.00%	0
12	TELNR_LONG	string	VARCHAR(45)	No	0.00%	0
13	TELNR_CALL	string	VARCHAR(45)	No	0.00%	0
14	DFT_RECEIV	string	VARCHAR(1)	No	0.00%	0
15	R3_USER	string	VARCHAR(1)	No	0.00%	0
16	VALID_FROM	string	VARCHAR(21)	No	0.00%	0
17	VALID_TO	string	VARCHAR(21)	No	0.00%	0
18	_DATAAGING	string	VARCHAR(12)	No	0.00%	0

Detailed Column Profiles¶

1. CLIENT¶

Type: integer → INTEGER
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060 - Range: 100 to 100 - Type Conversion: 100.0% success (548060/548060)

Sample Values:

100, 100, 100, 100, 100

2. ADDRNUMBER¶

Type: string → VARCHAR(15)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

0000562058, 0000562196, 0000562200, 0000562219, 0000562220

3. PERSNUMBER¶

Type: string → VARCHAR(15)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

          ,           ,           ,           ,

4. DATE_FROM¶

Type: string → VARCHAR(12)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

00010101, 00010101, 00010101, 00010101, 00010101

5. CONSNUMBER¶

Type: string → VARCHAR(4)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

001, 001, 001, 001, 001

6. COUNTRY¶

Type: string → VARCHAR(4)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

CH , CH , CH , CH , CH

7. FLGDEFAULT¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

X, X, X, X, X

8. FLG_NOUSE¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

 ,  ,  ,  ,

9. HOME_FLAG¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

X, X, X, X, X

10. TEL_NUMBER¶

Type: string → VARCHAR(45)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	30
Avg Length	0.0
Buffered Length	45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

043 317 22 22                 , 043 317 22 22                 , 043 317 22 22                 , 043 317 22 22                 , 043 317 22 22

11. TEL_EXTENS¶

Type: string → VARCHAR(15)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

          ,           ,           ,           ,

12. TELNR_LONG¶

Type: string → VARCHAR(45)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	30
Avg Length	0.0
Buffered Length	45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

                              ,                               ,                               ,                               ,

13. TELNR_CALL¶

Type: string → VARCHAR(45)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (100.0%)
Unique	0 (0.0%)
Min Length	0
Max Length	30
Avg Length	0.0
Buffered Length	45 (50% buffer)

Type Inference: - Confidence: 100% - Rows Analyzed: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

0433172222                    , 0433172222                    , 0433172222                    , 0433172222                    , 0433172222

14. DFT_RECEIV¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

 ,  ,  ,  ,

15. R3_USER¶

Type: string → VARCHAR(1)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

 ,  ,  ,  ,

16. VALID_FROM¶

Type: string → VARCHAR(21)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

              ,               ,               ,               ,

17. VALID_TO¶

Type: string → VARCHAR(21)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

              ,               ,               ,               ,

18. _DATAAGING¶

Type: string → VARCHAR(12)
Nullable: No

Metric	Value
Total Rows	548,060
Non-null	548,060 (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: 548,060 - Parse Success: 548,060 / 548,060

Sample Values:

00000000, 00000000, 00000000, 00000000, 00000000

PostgreSQL DDL¶

See adr2_schema.sql

Generated by duckdb-profiler v0.1.0