SAP ABAP Table CIAP_RECORD_DATA (CIAP Record data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ FI-LOC (Application Component) Localization
     ⤷ INT_TMF_CIAP (Package) TMF Integration Features: CIAP

Basic Data

Table Category	INTTAB	Structure
Structure	CIAP_RECORD_DATA	Table Relationship Diagram
Short Description	CIAP Record data

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	RECORD_ID	☐	CIAP_RECORD_ID		RAW	16	0	CIAP Record Unique ID
2	CREATION_DATE	☐	CIAP_CREATION_DATE	DATUM	DATS	8	0	CIAP Creation Date
3	NF_DOCNUM	☐	CIAP_NF_DOCNUM	J_1BDOCNUM	NUMC	10	0	CIAP issuing Nota Fiscal Document Number	*
4	NF_NFNUM	☐	CIAP_NF_NFE_NUMBER	J_1BNFNUM9	CHAR	9	0	CIAP NF or NF-e number
5	NF_SERIES	☐	J_1BSERIES	J_1BSERIES	CHAR	3	0	Series
6	NF_SUBSER	☐	J_1BSUBSER	J_1BSUBSER	CHAR	2	0	Sub series
7	NF_MODEL	☐	J_1BMODEL	J_1BMODEL	NUMC	2	0	Model of Nota Fiscal
8	NF_ITEM	☐	J_1BITMNUM	J_1BITMNUM	NUMC	6	0	Document Item Number
9	NF_ISSUING_DATE	☐	CIAP_NF_ISSUING_DATE	DATUM	DATS	8	0	CIAP Nota Fiscal document date
10	NF_RECEIPT_DATE	☐	CIAP_NF_RECEIPT_DATE	DATUM	DATS	8	0	CIAP Nota Fiscal posting date
11	NF_ORIGINAL_DATE	☐	CIAP_NF_ORIGINAL_DATE	DATUM	DATS	8	0	CIAP Nota Fiscal creation date
12	NF_ITEM_TYPE	☐	J_1BITMTYP	J_1BITMTYP	CHAR	2	0	Nota Fiscal Item Type	*
13	CFOP	☐	J_1BCFOP	J_1BCFOP	CHAR	10	0	CFOP code and extension	*
14	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
15	PARTNER	☐	J_1BPARID	J_1BPARID	CHAR	10	0	Partner ID (Customer, Vendor, Business Place)
16	PARTNER_CNPJ	☐	CIAP_CONVERTED_PARTNER_CNPJ		CHAR	18	0	CIAP Converted format Partner CNPJ
17	PARTNER_NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
18	PARTNER_STATE	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
19	PARTNER_STREET	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
20	PARTNER_HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
21	PARTNER_HOUSE_COMPL	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
22	PARTNER_COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
23	PARTNER_ZIP_CODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
24	PARTNER_CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
25	PARTNER_DISTRICT	☐	ORT02_GP	TEXT35	CHAR	35	0	District
26	PARTNER_STATE_TAX_NUM	☐	J_1BSTAINS	J_1BSTAINS	CHAR	18	0	State Tax Number
27	STATUS	☐	CIAP_RECORD_STATUS	CIAP_RECORD_STATUS	CHAR	2	0	CIAP record status
28	REC_EXTEMP_CREDIT	☐	CIAP_EXTEMP_CREDIT_FLAG	FLAG	CHAR	1	0	CIAP Extemporaneous Credit Flag
29	CTE_NUMBER	☐	CIAP_CTE_DOCNUM	J_1BDOCNUM	NUMC	10	0	CIAP CTe Document Number	*
30	CTE_ISSUING_DATE	☐	CIAP_CTE_ISSUING_DATE	DATUM	DATS	8	0	CIAP CTe document date
31	CTE_RECEIPT_DATE	☐	CIAP_CTE_RECEIPT_DATE	DATUM	DATS	8	0	CIAP CTe posting date
32	ASSET_ID	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
33	ASSET_SUBNUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
34	ASSET_DESCRIPTION	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
35	WBS	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
36	WBS_DESCRIPTION	☐	CIAP_WBS_DESCRIPTION		CHAR	40	0	CIAP WBS Description
37	INTERNAL_ORDER	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
38	INTERNAL_ORDER_DESCRIPTION	☐	BRGKTEXT	TEXT40	CHAR	40	0	Description of settlement rule
39	DEACTIVATION_DATE	☐	DEAKT	DATUM	DATS	8	0	Deactivation date
40	GLACCOUNT	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
41	COST_CENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
42	GOODS_VALUE	☐	CIAP_GOODS_VALUE	CIAP_VALUE	CURR	22	10	CIAP goods value
43	ICMS_BASE	☐	CIAP_ICMS_BASE	CIAP_VALUE	CURR	22	10	CIAP ICMS tax base
44	ICMS	☐	CIAP_ICMS_VALUE	CIAP_VALUE	CURR	22	10	CIAP ICMS Value
45	ICMS_ST	☐	CIAP_SUB_TRIB_VALUE	CIAP_VALUE	CURR	22	10	CIAP "Substituição Tributária" Value
46	ICMS_DIFAL	☐	CIAP_DIFAL_VALUE	CIAP_VALUE	CURR	22	10	CIAP DIFAL Value
47	CTE_ICMS	☐	CIAP_FREIGHT_ICMS_VALUE	CIAP_VALUE	CURR	22	10	CIAP Freight ICMS Value
48	CTE_ICMS_ST	☐	CIAP_FREIGHT_SUB_TRIB_VALUE	CIAP_VALUE	CURR	22	10	CIAP Freight "Substituição Tributária" Value
49	CTE_ICMS_DIFAL	☐	CIAP_FREIGHT_DIFAL_VALUE	CIAP_VALUE	CURR	22	10	CIAP Freight DIFAL Value
50	ICMS_TOTAL	☐	CIAP_ICMS_TOTAL_VALUE	CIAP_VALUE	CURR	22	10	CIAP ICMS Total Value
51	ICMS_TO_CREDIT	☐	CIAP_ICMS_TO_CREDIT	CIAP_VALUE	CURR	22	10	CIAP ICMS to credit value
52	ICMS_NOT_CREDITED	☐	CIAP_ICMS_NOT_CREDITED	CIAP_VALUE	CURR	22	10	CIAP ICMS Not Credited
53	ICMS_CREDITED	☐	CIAP_ICMS_CREDITED	CIAP_VALUE	CURR	22	10	CIAP ICMS credited value
54	QUOTAS_QUANTITY	☐	CIAP_QUOTAS_QUANTITY	CIAP_QUOTA_NUMBER	NUMC	2	0	CIAP Quotas Quantity
55	QUOTAS_CREDITED	☐	CIAP_QUOTAS_CREDITED	CIAP_QUOTA_NUMBER	NUMC	2	0	CIAP Quotas Credited
56	QUOTAS_TO_CREDIT	☐	CIAP_QUOTAS_TO_CREDIT	CIAP_QUOTA_NUMBER	NUMC	2	0	CIAP Quotas to Credit
57	CREDIT_FACTOR	☐	CIAP_CREDIT_FACTOR		DEC	5	4	CIAP Credit Factor
58	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
59	MAT_DESC	☐	MAKTX	TEXT40	CHAR	40	0	Material description
60	UNIT_MEASURE	☐	J_1BNETUNT	MEINS	UNIT	3	0	Base unit of measure	*
61	NFE_KEY	☐	CIAP_NFE_ACCESS_KEY		CHAR	44	0	CIAP NF-e Access Key
62	CTE_NFE_KEY	☐	CIAP_CTE_NFE_ACCESS_KEY		CHAR	44	0	CIAP CT-e NF-e Access Key

History

Last changed by/on	SAP	20140121
SAP Release Created in