FAR_PSTRL_D_ROOT
Posting Rule Root - NON DRAFT
FAR_PSTRL_D_ROOT is an SAP database table in S/4HANA. Posting Rule Root - NON DRAFT. It contains 42 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_ARPostingRuleTP | view_entity | from | TRANSACTIONAL | Posting Rule Root |
Fields (42)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | client | abap.clnt | ||||
| KEY | postingruleuuid | far_pstrl_node_key | Rule Key | |||
| postingruledescription | far_pstrl_desc | Description | ||||
| debitcreditcode | epvoz_eb | Deb./Credit Key | ||||
| bankstatementshortid | kukey_eb | Short Key | ||||
| bankstatementitem | esnum_eb | Memo Record No. | ||||
| postingrule | far_pstrl_ruleid | Processing Rule ID | ||||
| postingruleversion | far_pstrl_ruleversionid | Version ID | ||||
| originalpostingruleuuid | far_pstrl_original_node_key | Original Rule Key | ||||
| sourcereprocessingruleuuid | far_pstrl_copy_node_key | Copy Node Key | ||||
| reprocessingrulecreationmode | far_pstrl_creation_mode | Creation Mode | ||||
| bankstatementitemsemantickey | far_pstrl_bs_shortid_and_items | BS Short Id and Item | ||||
| postingruledatamodelversion | far_datamodelversion | Data Model Version | ||||
| postingruleactiontype | far_pstrl_action | Action Type | ||||
| isobsolete | far_pstrl_is_rule_obsolete | Deprecated | ||||
| postingruleisautomatic | far_pstrl_is_rule_automatic | Automated Rule | ||||
| postingruleisdefault | far_pstrl_is_rule_default | |||||
| postingruleisactive | far_pstrl_is_active | Active Autom. Rule | ||||
| isauthorizeduser | far_pstrl_is_user_authorized | Is Authorized | ||||
| reprocessingruleisshared | far_pstrl_is_rule_shared | Shared Rule | ||||
| deprecateruleactionisenabled | far_is_action_enable | Action Enable | ||||
| postingruleismalrnproposal | far_pstrl_is_ml_proposal | ML Proposed Rule | ||||
| applicationlog | balognr | Log Number | ||||
| applicationloghandle | balloghndl | Handle | ||||
| assignedprocessorisignored | far_pstrl_ignore_prcsr_assgnd | Ignore Assigned Proc | ||||
| reprocessingrulecluster | far_pstrl_clusterid | Rule Cluster | ||||
| proposedpostgruleisdisregarded | far_pstrl_is_rule_disregarded | Hidden Template | ||||
| postingruletemplate | far_pstrl_templateid | Template ID | ||||
| accountingdocumenttype | farp_blart | Journal Entry Type | ||||
| reprocgrulepostgproceduretype | far_pstrl_postingproceduretype | Procedure Type | ||||
| reprocessingrulecreationvers | far_pstrl_rulecreationversion | Creation Version | ||||
| fallbackonacctpostingisenabled | far_pstrl_fallbac_on_acc_enabl | Fallback on Account | ||||
| reprocessingruleappltype | far_pstrl_rule_appl_type | Rule Appl Type | ||||
| reprocessingruleuploadstatus | far_pstrl_upload_status | Upload Status | ||||
| procgruleadvncdcndnisenabled | far_pstrl_adv_cond_enabled | |||||
| nmbrofmtchgopenbkstatementitms | far_rp_no_open_bs_itm_match_ru | Appl. Open Items | ||||
| nmbrofmtchghistlbkstmntitms | far_rp_no_mtchng_histl_bs_itm | Past Appl. Items | ||||
| nmbrofopenbkstatementitms | far_pstrl_no_open_bs_items | All Open Items | ||||
| numberofbankstatementitems | far_pstrl_no_bs_items | All Items | ||||
| numberofwrongpostings | far_rp_no_wrong_postings | Past Diff. Post. Itm | ||||
| procgrulemastertemplateuuid | far_pstrl_tmplt_node_key | |||||
| processingruletype | far_pstrl_rule_type |
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.
-- Posting Rule Root - NON DRAFT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAR_PSTRL_D_ROOT (
CLIENT, -- abap.clnt
POSTINGRULEUUID, -- Rule Key [far_pstrl_node_key]
POSTINGRULEDESCRIPTION, -- Description [far_pstrl_desc]
DEBITCREDITCODE, -- Deb./Credit Key [epvoz_eb]
BANKSTATEMENTSHORTID, -- Short Key [kukey_eb]
BANKSTATEMENTITEM, -- Memo Record No. [esnum_eb]
POSTINGRULE, -- Processing Rule ID [far_pstrl_ruleid]
POSTINGRULEVERSION, -- Version ID [far_pstrl_ruleversionid]
ORIGINALPOSTINGRULEUUID, -- Original Rule Key [far_pstrl_original_node_key]
SOURCEREPROCESSINGRULEUUID, -- Copy Node Key [far_pstrl_copy_node_key]
REPROCESSINGRULECREATIONMODE, -- Creation Mode [far_pstrl_creation_mode]
BANKSTATEMENTITEMSEMANTICKEY, -- BS Short Id and Item [far_pstrl_bs_shortid_and_items]
POSTINGRULEDATAMODELVERSION, -- Data Model Version [far_datamodelversion]
POSTINGRULEACTIONTYPE, -- Action Type [far_pstrl_action]
ISOBSOLETE, -- Deprecated [far_pstrl_is_rule_obsolete]
POSTINGRULEISAUTOMATIC, -- Automated Rule [far_pstrl_is_rule_automatic]
POSTINGRULEISDEFAULT, -- far_pstrl_is_rule_default
POSTINGRULEISACTIVE, -- Active Autom. Rule [far_pstrl_is_active]
ISAUTHORIZEDUSER, -- Is Authorized [far_pstrl_is_user_authorized]
REPROCESSINGRULEISSHARED, -- Shared Rule [far_pstrl_is_rule_shared]
DEPRECATERULEACTIONISENABLED, -- Action Enable [far_is_action_enable]
POSTINGRULEISMALRNPROPOSAL, -- ML Proposed Rule [far_pstrl_is_ml_proposal]
APPLICATIONLOG, -- Log Number [balognr]
APPLICATIONLOGHANDLE, -- Handle [balloghndl]
ASSIGNEDPROCESSORISIGNORED, -- Ignore Assigned Proc [far_pstrl_ignore_prcsr_assgnd]
REPROCESSINGRULECLUSTER, -- Rule Cluster [far_pstrl_clusterid]
PROPOSEDPOSTGRULEISDISREGARDED, -- Hidden Template [far_pstrl_is_rule_disregarded]
POSTINGRULETEMPLATE, -- Template ID [far_pstrl_templateid]
ACCOUNTINGDOCUMENTTYPE, -- Journal Entry Type [farp_blart]
REPROCGRULEPOSTGPROCEDURETYPE, -- Procedure Type [far_pstrl_postingproceduretype]
REPROCESSINGRULECREATIONVERS, -- Creation Version [far_pstrl_rulecreationversion]
FALLBACKONACCTPOSTINGISENABLED, -- Fallback on Account [far_pstrl_fallbac_on_acc_enabl]
REPROCESSINGRULEAPPLTYPE, -- Rule Appl Type [far_pstrl_rule_appl_type]
REPROCESSINGRULEUPLOADSTATUS, -- Upload Status [far_pstrl_upload_status]
PROCGRULEADVNCDCNDNISENABLED, -- far_pstrl_adv_cond_enabled
NMBROFMTCHGOPENBKSTATEMENTITMS, -- Appl. Open Items [far_rp_no_open_bs_itm_match_ru]
NMBROFMTCHGHISTLBKSTMNTITMS, -- Past Appl. Items [far_rp_no_mtchng_histl_bs_itm]
NMBROFOPENBKSTATEMENTITMS, -- All Open Items [far_pstrl_no_open_bs_items]
NUMBEROFBANKSTATEMENTITEMS, -- All Items [far_pstrl_no_bs_items]
NUMBEROFWRONGPOSTINGS, -- Past Diff. Post. Itm [far_rp_no_wrong_postings]
PROCGRULEMASTERTEMPLATEUUID, -- far_pstrl_tmplt_node_key
PROCESSINGRULETYPE, -- far_pstrl_rule_type
PRIMARY KEY (CLIENT, POSTINGRULEUUID)
);
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