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 38 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 (38)
| 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. | ||||
| lastchangedatetime | TIMESTAMPL | Time Stamp | ||||
| lastchangedbyuser | UNAME | User Name | ||||
| createdbyuser | UNAME | User Name | ||||
| creationdatetime | TIMESTAMPL | Time Stamp | ||||
| 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 | ||||
| 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 | ||||
| nmbrofmtchgopenbkstatementitms | FAR_RP_NO_OPEN_BS_ITM_MATCH_RU | Appl. Open Items | ||||
| 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 |
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]
LASTCHANGEDATETIME, -- Time Stamp [TIMESTAMPL]
LASTCHANGEDBYUSER, -- User Name [UNAME]
CREATEDBYUSER, -- User Name [UNAME]
CREATIONDATETIME, -- Time Stamp [TIMESTAMPL]
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]
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]
NMBROFMTCHGOPENBKSTATEMENTITMS, -- Appl. Open Items [FAR_RP_NO_OPEN_BS_ITM_MATCH_RU]
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]
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