J_1B_CIAP_OBJECT SAP table for – CIAP document data

Here we would like to draw your attention to J_1B_CIAP_OBJECT table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_1B_CIAP_OBJECT is a SAP standard transp table used for storing CIAP document data related data in SAP. It comes under the package ID-CIAP-BR.

SAP J_1B_CIAP_OBJECT table

Table J_1B_CIAP_OBJECT technical data

TableJ_1B_CIAP_OBJECT
Data storingCIAP document data
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-CIAP-BR
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_FIN
Table CategoryTRANSP

SAP J_1B_CIAP_OBJECT Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in J_1B_CIAP_OBJECT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : CIAP_DATA_KEY
    Its a key field.
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • DOCNUM : Document Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • ITMNUM : Document Item Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • TAXTYP : Tax Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • SERNO : CIAP Document Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • .INCLUDE : What and where is the CIAP object currently?
  • KNTYP : Object Assignment Type
    Its data type is CHAR (Character String) with field length 35
  • CONDNO : CIAP Condition Number
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • GSBER : Business Area
    Its data type is CHAR (Character String) with field length 4
  • REGIO : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • BRANCH : Business Place
    Its data type is CHAR (Character String) with field length 4
  • WERKS : Plant
    Its data type is CHAR (Character String) with field length 4
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • ANLN1 : Main Asset Number
    Its data type is CHAR (Character String) with field length 12
  • ANLN2 : Asset Subnumber
    Its data type is CHAR (Character String) with field length 4
  • KOKRS : Controlling Area
    Its data type is CHAR (Character String) with field length 4
  • KOSTL : Cost Center
    Its data type is CHAR (Character String) with field length 10
  • PRCTR : Profit Center
    Its data type is CHAR (Character String) with field length 10
  • AUFNR : Order Number
    Its data type is CHAR (Character String) with field length 12
  • PSPNR : Work Breakdown Structure Element (WBS Element)
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • NPLNR : Network Number for Account Assignment
    Its data type is CHAR (Character String) with field length 12
  • KOART : Account type
    Its data type is CHAR (Character String) with field length 1
  • SUP_KEY_TYPES1 : Additional Key 1
    Its data type is CHAR (Character String) with field length 10
  • SUP_KEY_VALUE1 : Value for Additional Key 1
    Its data type is CHAR (Character String) with field length 25
  • SUP_KEY_TYPES2 : Additional Key 2
    Its data type is CHAR (Character String) with field length 10
  • SUP_KEY_VALUE2 : Value for Additional Key 2
    Its data type is CHAR (Character String) with field length 25
  • .INCLUDE : Stores the CIAP relevant line data
  • CIAP_VALUE_START : Start Date of CIAP Value in Current CIAP Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CIAP_VALUE_STOP : End Date of CIAP Value in Current CIAP Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CIAP_START_DATE : Initial Start Date of the Current CIAP Object
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SHKZG : Debit/Credit Indicator
    Its data type is CHAR (Character String) with field length 1
  • TAXVAL : Tax Value
    Its data type is CURR (Currency Field) with field length 15
  • MENGE : Quantity
    Its data type is QUAN (Quantity field) with field length 13
  • RET_SALE_LOSS : Describes how a CIAP object was deactivated
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Ciap document data
  • BLDAT : Document Date in Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BUDAT : Posting Date in the Document
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • BU_TM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERDTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • UPNAM : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • UPDDT : Date of the Last Document Update
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPDTM : Time of data entry
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • VORGN : Transaction Type for General Ledger
    Its data type is CHAR (Character String) with field length 4
  • TCODE : Transaction Code
    Its data type is CHAR (Character String) with field length 20
  • BWASL : Asset Transaction Type
    Its data type is CHAR (Character String) with field length 3
  • BWART : Movement type (inventory management)
    Its data type is CHAR (Character String) with field length 3
  • BELNR : Reference document number
    Its data type is CHAR (Character String) with field length 10
  • LFDNR : Sequence number (four characters)
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • AWKEY : Object key
    Its data type is CHAR (Character String) with field length 20
  • AWTYP : Reference procedure
    Its data type is CHAR (Character String) with field length 5
  • AWORG : Reference organisational units
    Its data type is CHAR (Character String) with field length 10
  • AWSYS : Logical System
    Its data type is CHAR (Character String) with field length 10
  • DOCREF : Reference to NF
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • ITMREF : Reference to item number (Return)
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • REFTYP : Reference type
    Its data type is CHAR (Character String) with field length 2
  • REFKEY : Reference to source document
    Its data type is CHAR (Character String) with field length 35
  • REFITM : Reference item to source document
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • .INCLUDE : Data set by the CIAP appl and will be used internally
  • LOG_KEY_CHAR35 : Sender Key
    Its data type is CHAR (Character String) with field length 35
  • CIAP_OBJ_FLAG : Identified as CIAP Object
    Its data type is CHAR (Character String) with field length 1
  • CIAP_STATUS : Internal Status of the CIAP Object Set by the System
    Its data type is CHAR (Character String) with field length 3
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • TEXT : Text Field
    Its data type is CHAR (Character String) with field length 50