SAP CASSETTP Table in S/4 HANA - Generated Table for View
CASSETTP is a standard SAP Table which is used to store Generated Table for View data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP CASSETTP table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: CASSETTP
CASSETTP table structure field list
Below is the full CASSETTP field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | CLNT | 3(0) | ||||||||
COMPANYCODE | Company Code | BUKRS | CHAR | 4(0) | BUKRS | BUK | C_T001 | BUKRS | ||
MASTERFIXEDASSET | Main Asset Number | ANLN1 | CHAR | 12(0) | ALPHA | ANLN1 | AN1 | |||
FIXEDASSET | Asset Subnumber | ANLN2 | CHAR | 4(0) | ALPHA | ANLN2 | AN2 | |||
MASTERFIXEDASSETFOREDIT | Main Asset Number | ANLN1 | CHAR | 12(0) | ALPHA | ANLN1 | AN1 | |||
FIXEDASSETFOREDIT | Asset Subnumber | ANLN2 | CHAR | 4(0) | ALPHA | ANLN2 | AN2 | |||
FIXEDASSETEXTERNALID | Asset Number | FIS_FIXEDASSET_EXT_ID | CHAR | 17(0) | CHAR17 | |||||
ASSETCOMPLETENESSSTATUS | Completeness Status | FAA_MD_COMPL_STATUS | CHAR | 1(0) | FAA_MD_COMPL_STATUS | |||||
ASSETCOMPLETENESSSTATUSNAME | Completeness Status Text | FAA_MD_COMPL_STATUS_TEXT | CHAR | 60(0) | DDTEXT | |||||
ASSETLIFECYCLESTATUS | Lifecycle Status | FAA_MD_LC_STATUS | CHAR | 1(0) | FAA_MD_LC_STATUS | |||||
ASSETLIFECYCLESTATUSNAME | Lifecycle Status Text | FAA_MD_LC_STATUS_TEXT | CHAR | 60(0) | DDTEXT | |||||
ASSETUNDERCONSTRUCTIONSTATUS | AuC Status | FAA_MD_AUC_STATUS | CHAR | 1(0) | FAA_MD_AUC_STATUS | |||||
ASSETUNDRCONSTRUCTIONSTSNAME | AuC Status Text | FAA_MD_AUC_STATUS_TEXT | CHAR | 60(0) | DDTEXT | |||||
ISMAINASSET | Indicator for Main Asset | FAA_MD_XMAIN | CHAR | 1(0) | XFELD | |||||
HASHISTORY | Indicator: Historical management | ANEQK | NUMC | 1(0) | ANEQK | |||||
ACCOUNTISBLOCKEDFORPOSTING | Indicator: Asset Locked to Acquisition Postings | XSPEB_ANLA | CHAR | 1(0) | XFELD | |||||
ISLEGACYASSET | Indicator for Legacy Asset | FAA_MD_XLEGACYASSET | CHAR | 1(0) | XFELD | |||||
ASSETISFORPOSTCAPITALIZATION | Indicator for Asset for Post-Cap. | FAA_MD_XPOSTCAP | CHAR | 1(0) | XFELD | |||||
CREATEDBYUSER | Name of Person who Created the Object | ERNAM | CHAR | 12(0) | USNAM | |||||
CREATIONDATE | Date on which the record was created | ERDAT | DATS | 8(0) | DATUM | |||||
CREATIONDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15(0) | TZNTSTMPS | |||||
LASTCHANGEDBYUSER | Name of person who changed object | AENAM | CHAR | 12(0) | USNAM | |||||
LASTCHANGEDATE | Changed On | FIS_AEDAT_ANLA | DATS | 8(0) | DATUM | |||||
LASTCHANGEDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC | 15(0) | TZNTSTMPS | |||||
ASSETCREATIONVALIDITYDATE | Validity Date from Asset Class | FAA_MD_VALIDITY_DATE | DATS | 8(0) | DATS | |||||
ASSETCLASS | Asset Class | ANLKL | CHAR | 8(0) | ALPHA | ANLKL | ANK | SH_ANLKA | ANLKL | |
ASSETSCREENLAYOUT | Layout for Asset Master Data | FAA_LAYOUT | CHAR | 20(0) | ||||||
ASSETACCOUNTDETERMINATION | Account Determination | KTOGR | CHAR | 8(0) | ALPHA | KTOGR | ||||
FIXEDASSETORDERDATE | Asset Purchase Order Date | BSTDT | DATS | 8(0) | DATUM | |||||
FIXEDASSETDESCRIPTION | Asset Description | TXA50_ANLT | CHAR | 50(0) | TEXT50 | |||||
ASSETADDITIONALDESCRIPTION | Additional Asset Description | TXA50_MORE | CHAR | 50(0) | TEXT50 | |||||
ASSETSERIALNUMBER | Serial number | AM_SERNR | CHAR | 18(0) | ALPHA | GERNR | SER | |||
INVENTORY | Inventory Number | INVNR_ANLA | CHAR | 25(0) | INVNR_ANLA | |||||
SUPPLIER | Account number of vendor (other key word) | AM_LIFNR | CHAR | 10(0) | ALPHA | LIFNR | LIF | |||
ASSETCOUNTRYOFORIGIN | Asset's Country of Origin | AM_LAND1 | CHAR | 3(0) | LAND1 | |||||
ASSETMANUFACTURERNAME | Manufacturer of Asset | HERST | CHAR | 30(0) | TEXT30 | |||||
ORIGINALMASTERFIXEDASSET | Original Asset That Was Transferred | AIBN1 | CHAR | 12(0) | ALPHA | ANLN1 | ||||
ORIGINALFIXEDASSET | Original Asset That Was Transferred | AIBN2 | CHAR | 4(0) | ALPHA | ANLN2 | ||||
ORIGINALFIXEDASSETVALUEDATE | Original Acquisition Date of AuC/ Transferred Asset | AIBDT | DATS | 8(0) | DATUM | |||||
ORIGINALACQUISITIONFISCALYEAR | Fiscal Year of Original Acquisition | URJHR | NUMC | 4(0) | GJAHR | GJAHR | ||||
ORIGLACQNAMTINCOCODECRCY | Original Acquisition Value | URWRT | CURR | 23(2) | AC132 | AFLE13D2O16S_TO_23D2O31S | ||||
ORIGINALACQUISITIONCURRENCY | Original Acquisition Value Currency | FAA_MD_ORG_ACQ_CURR | CUKY | 5(0) | WAERS | |||||
INHOUSEPRODNPERCENT | In-house production percentage | ANTEI | DEC | 5(2) | PRZ32 | |||||
ASSETTYPENAME | Asset Type Name | TYPBZ_ANLA | CHAR | 15(0) | TYPBZ_ANLA | |||||
PARTNERCOMPANY | Company ID of Trading Partner | RASSC | CHAR | 6(0) | ALPHA | RCOMP | PGS | |||
INVESTMENTORDER | Investment Order | AM_AUFNR | CHAR | 12(0) | ALPHA | AUFNR | ||||
INVESTMENTPROJECTWBSELEMENT | WBS element investment project | AM_POSNR | NUMC | 8(0) | ABPSP | PS_POSNR | ||||
LASTINVENTORYDATE | Last Inventory Date | IVDAT_ANLA | DATS | 8(0) | DATUM | |||||
INVENTORYNOTE | Supplementary Inventory Specifications | INVZU_ANLA | CHAR | 15(0) | INVZU_ANLA | |||||
INVENTORYISCOUNTED | Inventory Indicator | INKEN | CHAR | 1(0) | XFELD | |||||
INVESTMENTREASON | Reason for Investment | IZWEK | CHAR | 2(0) | IZWEK | |||||
ENVRNMTLINVESTMENTREASON | Reason for Environmental Investment | AM_UMWKZ | CHAR | 5(0) | AM_UMWKZ | |||||
FIXEDASSETGROUP | Asset Super Number | ANLUE | CHAR | 12(0) | ANLUE | H_T087U | ANLUE | |||
PROPERTYCLASS | Property classification key | VMGLI | CHAR | 4(0) | ALPHA | VMGLI | ||||
FIXEDASSETPROPERTYTYPE | Property Indicator | EIGKZ | CHAR | 1(0) | EIGKZ | |||||
LOCALTAXOFFICE | Local Tax Office | FIAMT | CHAR | 25(0) | TEXT25 | |||||
NOTICEOFASSESSMENTTAXID | Tax Number of the Notice of Assessment | EHWNR_ANLA | CHAR | 16(0) | EHWNR_ANLA | |||||
LASTASSESSMENTNOTICEDATE | Date of last notice of assessment | EHWZU_ANLA | DATS | 8(0) | DATUM | |||||
MUNICIPALITY | Municipality | ORT01_ANLA | CHAR | 25(0) | TEXT25 | |||||
LANDREGISTERDATE | Land Register of | GRUVO_ANLA | DATS | 8(0) | DATUM | |||||
LANDREGISTERENTRYSEQUENCE | Land Register Entry: Sequence Number | GRLFD_ANLA | CHAR | 4(0) | GRLFD_ANLA | |||||
LANDREGISTERENTRYDATE | Land Register Entry on | GREIN_ANLA | DATS | 8(0) | DATUM | |||||
LANDREGISTERVOLUME | Land Register Volume | GRBND_ANLA | CHAR | 5(0) | GRBND_ANLA | |||||
LANDREGISTERPAGE | Land Register Page | GRBLT_ANLA | CHAR | 5(0) | GRBLT_ANLA | |||||
LANDREGISTERMAP | Land Register Map Number | FLURK_ANLA | CHAR | 4(0) | CHAR4 | |||||
LANDPLOT | Plot Number | FLURN_ANLA | CHAR | 10(0) | CHAR10 | |||||
CONVEYANCEDATE | Date of conveyance | AUFLA_ANLA | DATS | 8(0) | DATUM | |||||
AREASIZE | Surface Area | GRUFL | QUAN | 13(3) | MENG13 | |||||
AREASIZEUNIT | Area Unit | FEINS | UNIT | 3(0) | CUNIT | MEINS | FEH | |||
LEASESUPPLIER | Leasing company | LEAFI | CHAR | 10(0) | ALPHA | LIFNR | ||||
LEASEAGREEMENT | Leasing agreement number | LVTNR | CHAR | 15(0) | CHAR15 | |||||
LEASEAGREEMENTDATE | Leasing agreement date | LVDAT | DATS | 8(0) | DATUM | |||||
LEASETERMENDDATE | Leasing agreement notice date | LKDAT | DATS | 8(0) | DATUM | |||||
LEASETERMSTARTDATE | Lease start date | LEABG | DATS | 8(0) | DATUM | |||||
LEASEDURATIONINFISCALYEARS | Length of Lease in Years | LEJAR | NUMC | 3(0) | JARAF | |||||
LEASEDURATIONINFISCALPERIODS | Length of lease in periods | LEPER | NUMC | 3(0) | PERAF | |||||
LEASETYPE | Leasing type | LEART | CHAR | 2(0) | LEASART | |||||
LEASEDASSETNOTE | Leasing data text | LETXT | CHAR | 50(0) | TEXT50 | |||||
ASSETISREALESTATE | Indicator: Real Estate | AIMMO | NUMC | 1(0) | AIMMO | |||||
LASTREORGANIZATIONDATE | Date of last reorganization | FAA_LASTREORGDAT | DATS | 8(0) | DATUM | |||||
LEGACYASSET | Legacy Asset Number | FAA_LEGACYASSET | CHAR | 16(0) | ||||||
LEGACYMASTERFIXEDASSET | Legacy Main Asset Number | FAA_MD_LDT_ASSET_NO | CHAR | 12(0) | ALPHA | ANLN1 | ||||
LEGACYFIXEDASSET | Legacy Asset Subnumber | FAA_MD_LDT_ASSET_SUBNO | CHAR | 4(0) | ALPHA | ANLN2 | ||||
LEGACYDATATRANSFERDATE | Legacy Data Transfer Date | FAA_LDT_DATE | DATS | 8(0) | DATUM | |||||
LEGACYDATATRANSFERSEQUENCE | Legacy Data Transfer - sequence number | FAA_LDT_SEQNO | NUMC | 5(0) | NUMC5 | |||||
ASSETISACQUIREDUSED | Asset acquired used | XAFABCH | CHAR | 1(0) | XFELD | |||||
BASEUNIT | Base Unit of Measure | MEINS | UNIT | 3(0) | CUNIT | MEINS | ||||
BASEUNITNAME | Unit of Measurement Text (Maximum 10 Characters) | MSEHT | CHAR | 10(0) | TEXT10 | |||||
COUNTRY | Country Key | LAND1 | CHAR | 3(0) | T005 | LAND1 | LND | |||
NATIONALCLASSIFICATION | National Classification Code | GLO_NATL_CLFN_CODE | CHAR | 12(0) | GLO_NATL_CLFN_CODE | |||||
TAXDEPRECIATIONGROUP | Tax Depreciation Group | GLO_TAX_DEPR_GRP | CHAR | 4(0) | CHAR4 | |||||
RU_LONGSERIALNUMBER | Serial Number | J_3RFSERNR | CHAR | 32(0) | CHAR32 | |||||
RU_WORKWEARMATERIAL | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
RU_ASSETTRANSPORTTYPE | Transport Type | J_3RTYPV | CHAR | 5(0) | ||||||
RU_VEHICLEIDNUMBER | Manufacturer Vehicle Identification Number for Fleet Object | FLEET_VIN | CHAR | 30(0) | FLEET_VIN | |||||
RU_MANUFACTURINGDATE | Manufacturing Date | J_3RTBAUJJ | DATS | 8(0) | ||||||
RU_VEHICLEECOLOGICALCLASS | Ecological Class | J_3R_ECO_CLS | CHAR | 1(0) | J_3R_ECO_CLS | |||||
CHARTOFACCOUNTS | Chart of Accounts | KTOPL | CHAR | 4(0) | KTOPL | KPL | C_KTOPL | KTOPL | ||
GLACCOUNT | G/L Account Number | SAKNR | CHAR | 10(0) | ALPHA | SAKNR | SAK | C_SAKNR | SAKNR | |
JP_ANNEX16ASSETSTRUCTURE | Asset Structure | GLO_ANX16_STRC | CHAR | 5(0) | GLO_ANX16_STRC | |||||
JP_ANNEX16ASSETITEM | Asset Item | GLO_ANX16_ITEM | CHAR | 5(0) | GLO_ANX16_ITEM | |||||
JP_ANNEX16LEASINGAGRMTDATE | Leasing Agreement Date of Annex16-4 Report | GLO_ANX16_LEASE_AGREEMENT_DATE | DATS | 8(0) | DATUM | |||||
JP_PRPTYTXRPTCITY | City Code of Japan Property Tax Report | GLO_JP_CITY_CODE | CHAR | 8(0) | GLO_JP_CITY_CODE | |||||
JP_PRPTYTXRPTCLASSFCTNKEY | Classification Key of Japan Property Tax Report | GLO_JP_PTX_CLASSIFICATION_KEY | CHAR | 4(0) | GLO_JP_PTX_CLASSIFICATION_KEY | |||||
JP_PRPTYTXRPTSPCLDEPR | Special Depreciation Code of Japan Property Tax Report | GLO_JP_SDC | CHAR | 3(0) | GLO_JP_SDC | |||||
JP_PRPTYTXRPTADDLDEPR | Additional Depreciation Code | GLO_JP_PTX_ADDITIONAL_DEPR_COD | CHAR | 8(0) | GLO_JP_PTX_ADDITIONAL_DEPR_COD | |||||
IN_ASSETBLOCK | Block Key | GLO_IN_BLK_KEY | CHAR | 5(0) | GLO_IN_BLK_KEY | |||||
IN_ASSETPUTTOUSEDATE | Put to use date | GLO_IN_AST_PUT_USE | DATS | 8(0) | GLO_IN_AST_PUT_USE | |||||
IN_ADDITIONALASSETBLOCK | Additional Depreciation Block Key | GLO_IN_ADNL_BLK_KEY | CHAR | 5(0) | GLO_IN_ADNL_BLK_KEY | |||||
IN_ASSETISRESEARCHANDDEV | R & D Asset | GLO_IN_R_AND_D_ASSET | CHAR | 1(0) | GLO_IN_R_AND_D_ASSET | |||||
IN_ASSETISPRIORYEAR | Prior Year Transaction | GLO_IN_PRIOR_YR | CHAR | 1(0) | GLO_IN_PRIOR_YR | |||||
PT_VEHICLETYPEBYENERGY | Vehicle Type | GLO_PT_VEHICLETYPE | CHAR | 2(0) | GLO_PT_VEHICLETYPE | |||||
PT_VEHICLEISWITHOUTLIMIT | Is Vehicle Without Limit | GLO_PT_ISVEHICLEWOLIMIT | CHAR | 1(0) | ABAP_BOOL | |||||
PT_BIGREPAIRASSETLINK | Repair Asset Link | GLO_PT_REPAIRASSETLINK | CHAR | 8(0) | CHAR8 | |||||
PT_LANDASSETLINK | Land Asset Link | GLO_PT_LANDASSETLINK | CHAR | 8(0) | CHAR8 | |||||
PT_ASSETREPORTFORMCATEGORY | Asset Report Form Category | GLO_PT_ASSETREPFORMCAT | CHAR | 1(0) | GLO_PT_ASSETREPFORMCAT | |||||
PT_AMORTIZEDASSETISREEVALUATED | Is Amortized Asset Revaluated | GLO_PT_ISAMASSETREVAL | CHAR | 1(0) | ABAP_BOOL |
Search for further information about these or an SAP related objects