FAR_PSTRL_AGL

Transparent Table Application Table
70 Fields 2 CDS Views

Posting Rule Action G/L Postings - NON DRAFT

FAR_PSTRL_AGL is an SAP database table in S/4HANA. Posting Rule Action G/L Postings - NON DRAFT. It contains 70 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_ARPostgRuleActnGL view_entity from EXTENSION Processing Rules GL Action - Extension
I_ARPostgRuleActnGLTP view_entity from COMPOSITE Posting Rule Action

Fields (70)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY postingruleactionuuid far_pstrla_node_key Action Key
postingruleuuid far_pstrl_node_key Rule Key
glaccount far_pstrl_glacc G/L Account
profitcenter far_pstrl_prctr Profit Center
costcenter far_pstrl_coctr Cost Center
businessarea gsber Business Area
salesorder kdauf Sales Order
budgetperiod fm_budget_period Budget Period
businessprocess fac_co_prznr Business Process
masterfixedasset anln1 Asset
fixedasset anln2 Sub-number
lineitemiscompleted kblerlkz Item Completed
financialmanagementarea fikrs FM Area
commitmentitem fm_fipex Commitment Item
functionalarea fkber Functional Area
fund bp_geber Fund
earmarkedfundsdocument kblnr_fi Earmarked funds
earmarkedfundsdocumentitem kblpos Document Item
scheduleline fac_kdein Sales Order Schedule
salesorderitem fac_kdpos Sales Order Item
costobject kstrg Cost Object
costctractivitytype lstar Activity Type
fundedprogram fm_measure Funded Program
projectnetwork nplnr Network
profitabilitysegment rkeobjnr Profit. segment
partnerbusinessarea fis_pargb Partner Bus. Area
partnerbudgetperiod fm_pbudget_period Par. BudPer
personnelnumber pernr_d Personnel No.
partnerfunctionalarea sfkber Partner FArea
partnerfund bp_p_geber Partner Fund
partnergrant gm_grant_partner Partner Grant
partnerprofitcenter fis_pprctr Partner Profit Center
wbselement ps_posid WBS Element
partnersegment fb_psegment Partner Segment
financialtransactiontype fis_rmvct Financial Transaction Type
segment fb_segment Segment
servicedocumentitem fco_srvdoc_id Service Document
servicedocumenttype fco_srvdoc_type Service Doc. Type
partnercompany rassc Trading Partner
partneraccountnumber jv_part Partner
documentitemtext sgtxt Text
assignmentreference dzuonr Assignment
taxcode mwskz Tax Code
taxdeterminationdate txdat Tax Date
taxratevaliditystartdate fot_txdat_from Tax Rate Valid-From
taxjurisdiction fis_txjcd Tax Jurisdiction
taxitemacctgdocitemref tax_posnr Tax doc. item number
iseutriangulardeal fac_xegdr EU Triangular Deal
deliveryofgoodsreportingcntry fac_egmld_bsez Reporting Ctry/Reg.
grossincometaxactivitycode j_1agicd_d Activity Code
grossincometaxregion regio Region
branchcode bcode Branch Code
purchasingdocument fis_ebeln Purchasing Document
purchasingdocumentitem ebelp Item
reference1idbybusinesspartner xref1 Reference Key 1
reference2idbybusinesspartner xref2 Reference Key 2
duecalculationbasedate farp_dzfbdt Baseline Date
valuedate farp_valut Value Date
housebank farp_hbkid House Bank
housebankaccount fac_hktid House Bank Account
isnotcashdiscountliable fac_xskrl Not Cash Disc Liable
paymentdifferencereason rstgr Reason Code
reference3idbybusinesspartner xref3 Reference Key 3
statecentralbankpaymentreason fac_lzbkz Central Bk Payt Rsn
supplyingcountry fac_landl Supplying Ctry/Reg.
orderid aufnr Order
processingruleitemdebitamount far_pstrli_debit_amount
processingruleitemcreditamount far_pstrli_credit_amount
procgruleitemamountpercent far_pstrli_amount_percent

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 Action G/L Postings - NON DRAFT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAR_PSTRL_AGL (
    CLIENT,                          -- abap.clnt
    POSTINGRULEACTIONUUID,           -- Action Key [far_pstrla_node_key]
    POSTINGRULEUUID,                 -- Rule Key [far_pstrl_node_key]
    GLACCOUNT,                       -- G/L Account [far_pstrl_glacc]
    PROFITCENTER,                    -- Profit Center [far_pstrl_prctr]
    COSTCENTER,                      -- Cost Center [far_pstrl_coctr]
    BUSINESSAREA,                    -- Business Area [gsber]
    SALESORDER,                      -- Sales Order [kdauf]
    BUDGETPERIOD,                    -- Budget Period [fm_budget_period]
    BUSINESSPROCESS,                 -- Business Process [fac_co_prznr]
    MASTERFIXEDASSET,                -- Asset [anln1]
    FIXEDASSET,                      -- Sub-number [anln2]
    LINEITEMISCOMPLETED,             -- Item Completed [kblerlkz]
    FINANCIALMANAGEMENTAREA,         -- FM Area [fikrs]
    COMMITMENTITEM,                  -- Commitment Item [fm_fipex]
    FUNCTIONALAREA,                  -- Functional Area [fkber]
    FUND,                            -- Fund [bp_geber]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked funds [kblnr_fi]
    EARMARKEDFUNDSDOCUMENTITEM,      -- Document Item [kblpos]
    SCHEDULELINE,                    -- Sales Order Schedule [fac_kdein]
    SALESORDERITEM,                  -- Sales Order Item [fac_kdpos]
    COSTOBJECT,                      -- Cost Object [kstrg]
    COSTCTRACTIVITYTYPE,             -- Activity Type [lstar]
    FUNDEDPROGRAM,                   -- Funded Program [fm_measure]
    PROJECTNETWORK,                  -- Network [nplnr]
    PROFITABILITYSEGMENT,            -- Profit. segment [rkeobjnr]
    PARTNERBUSINESSAREA,             -- Partner Bus. Area [fis_pargb]
    PARTNERBUDGETPERIOD,             -- Par. BudPer [fm_pbudget_period]
    PERSONNELNUMBER,                 -- Personnel No. [pernr_d]
    PARTNERFUNCTIONALAREA,           -- Partner FArea [sfkber]
    PARTNERFUND,                     -- Partner Fund [bp_p_geber]
    PARTNERGRANT,                    -- Partner Grant [gm_grant_partner]
    PARTNERPROFITCENTER,             -- Partner Profit Center [fis_pprctr]
    WBSELEMENT,                      -- WBS Element [ps_posid]
    PARTNERSEGMENT,                  -- Partner Segment [fb_psegment]
    FINANCIALTRANSACTIONTYPE,        -- Financial Transaction Type [fis_rmvct]
    SEGMENT,                         -- Segment [fb_segment]
    SERVICEDOCUMENTITEM,             -- Service Document [fco_srvdoc_id]
    SERVICEDOCUMENTTYPE,             -- Service Doc. Type [fco_srvdoc_type]
    PARTNERCOMPANY,                  -- Trading Partner [rassc]
    PARTNERACCOUNTNUMBER,            -- Partner [jv_part]
    DOCUMENTITEMTEXT,                -- Text [sgtxt]
    ASSIGNMENTREFERENCE,             -- Assignment [dzuonr]
    TAXCODE,                         -- Tax Code [mwskz]
    TAXDETERMINATIONDATE,            -- Tax Date [txdat]
    TAXRATEVALIDITYSTARTDATE,        -- Tax Rate Valid-From [fot_txdat_from]
    TAXJURISDICTION,                 -- Tax Jurisdiction [fis_txjcd]
    TAXITEMACCTGDOCITEMREF,          -- Tax doc. item number [tax_posnr]
    ISEUTRIANGULARDEAL,              -- EU Triangular Deal [fac_xegdr]
    DELIVERYOFGOODSREPORTINGCNTRY,   -- Reporting Ctry/Reg. [fac_egmld_bsez]
    GROSSINCOMETAXACTIVITYCODE,      -- Activity Code [j_1agicd_d]
    GROSSINCOMETAXREGION,            -- Region [regio]
    BRANCHCODE,                      -- Branch Code [bcode]
    PURCHASINGDOCUMENT,              -- Purchasing Document [fis_ebeln]
    PURCHASINGDOCUMENTITEM,          -- Item [ebelp]
    REFERENCE1IDBYBUSINESSPARTNER,   -- Reference Key 1 [xref1]
    REFERENCE2IDBYBUSINESSPARTNER,   -- Reference Key 2 [xref2]
    DUECALCULATIONBASEDATE,          -- Baseline Date [farp_dzfbdt]
    VALUEDATE,                       -- Value Date [farp_valut]
    HOUSEBANK,                       -- House Bank [farp_hbkid]
    HOUSEBANKACCOUNT,                -- House Bank Account [fac_hktid]
    ISNOTCASHDISCOUNTLIABLE,         -- Not Cash Disc Liable [fac_xskrl]
    PAYMENTDIFFERENCEREASON,         -- Reason Code [rstgr]
    REFERENCE3IDBYBUSINESSPARTNER,   -- Reference Key 3 [xref3]
    STATECENTRALBANKPAYMENTREASON,   -- Central Bk Payt Rsn [fac_lzbkz]
    SUPPLYINGCOUNTRY,                -- Supplying Ctry/Reg. [fac_landl]
    ORDERID,                         -- Order [aufnr]
    PROCESSINGRULEITEMDEBITAMOUNT,   -- far_pstrli_debit_amount
    PROCESSINGRULEITEMCREDITAMOUNT,  -- far_pstrli_credit_amount
    PROCGRULEITEMAMOUNTPERCENT,      -- far_pstrli_amount_percent
    PRIMARY KEY (CLIENT, POSTINGRULEACTIONUUID)
);

Learn More