FAAD_TR_SIMDOC
Draft table for entity R_FIXEDASSETSIMLNPOSTINGTP
FAAD_TR_SIMDOC is an SAP database table in S/4HANA. Draft table for entity R_FIXEDASSETSIMLNPOSTINGTP. It contains 87 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_FixedAssetSimlnPostingTP | view_entity | from | CONSUMPTION | Simulation for Fixed Asset Posting |
Fields (87)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | fixedassetpostinguuid | faa_tr_post_uuid | Posting UUID | |||
| KEY | referencedocumentitem | fins_awitem | Ref. Doc. Item | |||
| KEY | companycode | bukrs | Company Code | |||
| KEY | ledger | fins_ledger | Ledger | |||
| KEY | assetdepreciationarea | afaber | Deprec. Area | |||
| KEY | fiscalyear | gjahr | Fiscal Year | |||
| KEY | subledgeracctlineitemtype | fis_slalittype | Line Item Type | |||
| KEY | transactionsubitem | fins_subta | Sub Transaction | |||
| KEY | accountingdocumentitemref | posnr_acc | Position | |||
| referencedocumenttype | awtyp | Ref. procedure | ||||
| referencedocument | awref | Reference Doc. | ||||
| referencedocumentcontext | aworg | Refer. Org.Unit | ||||
| logicalsystem | awsys | Logical System | ||||
| glbusinesstransactiontype | vorgn | Transact. Type | ||||
| glaccount | racct | Account Number | ||||
| postingdate | budat | Posting Date | ||||
| assetvaluedate | bzdat | Asset Val. Date | ||||
| documentdate | bldat | Document Date | ||||
| fiscalperiod | poper | Posting Period | ||||
| debitcreditcode | shkzg | Debit/Credit | ||||
| financialaccounttype | koart | Account type | ||||
| quantity | menge_d | Quantity | ||||
| baseunit | meins | Base Unit | ||||
| depreciationfiscalperiod | peraf | Deprec. Period | ||||
| assetaccttransclassfctn | faa_movcat | Trans.Type Cat. | ||||
| assetclass | anlkl | Asset Class | ||||
| assetaccountdetermination | ktogr | Account Determ. | ||||
| partnermasterfixedasset | panl1 | Partner Asset | ||||
| partnerfixedasset | panl2 | Partner Sub-No. | ||||
| businesstransactiontype | glvor | Bus.transaction | ||||
| referencedocumentitemgroup | fis_awitgrp | Reference Document Item Group | ||||
| accountingdocumentitem | buzei | Item | ||||
| isreversal | fins_xreversing | Is Reversing | ||||
| isreversed | fins_xreversed | Is Reversed | ||||
| issettlement | fins_xsettling | Is Settling | ||||
| issettled | fins_xsettled | Is Settled | ||||
| predecessorreferencedoctype | fis_prec_awtyp | Predecessor Reference Document Type | ||||
| predecessorreferencedoccntxt | fis_prec_aworg | Predecessor Reference Document Context | ||||
| predecessorreferencedocument | fis_prec_awref | Predecessor Reference Document | ||||
| reversalreferencedocumentcntxt | fis_aworg_rev | Reversal Reference Document Context | ||||
| reversalreferencedocument | fis_awref_rev | Reversal Reference Document | ||||
| reversaltransactionsubitem | fins_subta_rev | Reversal Sub Trans | ||||
| documentreferenceid | xblnr1 | Reference | ||||
| documentitemtext | sgtxt | Text | ||||
| tradingpartner | vbund | Company ID | ||||
| assignmentreference | dzuonr | Assignment | ||||
| offsettingaccount | gkont | Offsetting Acct | ||||
| customer | kunnr | Customer | ||||
| supplier | lifnr | Supplier | ||||
| functionalarea | fkber | Functional Area | ||||
| controllingarea | kokrs | CO Area | ||||
| costcenter | kostl | Cost Center | ||||
| costctractivitytype | lstar | Activity Type | ||||
| orderid | aufnr | Order | ||||
| profitcenter | prctr | Profit Center | ||||
| segment | fb_segment | Segment | ||||
| partnerprofitcenter | pprctr | Partner PC | ||||
| fund | bp_geber | Fund | ||||
| grantid | gm_grant_nbr | Grant | ||||
| assetglpostingmethod | buhbkt | Ind.: G/L Acct. | ||||
| balancetransactioncurrency | fins_currt | Bal. Transac. Crcy | ||||
| amountinbalancetransaccrcy | fins_vtcur12 | Amnt in Bal Tr Crcy | ||||
| transactioncurrency | fins_currw | Transaction Currency | ||||
| amountintransactioncurrency | fins_vwcur12 | Amnt in Trans. Crcy | ||||
| companycodecurrency | fins_currh | CompanyCode Currency | ||||
| amountincompanycodecurrency | fins_vhcur12 | Amnt in Comp Cd Crcy | ||||
| globalcurrency | fins_currk | Global Currency | ||||
| amountinglobalcurrency | fins_vkcur12 | Amnt in Global Crcy | ||||
| functionalcurrency | fins_currfc | Functional Currency | ||||
| amountinfunctionalcurrency | fins_vfccur12 | Amount in FunctCrcy | ||||
| freedefinedcurrency1 | fins_curr1 | Free Defined Crcy 1 | ||||
| amountinfreedefinedcurrency1 | fins_vocur12 | Amount in Currency 1 | ||||
| freedefinedcurrency2 | fins_curr2 | Free Defined Crcy 2 | ||||
| amountinfreedefinedcurrency2 | fins_vvcur12 | Amount in Currency 2 | ||||
| freedefinedcurrency3 | fis_curr3 | Freely Defined Currency 3 | ||||
| amountinfreedefinedcurrency3 | fins_vbcur12 | Amount in Currency 3 | ||||
| freedefinedcurrency4 | fis_curr4 | Freely Defined Currency 4 | ||||
| amountinfreedefinedcurrency4 | fins_vccur12 | Amount in Currency 4 | ||||
| freedefinedcurrency5 | fis_curr5 | Freely Defined Currency 5 | ||||
| amountinfreedefinedcurrency5 | fins_vdcur12 | Amount in Currency 5 | ||||
| freedefinedcurrency6 | fis_curr6 | Freely Defined Currency 6 | ||||
| amountinfreedefinedcurrency6 | fins_vecur12 | Amount in Currency 6 | ||||
| freedefinedcurrency7 | fins_curr7 | Free Defined Crcy 7 | ||||
| amountinfreedefinedcurrency7 | fins_vfcur12 | Amount in Currency 7 | ||||
| freedefinedcurrency8 | fis_curr8 | Freely Defined Currency 8 | ||||
| amountinfreedefinedcurrency8 | fins_vgcur12 | Amount in Currency 8 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Draft table for entity R_FIXEDASSETSIMLNPOSTINGTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAD_TR_SIMDOC (
MANDT, -- Client [mandt]
FIXEDASSETPOSTINGUUID, -- Posting UUID [faa_tr_post_uuid]
REFERENCEDOCUMENTITEM, -- Ref. Doc. Item [fins_awitem]
COMPANYCODE, -- Company Code [bukrs]
LEDGER, -- Ledger [fins_ledger]
ASSETDEPRECIATIONAREA, -- Deprec. Area [afaber]
FISCALYEAR, -- Fiscal Year [gjahr]
SUBLEDGERACCTLINEITEMTYPE, -- Line Item Type [fis_slalittype]
TRANSACTIONSUBITEM, -- Sub Transaction [fins_subta]
ACCOUNTINGDOCUMENTITEMREF, -- Position [posnr_acc]
REFERENCEDOCUMENTTYPE, -- Ref. procedure [awtyp]
REFERENCEDOCUMENT, -- Reference Doc. [awref]
REFERENCEDOCUMENTCONTEXT, -- Refer. Org.Unit [aworg]
LOGICALSYSTEM, -- Logical System [awsys]
GLBUSINESSTRANSACTIONTYPE, -- Transact. Type [vorgn]
GLACCOUNT, -- Account Number [racct]
POSTINGDATE, -- Posting Date [budat]
ASSETVALUEDATE, -- Asset Val. Date [bzdat]
DOCUMENTDATE, -- Document Date [bldat]
FISCALPERIOD, -- Posting Period [poper]
DEBITCREDITCODE, -- Debit/Credit [shkzg]
FINANCIALACCOUNTTYPE, -- Account type [koart]
QUANTITY, -- Quantity [menge_d]
BASEUNIT, -- Base Unit [meins]
DEPRECIATIONFISCALPERIOD, -- Deprec. Period [peraf]
ASSETACCTTRANSCLASSFCTN, -- Trans.Type Cat. [faa_movcat]
ASSETCLASS, -- Asset Class [anlkl]
ASSETACCOUNTDETERMINATION, -- Account Determ. [ktogr]
PARTNERMASTERFIXEDASSET, -- Partner Asset [panl1]
PARTNERFIXEDASSET, -- Partner Sub-No. [panl2]
BUSINESSTRANSACTIONTYPE, -- Bus.transaction [glvor]
REFERENCEDOCUMENTITEMGROUP, -- Reference Document Item Group [fis_awitgrp]
ACCOUNTINGDOCUMENTITEM, -- Item [buzei]
ISREVERSAL, -- Is Reversing [fins_xreversing]
ISREVERSED, -- Is Reversed [fins_xreversed]
ISSETTLEMENT, -- Is Settling [fins_xsettling]
ISSETTLED, -- Is Settled [fins_xsettled]
PREDECESSORREFERENCEDOCTYPE, -- Predecessor Reference Document Type [fis_prec_awtyp]
PREDECESSORREFERENCEDOCCNTXT, -- Predecessor Reference Document Context [fis_prec_aworg]
PREDECESSORREFERENCEDOCUMENT, -- Predecessor Reference Document [fis_prec_awref]
REVERSALREFERENCEDOCUMENTCNTXT, -- Reversal Reference Document Context [fis_aworg_rev]
REVERSALREFERENCEDOCUMENT, -- Reversal Reference Document [fis_awref_rev]
REVERSALTRANSACTIONSUBITEM, -- Reversal Sub Trans [fins_subta_rev]
DOCUMENTREFERENCEID, -- Reference [xblnr1]
DOCUMENTITEMTEXT, -- Text [sgtxt]
TRADINGPARTNER, -- Company ID [vbund]
ASSIGNMENTREFERENCE, -- Assignment [dzuonr]
OFFSETTINGACCOUNT, -- Offsetting Acct [gkont]
CUSTOMER, -- Customer [kunnr]
SUPPLIER, -- Supplier [lifnr]
FUNCTIONALAREA, -- Functional Area [fkber]
CONTROLLINGAREA, -- CO Area [kokrs]
COSTCENTER, -- Cost Center [kostl]
COSTCTRACTIVITYTYPE, -- Activity Type [lstar]
ORDERID, -- Order [aufnr]
PROFITCENTER, -- Profit Center [prctr]
SEGMENT, -- Segment [fb_segment]
PARTNERPROFITCENTER, -- Partner PC [pprctr]
FUND, -- Fund [bp_geber]
GRANTID, -- Grant [gm_grant_nbr]
ASSETGLPOSTINGMETHOD, -- Ind.: G/L Acct. [buhbkt]
BALANCETRANSACTIONCURRENCY, -- Bal. Transac. Crcy [fins_currt]
AMOUNTINBALANCETRANSACCRCY, -- Amnt in Bal Tr Crcy [fins_vtcur12]
TRANSACTIONCURRENCY, -- Transaction Currency [fins_currw]
AMOUNTINTRANSACTIONCURRENCY, -- Amnt in Trans. Crcy [fins_vwcur12]
COMPANYCODECURRENCY, -- CompanyCode Currency [fins_currh]
AMOUNTINCOMPANYCODECURRENCY, -- Amnt in Comp Cd Crcy [fins_vhcur12]
GLOBALCURRENCY, -- Global Currency [fins_currk]
AMOUNTINGLOBALCURRENCY, -- Amnt in Global Crcy [fins_vkcur12]
FUNCTIONALCURRENCY, -- Functional Currency [fins_currfc]
AMOUNTINFUNCTIONALCURRENCY, -- Amount in FunctCrcy [fins_vfccur12]
FREEDEFINEDCURRENCY1, -- Free Defined Crcy 1 [fins_curr1]
AMOUNTINFREEDEFINEDCURRENCY1, -- Amount in Currency 1 [fins_vocur12]
FREEDEFINEDCURRENCY2, -- Free Defined Crcy 2 [fins_curr2]
AMOUNTINFREEDEFINEDCURRENCY2, -- Amount in Currency 2 [fins_vvcur12]
FREEDEFINEDCURRENCY3, -- Freely Defined Currency 3 [fis_curr3]
AMOUNTINFREEDEFINEDCURRENCY3, -- Amount in Currency 3 [fins_vbcur12]
FREEDEFINEDCURRENCY4, -- Freely Defined Currency 4 [fis_curr4]
AMOUNTINFREEDEFINEDCURRENCY4, -- Amount in Currency 4 [fins_vccur12]
FREEDEFINEDCURRENCY5, -- Freely Defined Currency 5 [fis_curr5]
AMOUNTINFREEDEFINEDCURRENCY5, -- Amount in Currency 5 [fins_vdcur12]
FREEDEFINEDCURRENCY6, -- Freely Defined Currency 6 [fis_curr6]
AMOUNTINFREEDEFINEDCURRENCY6, -- Amount in Currency 6 [fins_vecur12]
FREEDEFINEDCURRENCY7, -- Free Defined Crcy 7 [fins_curr7]
AMOUNTINFREEDEFINEDCURRENCY7, -- Amount in Currency 7 [fins_vfcur12]
FREEDEFINEDCURRENCY8, -- Freely Defined Currency 8 [fis_curr8]
AMOUNTINFREEDEFINEDCURRENCY8, -- Amount in Currency 8 [fins_vgcur12]
PRIMARY KEY (MANDT, FIXEDASSETPOSTINGUUID, REFERENCEDOCUMENTITEM, COMPANYCODE, LEDGER, ASSETDEPRECIATIONAREA, FISCALYEAR, SUBLEDGERACCTLINEITEMTYPE, TRANSACTIONSUBITEM, ACCOUNTINGDOCUMENTITEMREF)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA