/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 19 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 (19)
| 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 | ||||
| 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]
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