CIAP_D_RECORD - CIAP Record

CIAP Record information is stored in SAP table CIAP_D_RECORD.
It is part of development package INT_TMF_CIAP in software component LO-INT-TMF. This development package consists of objects that can be grouped under "TMF Integration Features: CIAP".

Fields for table CIAP_D_RECORD

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
ID	CIAP Record Unique ID	X	CIAP_RECORD_ID	RAW	16
COMPANY_CODE	Company Code		BUKRS	CHAR	8	T001
BRANCH	Business Place		J_1BBRANC_	CHAR	8	PBUSINESSPLACE
MATERIAL_NUMBER	Material Number		MATNR	CHAR	80	MARA
CREATION_DATE	Creation Date		CIAP_CREATION_DATE	DATS	16
STATUS	CIAP Record Status		CIAP_RECORD_STATUS	CHAR	4
QUOTAS_QUANTITY	Quota Number		CIAP_QUOTA_NUMBER	NUMC	8
LAST_DETERMINATION	Period (Month/Year)		CIAP_PERIOD	NUMC	12
WBS	Work Breakdown Structure Element (WBS Element)		PS_PSP_PNR	NUMC	16	PRPS
INTERNAL_ORDER	Order Number		AUFNR	CHAR	24	AUFK
FINAL_ASSET	Finalized Asset		CIAP_FINAL_ASSET	CHAR	2
ASSET_ID	Main Asset Number		ANLN1	CHAR	24	IFIMASTFIXASSET
ASSET_SUBNUMBER	Asset Subnumber		ANLN2	CHAR	8	IFIXASSET
GOODS_VALUE	Goods Value		CIAP_GOODS_VALUE	DEC	12
CREDIT_FACTOR	Credit Factor		CIAP_CREDIT_FACTOR	DEC	5
ICMS_BASE	ICMS Base		CIAP_ICMS_BASE	DEC	12
ICMS_VALUE	ICMS Value		CIAP_ICMS_VALUE	DEC	12
ICMS_SUB_TRIB	Substitui��o Tribut�ria Value		CIAP_SUB_TRIB_VALUE	DEC	12
ICMS_DIFAL	DIFAL Value		CIAP_DIFAL_VALUE	DEC	12
ICMS_FREIGHT_VALUE	Freight ICMS Value		CIAP_FREIGHT_ICMS_VALUE	DEC	12
ICMS_FREIGHT_SUB_TRIB	Substitui��o Tribut�ria Value		CIAP_SUB_TRIB_VALUE	DEC	12
ICMS_FREIGHT_DIFAL	DIFAL Value		CIAP_DIFAL_VALUE	DEC	12
ICMS_TOTAL	ICMS Total Value		CIAP_ICMS_TOTAL_VALUE	DEC	12
ICMS_TO_CREDIT	ICMS to Credit Value		CIAP_ICMS_TO_CREDIT	DEC	12
ICMS_NOT_CREDITED	ICMS not Credited		CIAP_ICMS_NOT_CREDITED	DEC	12
ICMS_CREDITED	ICMS Credited Value		CIAP_ICMS_CREDITED	DEC	12
CURRENCY	Currency		CIAP_CURRENCY	CUKY	10	TCURC
CREATED_BY	Created By		CIAP_CREATED_BY_USERNAME	CHAR	24
LAST_CHANGED_BY	Last Changed By		CIAP_CHANGED_BY_USERNAME	CHAR	24
LAST_CHANGE_DATE	Last Changed On		CIAP_CHANGING_DATE	DATS	16
RETIREMENT_DATE	Retirement Date		CIAP_RETIREMENT_DATE	DATS	16
MANUAL	CIAP Manual Record		CIAP_RECORD_MANUAL	CHAR	2
LEGACY_QUOTAS_QUANTITY	Credited Legacy Quotas		CIAP_QUOTA_LEGACY_NUMBER	NUMC	8
QUANTITY	Quantity		J_1BNETQTY	QUAN	7
UNIT_MEASURE	Base unit of measure		J_1BNETUNT	UNIT	6
IN_TRANSIT	Record in Transit		CIAP_IN_TRANSIT	CHAR	2
GLACCOUNT	G/L Account Number		SAKNR	CHAR	20	SKA1
POLICE_REPORT	Obsolete		CIAP_POLICE_REPORT	CHAR	510
RETIREMENT_OPERATION	Retirement Operation		CIAP_RETIREMENT_OPERATION	CHAR	4
EXTEMPORANEOUS_TYPE	Late Submission		CIAP_EXTEMPORANEOUS	CHAR	2
JVA	CIAP JVA Record		CIAP_RECORD_JVA	CHAR	2
MATERIAL_USAGE	Usage of the material		J_1BMATUSE	CHAR	2
INVESTMENT_STOCK	Investment Stock		CIAP_INVESTMENT_STOCK	CHAR	2
MAT_DOCUMENT	Material Document Number		CIAP_MAT_DOCUMENT	CHAR	20	MKPF
MAT_DOCUMENT_YEAR	Material Document Year		MJAHR	NUMC	8
MAT_DOCUMENT_ITEM	Item in Material Document		MBLPO	NUMC	8
USEFUL_LIFE	Useful Life in Months		CIAP_USEFUL_LIFE	NUMC	6
CREATION_TYPE	Record Creation Type		CIAP_CREATION_TYPE	CHAR	2
MANUAL_SUSP	Manual Suspension		CIAP_MANUAL_SUSP	CHAR	2
CREDITING_PERIOD_LIMIT	Crediting Period Limit		CIAP_CREDITING_PERIOD_LIMIT	CHAR	2
DIFAL_POSTPONED	Postponed DIFAL		CIAP_DIFAL_POSTPONED	CHAR	2
BAPI	Created via BAPI		CIAP_BAPI	CHAR	2
ACCOUNT_ASSIG_CATEGORY	Account Assignment Category		KNTTP	CHAR	2	T163K
IMMEDIATE_CREDIT	Immediate Credit Indicator		CIAP_IMMEDIATE_CREDIT	CHAR	2
COMPONENT_AS_ASSET	Component Treated as Asset		CIAP_COMPONENT_AS_ASSET	CHAR	2
MAIN_WBS	Main WBS		CIAP_MAIN_WBS	NUMC	16	PRPS
STOCK_AS_ASSET	Stock as Asset		CIAP_STOCK_AS_ASSET	CHAR	2
NETWORK_NUMBER	Network Number for Account Assignment		NPLNR	CHAR	24
ACTIVITY_NUMBER	Operation/Activity Number		VORNR	CHAR	8
ICMS_RETURNED	ICMS Returned		CIAP_ICMS_RETURNED	DEC	12
ICMS_NOT_ALLOWED	ICMS Not Allowed		CIAP_ICMS_NOT_ALLOWED	DEC	12
PENDING_ACCOUNTING	Pending Accounting		CIAP_PENDING_ACCOUNTING	CHAR	2
.INCLUDE				CIAP_EFD_DATA	0
COD_IND_BEM	Asset/Component Code		CIAP_EFD_COD_IND_BEM	CHAR	120
FUNC	Asset Function Description		CIAP_EFD_FUNC	CHAR	510
DESCR_ITEM	Asset or Component Description		CIAP_EFD_DESCR_ITEM	CHAR	510
COD_PRNC	Main Asset Code		CIAP_EFD_COD_PRNC	CHAR	120
COD_CTA	G/L Account Number		CIAP_EFD_COD_CTA	CHAR	120
COD_CCUS	Cost Center Code		CIAP_EFD_COD_CCUS	CHAR	120
CCUS	Cost Center Description		CIAP_EFD_DESCR_CCUS	CHAR	120
VIDA_UTIL	Useful Life (Months)		CIAP_EFD_VIDA_UTIL	NUMC	6
ORIGINAL_QUANTITY	Quantity		J_1BNETQTY	QUAN	7
PARENT_ID	CIAP Record Unique ID		CIAP_RECORD_ID	RAW	16
TOTAL_VALUE	Total Value		CIAP_TOTAL_VALUE	DEC	12
ICMS_FREIGHT_BASE	Freight ICMS Base		CIAP_FREIGHT_ICMS_BASE	DEC	12
VERSION	CIAP Version		CIAP_VERSION	CHAR	40
PLANT	Plant		WERKS_D	CHAR	8
.INCLUDE				CIAP_BALANCE_ACCOUNT	0
SHORT_TERM	ICMS Short Term Value		CIAP_SHORT_TERM_VALUE	DEC	12
LONG_TERM	ICMS Long Term Value		CIAP_LONG_TERM_VALUE	DEC	12
START_CREDIT_LIMIT_DATE	Start of Crediting Period		CIAP_START_CREDIT_LIMIT_DATE	DATS	16
END_CREDIT_LIMIT_DATE	End of Crediting Period		CIAP_END_CREDIT_LIMIT_DATE	DATS	16
FIRST_ACCOUNTABLE_PERIOD	First Accountable Period		CIAP_FIRST_ACCOUNTABLE_PERIOD	NUMC	12
LEGACY_VALUE	Legacy Value		CIAP_LEGACY_VALUE	DEC	12