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 93 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 (93)
| 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 | ||||
| draftentitycreationdatetime | SYCH_BDL_DRAFT_CREATED_AT | Created | ||||
| draftentitylastchangedatetime | SYCH_BDL_DRAFT_LAST_CHANGED_AT | Changed | ||||
| draftadministrativedatauuid | SYCH_BDL_DRAFT_ADMIN_UUID | UUID | ||||
| draftentityoperationcode | SYCH_BDL_DRAFT_OPERATION_CODE | Draft - Operation Code | ||||
| hasactiveentity | SYCH_BDL_DRAFT_HASACTIVE | Has active | ||||
| draftfieldchanges | SYCH_BDL_DRAFT_FIELD_CHANGES | Field Changes |
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]
DRAFTENTITYCREATIONDATETIME, -- Created [SYCH_BDL_DRAFT_CREATED_AT]
DRAFTENTITYLASTCHANGEDATETIME, -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
DRAFTADMINISTRATIVEDATAUUID, -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
DRAFTENTITYOPERATIONCODE, -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
HASACTIVEENTITY, -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
DRAFTFIELDCHANGES, -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
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