SAP ABAP Table DIAN_A_1007_08 (Cached Data of DIAN Format 1007 version 08)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ ID-DIAN-CO (Package) DIAN: Magnetic Meida for Columbia

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	DIAN_A_1007_08	Table Relationship Diagram
Short Description	Cached Data of DIAN Format 1007 version 08

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	RUN_ID	☑	GUID		RAW	16	0	Globally Unique Identifier
3	LINE_ID	☑	GUID		RAW	16	0	Globally Unique Identifier	DIAN_A_EXTRACT
4	COMPANY_CODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
5	CONCEPT	☐	DIAN_D_CONCEPT		NUMC	4	0	DIAN Concept
6	DOCUMENT_TYPE	☐	DIAN_D_DOC_TYPE	DIAN_D_DOC_TYPE	CHAR	2	0	DIAN Identification Type
7	IDENTIFICATION_NUMBER	☐	DIAN_D_NIT		CHAR	20	0	DIAN Identification number
8	VERIFICATION_DIGIT	☐	DIAN_D_VERIFICATION_DIGIT		NUMC	1	0	DIAN Verification Digit
9	LAST_NAME	☐	DIAN_D_LAST_NAME		CHAR	40	0	Last Name
10	MIDDLE_NAME	☐	DIAN_D_MIDDLE_NAME		CHAR	40	0	DIAN Middle Name
11	NAME	☐	DIAN_D_NAME		CHAR	40	0	DIAN Name
12	OTHER_NAMES	☐	DIAN_D_OTHER_NAMES		CHAR	40	0	Other Name
13	RAZ	☐	DIAN_D_RAZ		CHAR	40	0	Corporate Name
14	COUNTRY	☐	DIAN_D_COUNTRY_KEY	NUMC04	NUMC	4	0	DIAN Residence number
15	IPRO	☐	DIAN_D_OWN_OPERATIONS	DIAN_D_AMOUNT	CURR	22	2	Gross revenues from own operations
16	DEV	☐	DIAN_D_RETURNS	DIAN_D_AMOUNT	CURR	22	2	Returns, rebates and discounts
17	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DIAN_A_1007_08	LINE_ID	DIAN_A_EXTRACT	LINE_ID		1	1

History

Last changed by/on	SAP	20130529
SAP Release Created in	617