SAP ABAP Table DIAN_C_FORMATS (Maintain DIAN formats configuration)

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_C_FORMATS	Table Relationship Diagram
Short Description	Maintain DIAN formats configuration

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	DIAN_YEAR	☑	AJAHR	GJAHR	NUMC	4	0	Year
3	DIAN_FORMAT	☑	DIAN_D_FORMAT		NUMC	4	0	DIAN Format	DIAN_SY_FORMATS
4	VERSION	☐	DIAN_D_FORMAT_VERSION		NUMC	5	0	DIAN Format Version	DIAN_SY_FORMATS
5	EXCHANGE_RATE_TYPE	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
6	DIAN_ID_TYPE	☐	DIAN_D_ID_TYPE	DIAN_D_ID_TYPE	CHAR	2	0	DIAN ID Type for minimum Amount
7	MIN_AMOUNT	☐	DIAN_D_MIN_AMOUNT	DIAN_D_AMOUNT	CURR	22	2	DIAN minimum amount
8	NIT_MIN_ACCOUNT	☐	DIAN_D_MIN_ACCOUNT		CHAR	20	0	NIT Minimun Account
9	NAME_MIN_AMOUNT	☐	DIAN_D_NAME_MIN_AMOUNT	CHAR60	CHAR	60	0	Name Minimum Amount
10	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	DIAN_C_FORMATS	DIAN_FORMAT	DIAN_SY_FORMATS	DIAN_FORMAT	KEY	1	N
2	DIAN_C_FORMATS	EXCHANGE_RATE_TYPE	TCURV	KURST
3	DIAN_C_FORMATS	VERSION	DIAN_SY_FORMATS	VERSION	KEY	1	CN
4	DIAN_C_FORMATS	WAERS	TCURC	WAERS

History

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