CIAP_D_RECORD

CIAP Record | #transactional | Component: Tax Management Framework Integration
Column Name Description
MANDT Client
ID CIAP Record Unique ID
Column Name Description
Column Name Description
📏 Base unit of measure (UNIT_MEASURE):
QUANTITY Quantity
ORIGINAL_QUANTITY Quantity
Column Name Description
CREATION_DATE Creation Date
LAST_CHANGE_DATE Last Changed On
RETIREMENT_DATE Retirement Date
START_CREDIT_LIMIT_DATE Start of Crediting Period
END_CREDIT_LIMIT_DATE End of Crediting Period
Column Name Description
STATUS CIAP Record Status Show values
QUOTAS_QUANTITY Quota Number Show values
FINAL_ASSET Finalized Asset Show values
MANUAL CIAP Manual Record Show values
LEGACY_QUOTAS_QUANTITY Credited Legacy Quotas Show values
IN_TRANSIT Record in Transit Show values
RETIREMENT_OPERATION Retirement Operation Show values
EXTEMPORANEOUS_TYPE Late Submission Show values
JVA CIAP JVA Record Show values
MATERIAL_USAGE Usage of the material Show values
INVESTMENT_STOCK Investment Stock Show values
CREATION_TYPE Record Creation Type Show values
MANUAL_SUSP Manual Suspension Show values
CREDITING_PERIOD_LIMIT Crediting Period Limit Show values
DIFAL_POSTPONED Postponed DIFAL Show values
BAPI Created via BAPI Show values
IMMEDIATE_CREDIT Immediate Credit Indicator Show values
COMPONENT_AS_ASSET Component Treated as Asset Show values
STOCK_AS_ASSET Stock as Asset Show values
PENDING_ACCOUNTING Pending Accounting Show values
Column Name Description Domain name
LAST_DETERMINATION Period (Month/Year) CIAP_PERIOD
GOODS_VALUE Goods Value CIAP_VALUE
CREDIT_FACTOR Credit Factor
ICMS_BASE ICMS Base CIAP_VALUE
ICMS_VALUE ICMS Value CIAP_VALUE
ICMS_SUB_TRIB Substituição Tributária Value CIAP_VALUE
ICMS_DIFAL DIFAL Value CIAP_VALUE
ICMS_FREIGHT_VALUE Freight ICMS Value CIAP_VALUE
ICMS_FREIGHT_SUB_TRIB Substituição Tributária Value CIAP_VALUE
ICMS_FREIGHT_DIFAL DIFAL Value CIAP_VALUE
ICMS_TOTAL ICMS Total Value CIAP_VALUE
ICMS_TO_CREDIT ICMS to Credit Value CIAP_VALUE
ICMS_NOT_CREDITED ICMS not Credited CIAP_VALUE
ICMS_CREDITED ICMS Credited Value CIAP_VALUE
CREATED_BY Created By USNAM
LAST_CHANGED_BY Last Changed By USNAM
POLICE_REPORT Obsolete
MAT_DOCUMENT_YEAR Material Document Year GJAHR
MAT_DOCUMENT_ITEM Item in Material Document MBLPO
USEFUL_LIFE Useful Life in Months
NETWORK_NUMBER Network Number for Account Assignment AUFNR
ACTIVITY_NUMBER Operation/Activity Number VORNR
ICMS_RETURNED ICMS Returned CIAP_VALUE
ICMS_NOT_ALLOWED ICMS Not Allowed CIAP_VALUE
COD_IND_BEM Asset/Component Code CIAP_EFD_COD_IND_BEM
FUNC Asset Function Description CIAP_EFD_FUNC
DESCR_ITEM Asset or Component Description CIAP_EFD_DESCR_ITEM
COD_PRNC Main Asset Code CIAP_EFD_COD_PRNC
COD_CTA G/L Account Number CIAP_EFD_COD_CTA
COD_CCUS Cost Center Code CIAP_EFD_COD_CCUS
CCUS Cost Center Description CIAP_EFD_DESCR_CCUS
VIDA_UTIL Useful Life (Months) CIAP_EFD_VIDA_UTIL
PARENT_ID CIAP Record Unique ID SYSUUID_X16
TOTAL_VALUE Total Value CIAP_VALUE
ICMS_FREIGHT_BASE Freight ICMS Base CIAP_VALUE
VERSION CIAP Version CIAP_VERSION
PLANT Plant WERKS
SHORT_TERM ICMS Short Term Value CIAP_VALUE
LONG_TERM ICMS Long Term Value CIAP_VALUE
FIRST_ACCOUNTABLE_PERIOD First Accountable Period CIAP_PERIOD
LEGACY_VALUE Legacy Value CIAP_VALUE
Master Data Relations Join Conditions
Account Assignment Category
  • CIAP_D_RECORD.MANDT == T163K.MANDT
  • CIAP_D_RECORD.ACCOUNT_ASSIG_CATEGORY == T163K.KNTTP
Company Code
  • CIAP_D_RECORD.MANDT == T001.MANDT
  • CIAP_D_RECORD.COMPANY_CODE == T001.BUKRS
Currency
  • CIAP_D_RECORD.MANDT == TCURC.MANDT
  • CIAP_D_RECORD.CURRENCY == TCURC.WAERS
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • CIAP_D_RECORD.[column in domain "KTOPL"] == SKA1.KTOPL
  • CIAP_D_RECORD.MANDT == SKA1.MANDT
  • CIAP_D_RECORD.GLACCOUNT == SKA1.SAKNR
Order Number
  • Order Number
  • Client
  • CIAP_D_RECORD.INTERNAL_ORDER == AUFK.AUFNR
  • CIAP_D_RECORD.MANDT == AUFK.MANDT
Material Number
  • Material Number
  • Client
  • CIAP_D_RECORD.MATERIAL_NUMBER == MARA.MATNR
  • CIAP_D_RECORD.MANDT == MARA.MANDT