AFAB is a standard Network and Activity Transparent Table in SAP Project Systems application, which stores Network - Relationships data. Below you can view the Table Structure, columns(fields), SAP Wiki pages, discussion threads, related TCodes, FMs, ABAP Reports, BW Datasources, and Authorization Objects for AFAB. You can use the transaction code SE16 to view the data in this table, and SE11 TCode for the table structure and definition.
AFAB — Meta Data
Description: | Network - Relationships |
Main Category: | Project Systems |
Sub Category: | Network and Activity |
Table type: | Transparent Table (TRANSP) |
AFAB — Table Structure, Fields(Columns) and Definitions
Position | Column Name | Description | Primary Key | Data Type | Length | Check Table |
---|---|---|---|---|---|---|
1 | MANDT | Client | X | CLNT | 3 | * |
2 | AUFPL_VOR | Routing number of operations in the order | X | NUMC | 10 | |
3 | APLZL_VOR | Internal counter | X | NUMC | 8 | |
4 | AUFPL_NCH | Routing number of operations in the order | X | NUMC | 10 | |
5 | APLZL_NCH | Internal counter | X | NUMC | 8 | |
6 | AOBAR | Relationship type | X | CHAR | 2 | |
7 | MIMAX | Indicates whether maximum time interval will be considered | X | CHAR | 1 | |
8 | .INCLUDE | 0 | ||||
9 | OBJNR | Object number | CHAR | 22 | ONR00 | |
10 | ZEINH | Time/Measurement Unit | UNIT | 3 | T006 | |
11 | DAUER | Duration | QUAN | 5 | ||
12 | DAUKZ | Duration indicator | CHAR | 1 | ||
13 | VORNC | Indicator: maintained after successor | CHAR | 1 | ||
14 | NCVOR | Indicates whether data after predecessor is maintained | CHAR | 1 | ||
15 | LOEKZ | Deletion flag for BOMs | CHAR | 1 | ||
16 | KALID | Factory Calendar | CHAR | 2 | TFACD | |
17 | PRZNT | PercentRate | NUMC | 3 | ||
18 | PROVG | Commission grp | CHAR | 1 | ||
19 | ARBID | Operating resources object ID | NUMC | 8 | ||
20 | WERKS | Plant | CHAR | 4 | T001W | |
21 | FSABD | Earliest start date for the relationship | DATS | 8 | ||
22 | FSABZ | Earliest start time for the relationship | TIMS | 6 | ||
23 | SSABD | Latest start date of the relationship | DATS | 8 | ||
24 | SSABZ | Latest start time of the relationship | TIMS | 6 | ||
25 | FEABD | Earliest finish date for the relationship | DATS | 8 | ||
26 | FEABZ | Earliest finish time for the relationship | TIMS | 6 | ||
27 | SEABD | Latest finish date of the relationship | DATS | 8 | ||
28 | SEABZ | Latest finish time of the relationship | TIMS | 6 | ||
29 | DAUTM | Character field of 9 digits | INT4 | 10 | ||
30 | AUCRE | Ind.: Relationship automatically generated | CHAR | 1 | ||
31 | DAUERMAX | Maximum time interval for relationship | QUAN | 5 | ||
32 | AENNR | Change Number | CHAR | 12 | * |
SAP Help, Wiki Resources, and Forum Discussions on AFAB
Click the above link for the full list of resources and help pages, only the first few are posted below
-
Depreciation posting run - AFAB | SCN
go to the IMG Asset Accounting and complete the account determination unter "Integration with General Ledger".
http://scn.sap.com/message/5966953
-
AFAB depreciation Run problem ? | SCN
I am facing one problem that , I am running my depreciatiion in Test Run it is running successfully.
http://scn.sap.com/message/8013392
-
Error while running AFAB | SCN
When creating the accounting document, the system could not find account 'Acc.dep. accnt.for ordinary depreciation' for company code 1000.
http://scn.sap.com/message/13689347
-
AFAB A.F | SCN
In Asset Accounting you can keep up to 2 years open. But if you have closed pervious year and not posted complete depreciation for previous year that is depreciation not posted in period 12 then you will not able to run AFAB.
http://scn.sap.com/message/8720322
-
AFAB - Error message no AA730 | SCN
When we run AFAB for the fiscal year 2009 12th period the system is prompting and error as shown below.
http://scn.sap.com/message/8982102
-
Depreciation run AFAB | SCN
hi friends,
while running AFAB,i am getting "test run completed succssfully
but no documents created in this run.
and i found no errors.
what can i do.
thanks in advance
regards
srinivas
http://scn.sap.com/message/7527596
-
Unable to post depreciation run - AFAB | SCN
I have a AUC with capitalisation date 16.06.2011. On 4.02.2011, I have wrongly depreciated the AUC. On realising my mistake, I changed the Depreciation key to 'MANU' from '0000' and posted a transaction with Transaction Type '640 - Unplanned depreciation on prior-year acquisitions. Now when I try to execute the depreciation run for period 1 - 2012, which was terminated, I am still getting the error...
http://scn.sap.com/message/11086639
-
Error AFAB: Period 000 | SCN
I know that the tables TABA and T093D-AFBLPE and T093D-AFBLGJ have to be empty. The problem is that the taba is empty, but the t093d isn't.
http://scn.sap.com/message/13721742
-
Depreciation calculation-AFAB | SCN
We have purchased an asset worth of 2,00,000/- on 01-01-2008 and got 40,000/- as subsidy from the govt. Now, while calculating depreciation system should calculate on only balance 1,60,000/-. Where i need to mention this subsidy amount 40,000/- on the configuration side, we dont want to pass any JV for 40,000/-. We need to maintain manually....how to achieve this?
http://scn.sap.com/message/6642869
-
No log Display - AFAB - Repeat Run - Test mode | SCN
I am unable to view any log while executing the AFAB for repeat run option. however, if I run in background, the system provides a spool containing the assets with values.
http://scn.sap.com/message/10973800
-
Error while running AFAB Balancing field "Profit Center" in line item yyy not filled
I am getting the following error while running AFAB the depreciation is "Balancing field "Profit Center" in line item 001 not filled".
http://scn.sap.com/message/13586731
Related Tables
TABLE | Description | Functional Area |
---|---|---|
AFBP | CIM order: Batch print requests | PP - Production Orders |
TABA | Depreciation posting documents | FI - Basic Functions |
KKS1 | CKKS + CKKT | CO - Product Cost Planning |
AFKO | Order header data PP orders | PP - Production Orders |
AFVC | Operation within an order | PP - Production Orders |
AUFK | Order master data | CO - Overhead Cost Orders |
AFVV | DB structure of the quantities/dates/values in the operation | PP - Production Orders |
Transaction Codes for SAP Table AFAB
TCODE | Description | Functional Area |
---|---|---|
AJAB | Year-End Closing | FI - Basic Functions |
SPRO | Customizing - Edit Project | Basis - Customizing Project Management (IMG) |
AW01N | Asset Explorer | FI - Basic Functions |
AFAR | Recalculate Depreciation | FI - Basic Functions |
AJRW | Fiscal Year Change | FI - Basic Functions |
AO90 | Account assignmt Acquisitions | FI - Asset Accounting |
ABAA | Unplanned depreciation | FI - Basic Functions |
FMs for SAP Table AFAB
FM | Description | Functional Area |
---|---|---|
TECHS_MAINTAIN | re | Cross Application - Engineering Change Management |
F4_FILENAME | F4 for filename / Filemanager support to locate file in a directory | PM - Plant Maintenance |
AM_AI_MEMORY | Arbeitsvorrat: Daten im Memory lesen/schreiben | BC - System Audit Information System |
WS_DELIVERY_UPDATE_2 | SD - Basic Functions | |
CSAP_MAT_BOM_READ | API St | Logistics - Bills of Material |
BDC_INSERT | Insert batch input transactions in batch input session | 700 - UI Services |
HR_PAYROLL_PERIODS_GET | Bestimmung der Abrechnungsperioden aus Datumsintervall und Periodenparam. | Personnel Time Management - Personnel Time Management |
RA_AFABUCHEN | Ermittlung der zu buchenden Abschreibung | FI - Basic Functions |
ABAP Reports for SAP Table AFAB
ABAP REPORT | Description | Functional Area |
---|---|---|
AW01N | Asset Explorer | FI - Basic Functions |
RAPOST2000 | Depreciation Posting Run | FI - Asset Accounting |
RECON | Include RECON | PP - Material Identification and Reconciliation |
RAAFAR00 | Recalculate Depreciation | FI - Basic Functions |
RAPERB2000 | Periodic Asset Postings | FI - Asset Accounting |
RAJAWE00 | Asset fiscal year change | FI - Basic Functions |
RAJABS00 | Year-end closing Asset Accounting | FI - Basic Functions |
ACEPSCALLBKEDR | CO-PA Derivation of Characteristic Values: Callbacks | FI - Accrual Engine |
BW Datasources for SAP Table AFAB
BW DATASOURCE | Description | Functional Area |
---|---|---|
0ASSET_AFAB_ATTR | Depreciation Area Real or Derived | FI - Asset Accounting |
0FI_AA_11 | FI-AA: Transactions | FI - Asset Accounting |
0FI_AA_12 | FI-AA: Posted Depreciations | FI - Asset Accounting |
0ASSET_AFAB_TEXT | Depreciation area real or derived | FI - Asset Accounting |
0FI_GL_4 | General Ledger: Line Items with Delta Extraction | FI - General Ledger Accounting |
0EMPLOYEE_ATTR | Employee | Personnel Mgmt - Personnel Administration |
0FI_GL_1 | General ledger: Transaction figures | FI - General Ledger Accounting |
Authorization Objects for SAP Table AFAB
AUTHORIZATION OBJECT | Description | Functional Area |
---|---|---|
WLM | Assignment of Articles to Layout Modules | |
ECM_CTXT | Engineering Change Management: Context | |
S_QUERY | SAP Query Authorization | |
CRM_CATT | Authorization for CRM eCATT Based Unit Testing | |
CMS_RBL | Authorization object for receivable in CMS | |
CMS_CAG | Authorization object for CAG | |
J_1ITDS | Authorization object for TDS transaction J1IN |
Most searched SAP Project System Tables
- Wbs Tables
- Reservation Tables
- Project Tables
- Wbs Element Tables
- Network Tables
- Network Activity Tables
- Wbs Element Status Tables
- Cj20n Tables
- Cji3 Tables
- Prps Tables
- Project Definition Tables
- Milestone Tables
- Dip Profile Tables
- Ps Budget Tables
- Vbbp Tables
- Cji3 Wbs Element Tables
- Psp Tables
- Matkl Tables
- Ihpa Tables
- Project System Tables
- Rpsco Tables
- Ps Posid Tables