/PF1/DB_ACBL_HDR
IHB Account Balancing Header
/PF1/DB_ACBL_HDR is an SAP database table in S/4HANA. IHB Account Balancing Header. It contains 23 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_IHBAccountBalancing | view_entity | from | BASIC | IHB Account Balancing |
Fields (23)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | MANDT | Client | |||
| KEY | bal_hdr_uuid | SYSUUID_X16 | UUID | |||
| account_uuid | /PF1/DTE_IHB_ACCT_ID | Account ID | ||||
| close_year | /PF1/DTE_IHB_CLOSE_YEAR | Balancing Per. Year | ||||
| close_nr | /PF1/DTE_IHB_CLOSE_NR | Balanci.Period No. | ||||
| close_nradd | /PF1/DTE_IHB_CLOSE_NRADD | Add. Bal.Per.No. | ||||
| currency | /PF1/DTE_IHB_ACC_CURRENCY | Account Currency | ||||
| start_date | /PF1/DTE_IHB_START_DATE | Start Date | ||||
| end_date | /PF1/DTE_IHB_END_DATE | End Date | ||||
| end_date_i | /PF1/DTE_IHB_END_DATE_I | Int. End Date | ||||
| value_date | /PF1/DTE_IHB_BAL_VALUE_DATE | Value date | ||||
| post_date | /PF1/DTE_IHB_BAL_POST_DATE | Posting date | ||||
| debit_interest | /PF1/DTE_IHB_DEBIT_INTEREST | Amount Debit Int. | ||||
| credit_interest | /PF1/DTE_IHB_CREDIT_INTEREST | Amt.Cred.Int. | ||||
| overdr_interest | /PF1/DTE_IHB_OVERDR_INTEREST | Amt.Overd.Int. | ||||
| item_charge | /PF1/DTE_IHB_ITEM_CHARGE | Amt. Item Charge | ||||
| acc_maint_charge | /PF1/DTE_IHB_ACC_MAINT_CHARGE | Amt. IHB Acct.Charge | ||||
| balance | /PF1/DTE_IHB_ACC_BALANCE | Balance | ||||
| bal_notif_status | /PF1/DTE_IHB_BAL_NOT_STATUS | Notification Status | ||||
| int_scale_notif_status | /PF1/DTE_IHB_INT_SC_NOT_STATUS | Notification Status | ||||
| changed_at | /PF1/DTE_IHB_CHANGED_AT | Time Changed | ||||
| archive_status | AFX_DTE_ARCHIVE_STATUS | Arch. Status | ||||
| archive_flud | AFX_DTE_ARCHIVE_FLUD | Resubmission Date |
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.
-- IHB Account Balancing Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PF1/DB_ACBL_HDR (
CLIENT, -- Client [MANDT]
BAL_HDR_UUID, -- UUID [SYSUUID_X16]
ACCOUNT_UUID, -- Account ID [/PF1/DTE_IHB_ACCT_ID]
CLOSE_YEAR, -- Balancing Per. Year [/PF1/DTE_IHB_CLOSE_YEAR]
CLOSE_NR, -- Balanci.Period No. [/PF1/DTE_IHB_CLOSE_NR]
CLOSE_NRADD, -- Add. Bal.Per.No. [/PF1/DTE_IHB_CLOSE_NRADD]
CURRENCY, -- Account Currency [/PF1/DTE_IHB_ACC_CURRENCY]
START_DATE, -- Start Date [/PF1/DTE_IHB_START_DATE]
END_DATE, -- End Date [/PF1/DTE_IHB_END_DATE]
END_DATE_I, -- Int. End Date [/PF1/DTE_IHB_END_DATE_I]
VALUE_DATE, -- Value date [/PF1/DTE_IHB_BAL_VALUE_DATE]
POST_DATE, -- Posting date [/PF1/DTE_IHB_BAL_POST_DATE]
DEBIT_INTEREST, -- Amount Debit Int. [/PF1/DTE_IHB_DEBIT_INTEREST]
CREDIT_INTEREST, -- Amt.Cred.Int. [/PF1/DTE_IHB_CREDIT_INTEREST]
OVERDR_INTEREST, -- Amt.Overd.Int. [/PF1/DTE_IHB_OVERDR_INTEREST]
ITEM_CHARGE, -- Amt. Item Charge [/PF1/DTE_IHB_ITEM_CHARGE]
ACC_MAINT_CHARGE, -- Amt. IHB Acct.Charge [/PF1/DTE_IHB_ACC_MAINT_CHARGE]
BALANCE, -- Balance [/PF1/DTE_IHB_ACC_BALANCE]
BAL_NOTIF_STATUS, -- Notification Status [/PF1/DTE_IHB_BAL_NOT_STATUS]
INT_SCALE_NOTIF_STATUS, -- Notification Status [/PF1/DTE_IHB_INT_SC_NOT_STATUS]
CHANGED_AT, -- Time Changed [/PF1/DTE_IHB_CHANGED_AT]
ARCHIVE_STATUS, -- Arch. Status [AFX_DTE_ARCHIVE_STATUS]
ARCHIVE_FLUD, -- Resubmission Date [AFX_DTE_ARCHIVE_FLUD]
PRIMARY KEY (CLIENT, BAL_HDR_UUID)
);
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