SAP ABAP Table FILA_MIG_ITEM (Load Structure for LAE Item)
Hierarchy
☛
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
⤷ FI-LA (Application Component) Lease Accounting
⤷ FI_LA_BA (Package) Lease Accounting - Basis
⤷ FI-LA (Application Component) Lease Accounting
⤷ FI_LA_BA (Package) Lease Accounting - Basis
Basic Data
Table Category | INTTAB | Structure |
Structure | FILA_MIG_ITEM | Table Relationship Diagram |
Short Description | Load Structure for LAE Item |
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 | OBJECTID | FILA_REFOBJ | FILA_REFOBJ | CHAR | 10 | 0 | Contract Number | * | |
2 | .INCLUDE | 0 | 0 | LAE: Contract Items | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
4 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
5 | OBJID | FILA_OBJID | RAW | 16 | 0 | Object Number | LAE_CRM_HEADER | ||
6 | SUBID | FILA_SUBID | NUMC | 5 | 0 | Subobject Number | |||
7 | TMSTAMP | TIMESTAMP | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
8 | .INCLUDE | 0 | 0 | LAE: Substructure for Contract Items Gen. Data | |||||
9 | EVENT | FILA_EVENT | FILA_EVENT | CHAR | 20 | 0 | Process | * | |
10 | STATUS | FILA_STATUS | FILA_STATUS | NUMC | 1 | 0 | Processing Status | ||
11 | ITEMNO | FILA_ITEMNO | NUMC | 10 | 0 | Item Number | |||
12 | ITEMNO_EXT | FILA_ITEMNO_EXT | NUMC | 10 | 0 | External Item Number | |||
13 | ITEMTXT | FILA_ITEMTXT | TEXT50 | CHAR | 50 | 0 | Item Description | ||
14 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
15 | EXCHG_RATE | KURSF | KURSF | DEC | 9 | 5 | Exchange rate | ||
16 | QUANTITY | AM_MENGE | MENG13V | QUAN | 13 | 3 | Quantity | ||
17 | UNIT | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
18 | BUKRS_REF | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
19 | OBJID_REF | FILA_OBJID_REF | RAW | 16 | 0 | Object Number of Reference Object | |||
20 | SUBID_REF | FILA_SUBID_REF | NUMC | 5 | 0 | Reference Sub-Object Number | |||
21 | SUBID_STG | FILA_SUBID_REF | NUMC | 5 | 0 | Reference Sub-Object Number | |||
22 | UIID | FILA_UIID | FILA_UIID | CHAR | 12 | 0 | Unique Item ID in Life Cycle | ||
23 | EXT_POS_REF | FILA_EXT_ITEM_REF | FILA_EXT_ITEM_REF | CHAR | 35 | 0 | External Item Reference | ||
24 | FREE_POS_REF | FILA_FREE_EXT_ITEM_REF | FILA_EXT_ITEM_REF | CHAR | 35 | 0 | Custom External Item Reference | ||
25 | .INCLUDE | 0 | 0 | LAE: Substructure Contract Item Dates/Term | |||||
26 | CONTSTARTDT | FILA_CONTSTARTDT | DATUM | DATS | 8 | 0 | Start Date of Contract for Contract Item | ||
27 | CONTENDDT | FILA_CONTENDDT | DATUM | DATS | 8 | 0 | End Date of Contract for Contract Item | ||
28 | LEASTARTDT | FILA_LEASTARTDT | DATUM | DATS | 8 | 0 | Date on Which Contract Processes Are Active(Lease Start Date | ||
29 | LEASOPTEXEDT | FILA_LEASOPTEXEDT | DATUM | DATS | 8 | 0 | Option Exercise Date | ||
30 | TERM | FILA_TERM | NUMC3 | NUMC | 3 | 0 | Contract Term (in Months) | ||
31 | REM_USEFUL_LIFE | FILA_REMAINING_USEFUL_LIFE | NUMC | 3 | 0 | Remaining Useful Life | |||
32 | .INCLUDE | 0 | 0 | LAE: Substructure Contract Item Sales Data | |||||
33 | PRODUCT | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
34 | USEDPRODUCT | FILA_USEDPRODUCT | XFELD | CHAR | 1 | 0 | Used Goods | ||
35 | CUSTGROUP | KDGRP | KDGRP | CHAR | 2 | 0 | Customer group | T151 | |
36 | SALESORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
37 | DIS_CHANNEL | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
38 | SOLDTO | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
39 | INSTAT | FILA_INSTAT | KUNNR | CHAR | 10 | 0 | Installation Location | * | |
40 | FINPROD | FILA_FINPROD | MATNR | CHAR | 18 | 0 | Financing Product | * | |
41 | FINCLAS | FILA_FINCLASSIFICATION | FILA_FINCLASSIFICATION | CHAR | 2 | 0 | Classification of Financing Type | ||
42 | BP_USAGE | FILA_BP_USAGE | FILA_BP_USAGE | CHAR | 1 | 0 | Use of Billing Plan | ||
43 | DEVICECLASS | FILA_DEVICECLASS | CHAR | 10 | 0 | Device Class | |||
44 | OPTIONID | FILA_OPTIONID | FILA_OPTIONID | CHAR | 2 | 0 | Option ID | * | |
45 | CLASSIF_LOCAL | FILA_CLASSLO | CHAR | 2 | 0 | Tax Financing Classification - Local | |||
46 | CLASSIF_GROUP | FILA_CLASSGR | CHAR | 2 | 0 | Tax Financing Classification - Group | |||
47 | CLASSIF_LO_FLAG | FILA_CLASSLO_FLAG | XFELD | CHAR | 1 | 0 | Forced Classification Indicator | ||
48 | CLASSIF_GR_FLAG | FILA_CLASSGR_FLAG | XFELD | CHAR | 1 | 0 | Forced Classification | ||
49 | CLAS_CUSTOMER | FILA_CLASSCU | CHAR | 2 | 0 | Classification - Customer | |||
50 | BUS_AREA | GSBER | GSBER | CHAR | 4 | 0 | Business Area | * | |
51 | CLASSIF_LOCALBK | FILA_CLASSLOCBK | CHAR | 2 | 0 | Book Financing Classification - Local | |||
52 | CLASSIF_GROUPBK | FILA_CLASSGRPBK | CHAR | 2 | 0 | Book Financing Classification - Group | |||
53 | CLASSIF_LOBK_FL | FILA_CLASSLOCBK_FLAG | XFELD | CHAR | 1 | 0 | Forced Classification Indicator | ||
54 | CLASSIF_GRBK_FL | FILA_CLASSGRPBK_FLAG | XFELD | CHAR | 1 | 0 | Forced Classification Indicator | ||
55 | INTRATE | FILA_INTRATE | AFPROZ | DEC | 7 | 4 | Annual Interest Rate | ||
56 | PROC_INDICATOR | FILA_PROC_CNTRL_INDICATOR | FILA_PROC_CNTRL_INDICATOR | NUMC | 1 | 0 | Process Indicator for Leveraged Debt Cost | ||
57 | BU_ID_NUMBER | FILA_BU_ID_NUMBER | CHAR60 | CHAR | 60 | 0 | Identification Number | ||
58 | BU_ID_TYPE | FILA_BU_ID_TYPE | BU_ID_TYPE | CHAR | 6 | 0 | Identification Type | * | |
59 | BU_PARTNER | FILA_BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
60 | BEMOT | FILA_BEMOT | BEMOT | CHAR | 2 | 0 | Accounting Indicator | * | |
61 | BUAG_ID | FILA_BUAG_ID | CHAR12 | CHAR | 12 | 0 | Business Agreement Number | ||
62 | TMSTAMPADJ | FILA_TMSTAMPADJ | TZNTSTMPS | DEC | 15 | 0 | Time Stamp of Last Business Transaction from CRM | ||
63 | PROCMODE | FILA_PROCMODE | FILA_PROCMODE | NUMC | 1 | 0 | Processing Mode of Process | ||
64 | LOGHANDLE | BALLOGHNDL | SYSUUID_22 | CHAR | 22 | 0 | Application Log: Log Handle | ||
65 | TMSTAMPREV | FILA_TMSTAMPREV | TZNTSTMPS | DEC | 15 | 0 | Time Stamp of Business Transaction to be Reversed | ||
66 | ALLOCATION_ID | FILA_ALLOCATION_ID | CHAR16 | CHAR | 16 | 0 | External Assignment Indicator | ||
67 | TMSTAMPESP | FILA_TMSTAMPESP | TZNTSTMPS | DEC | 15 | 0 | Time Stamp - Processed Successfully (BW Delta Extraction) | ||
68 | RUNID | FILA_RUNID_MIG | NUMC10 | NUMC | 10 | 0 | Migration Run Number | ||
69 | BUS_SCENARIO_ID | FILA_BS_IDENTIFICATION | CHAR | 16 | 0 | Business Scenario for Which Controlling Is Performed | |||
70 | FIELD01 | FILA_FIELD01 | CHAR20 | CHAR | 20 | 0 | Field for Customer-Specific Data | ||
71 | FIELD02 | FILA_FIELD02 | CHAR20 | CHAR | 20 | 0 | Field for Customer-Specific Data | ||
72 | FIELD03 | FILA_FIELD03 | CHAR20 | CHAR | 20 | 0 | Field for Customer-Specific Data | ||
73 | LESSOR | LIFNR | LIFNR | CHAR | 10 | 0 | Account Number of Vendor or Creditor | * | |
74 | OTP_CURRENCY | CURRENCY | WAERS | CUKY | 5 | 0 | Currency Key | * | |
75 | HEADER_TXT | BKTXT | TEXT25 | CHAR | 25 | 0 | Document Header Text |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FILA_MIG_ITEM | CUSTGROUP | T151 | KDGRP | REF | 1 | CN |
2 | FILA_MIG_ITEM | DIS_CHANNEL | TVTW | VTWEG | REF | 1 | CN |
3 | FILA_MIG_ITEM | OBJID | LAE_CRM_HEADER | OBJID | |||
4 | FILA_MIG_ITEM | SALESORG | TVKO | VKORG | REF | 1 | CN |
5 | FILA_MIG_ITEM | SOLDTO | KNA1 | KUNNR | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 500 |