FAR_PSTRL_AGL

Transparent Table Application Table
68 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 68 fields. 2 CDS views read from this table.

CDS Views using this table (2)

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

Fields (68)

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
networkactivity vornr Activity

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]
    NETWORKACTIVITY,                -- Activity [vornr]
    PRIMARY KEY (CLIENT, POSTINGRULEACTIONUUID)
);

Learn More