/PRA/ACC_DOC_HDR
Revenue Accounting Document Header
/PRA/ACC_DOC_HDR is an SAP database table in S/4HANA. Revenue Accounting Document Header. It contains 23 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_PRAAccountingDocumentHdrDet | view | from | BASIC | PRA Accounting Document Header |
| I_PRAAccountingDocumentHeader | view | from | BASIC | PRA Accounting Document Header |
Fields (23)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bukrs | BUKRS | Company Code | |||
| KEY | acct_period | /PRA/ACCOUNTING_PERIOD | Acct Period | |||
| KEY | doc_no | /PRA/ACCOUNTING_DOC_NO | Document No. | |||
| doc_type | /PRA/DOC_TYPE | Doc Type | ||||
| ref_key | /PRA/SRC_REF_KEY | Source Reference Key | ||||
| system_src | OIU_APPLICATION | Application | ||||
| debit_amt | /PRA/DEBIT_AMT | Debit Amount | ||||
| credit_amt | /PRA/CREDIT_AMT | Credit Amount | ||||
| stat_amt | /PRA/STAT_AMT | Sts Amount | ||||
| doc_status | /PRA/ACCT_DOC_STATUS | Acctg Doc Sts | ||||
| rvrs_doc_fl | /PRA/ACCT_REVERSE_FLAG | Reverse Flag | ||||
| xcc_key | /PRA/XCOMPKEY | Cross Comp Key | ||||
| total_rec_cnt | /PRA/ACCT_DOC_TOTAL_LINES | Total Lines | ||||
| rej_rec_cnt | /PRA/ACCT_DOC_TOTAL_REJ_LINES | Total Reject Lines | ||||
| post_dt | /PRA/ACCT_DOC_POST_DT | Posting Date | ||||
| doc_dt | /PRA/ACCT_DOC_DT | Document Date | ||||
| document_desc | /PRA/ACCT_DOC_DESC | Doc Description | ||||
| oiu_cruser | ERNAM | Created By | ||||
| oiu_timestamp | TZNTSTMPS | Time Stamp | ||||
| change_user | AENAM | Changed By | ||||
| change_timestamp | TZNTSTMPS | Time Stamp | ||||
| aging_status | FLAG | Indicator |
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.
-- Revenue Accounting Document Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PRA/ACC_DOC_HDR (
MANDT, -- Client [MANDT]
BUKRS, -- Company Code [BUKRS]
ACCT_PERIOD, -- Acct Period [/PRA/ACCOUNTING_PERIOD]
DOC_NO, -- Document No. [/PRA/ACCOUNTING_DOC_NO]
DOC_TYPE, -- Doc Type [/PRA/DOC_TYPE]
REF_KEY, -- Source Reference Key [/PRA/SRC_REF_KEY]
SYSTEM_SRC, -- Application [OIU_APPLICATION]
DEBIT_AMT, -- Debit Amount [/PRA/DEBIT_AMT]
CREDIT_AMT, -- Credit Amount [/PRA/CREDIT_AMT]
STAT_AMT, -- Sts Amount [/PRA/STAT_AMT]
DOC_STATUS, -- Acctg Doc Sts [/PRA/ACCT_DOC_STATUS]
RVRS_DOC_FL, -- Reverse Flag [/PRA/ACCT_REVERSE_FLAG]
XCC_KEY, -- Cross Comp Key [/PRA/XCOMPKEY]
TOTAL_REC_CNT, -- Total Lines [/PRA/ACCT_DOC_TOTAL_LINES]
REJ_REC_CNT, -- Total Reject Lines [/PRA/ACCT_DOC_TOTAL_REJ_LINES]
POST_DT, -- Posting Date [/PRA/ACCT_DOC_POST_DT]
DOC_DT, -- Document Date [/PRA/ACCT_DOC_DT]
DOCUMENT_DESC, -- Doc Description [/PRA/ACCT_DOC_DESC]
OIU_CRUSER, -- Created By [ERNAM]
OIU_TIMESTAMP, -- Time Stamp [TZNTSTMPS]
CHANGE_USER, -- Changed By [AENAM]
CHANGE_TIMESTAMP, -- Time Stamp [TZNTSTMPS]
AGING_STATUS, -- Indicator [FLAG]
PRIMARY KEY (MANDT, BUKRS, ACCT_PERIOD, DOC_NO)
);
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