C_ARPostgRuleActnGL

DDL: C_ARPOSTGRULEACTNGL Type: view_entity CONSUMPTION Package: ODATA_AR_POSTING_RULES
69 Fields 1 Data Sources 3 OData Services

Posting Rule Action Consumption

C_ARPostgRuleActnGL is a Consumption CDS View that provides data about "Posting Rule Action Consumption" in SAP S/4HANA. It reads from 1 data source (I_ARPostgRuleActnGLTP) and exposes 69 fields with key field PostingRuleActionUUID. It is exposed through 3 OData services (ASQL_F3398, ASQL_F3555, ASQL_F8134). Part of development package ODATA_AR_POSTING_RULES.

Data Sources (1)

SourceAliasJoin Type
I_ARPostgRuleActnGLTP I_ARPostgRuleActnGLTP projection

Annotations (10)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
UI.textArrangement #TEXT_LAST view
Metadata.allowExtensions true view
Search.searchable false view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #CONSUMPTION view
EndUserText.label Posting Rule Action Consumption view
AccessControl.authorizationCheck #MANDATORY view

OData Services (3)

ServiceBindingVersionContractRelease
ASQL_F3398 ASQL_F3398 C2 NOT_RELEASED
ASQL_F3555 ASQL_F3555 C2 NOT_RELEASED
ASQL_F8134 ASQL_F8134 C2 NOT_RELEASED

Fields (69)

KeyFieldSource TableSource FieldDescription
KEY PostingRuleActionUUID ActionGL PostingRuleActionUUID Action Key
PostingRuleUUID ActionGL PostingRuleUUID Rule Key
GLAccount ActionGL GLAccount General Ledger
ProfitCenter ActionGL ProfitCenter Profit Center
CostCenter ActionGL CostCenter Cost Center
BusinessArea ActionGL BusinessArea Business Area
SalesOrder ActionGL SalesOrder SD Document
BudgetPeriod ActionGL BudgetPeriod Budget Period
BusinessProcess ActionGL BusinessProcess Business Process
MasterFixedAsset ActionGL MasterFixedAsset Fixed Asset
FixedAsset ActionGL FixedAsset Sub-number
LineItemIsCompleted ActionGL LineItemIsCompleted Item Completed
FinancialManagementArea ActionGL FinancialManagementArea Financial Management Area
CommitmentItem ActionGL CommitmentItem Commitment item
FunctionalArea ActionGL FunctionalArea Sendr Fctl Area
EarmarkedFundsDocument ActionGL EarmarkedFundsDocument Earmarked Funds
EarmarkedFundsDocumentItem ActionGL EarmarkedFundsDocumentItem Document Item
Fund ActionGL Fund Sender Fund
ScheduleLine ActionGL ScheduleLine Schedule Line
SalesOrderItem ActionGL SalesOrderItem Sales Order Item
CostObject ActionGL CostObject Cost Object
FundedProgram ActionGL FundedProgram Funded Program
ProjectNetwork ActionGL ProjectNetwork Order
ProfitabilitySegment ActionGL ProfitabilitySegment Profitability Segment Number
PartnerBusinessArea ActionGL PartnerBusinessArea Trdg Part.BA
PartnerBudgetPeriod ActionGL PartnerBudgetPeriod Partner Budget Period
PersonnelNumber ActionGL PersonnelNumber Personnel No.
PartnerFunctionalArea ActionGL PartnerFunctionalArea Partner Functional Area
PartnerFund ActionGL PartnerFund Receiver Fund
PartnerGrant ActionGL PartnerGrant Receiver Grant
PartnerProfitCenter ActionGL PartnerProfitCenter Profit Center
WBSElement ActionGL WBSElement WBS Internal ID
PartnerSegment ActionGL PartnerSegment Partner Segment
FinancialTransactionType ActionGL FinancialTransactionType Transact. Type
Segment ActionGL Segment Segment number
ServiceDocumentItem ActionGL ServiceDocumentItem Service Document
ServiceDocumentType ActionGL ServiceDocumentType Service Document Type
PartnerCompany ActionGL PartnerCompany Trading Partner Number
PartnerAccountNumber ActionGL PartnerAccountNumber Partner
DocumentItemText ActionGL DocumentItemText Text
AssignmentReference ActionGL AssignmentReference Assignment Reference
TaxCode ActionGL TaxCode Tax Code
TaxDeterminationDate ActionGL TaxDeterminationDate Tx Determination Dte
TaxRateValidityStartDate ActionGL TaxRateValidityStartDate Tax Rate Validity Start Date
TaxJurisdiction ActionGL TaxJurisdiction Tax Jurisdiction
TaxItemAcctgDocItemRef ActionGL TaxItemAcctgDocItemRef Tax Document Item Number
IsEUTriangularDeal ActionGL IsEUTriangularDeal Is EU Triangular Deal
DeliveryOfGoodsReportingCntry ActionGL DeliveryOfGoodsReportingCntry Reporting Country/Region
GrossIncomeTaxActivityCode ActionGL GrossIncomeTaxActivityCode Gross Income Tax Activity Code
GrossIncomeTaxRegion ActionGL GrossIncomeTaxRegion Region
BranchCode ActionGL BranchCode Branch Code
PurchasingDocument ActionGL PurchasingDocument Purchasing Document
PurchasingDocumentItem ActionGL PurchasingDocumentItem Purchasing Doc. Item
Reference1IDByBusinessPartner ActionGL Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner ActionGL Reference2IDByBusinessPartner Reference Key 2
DueCalculationBaseDate ActionGL DueCalculationBaseDate Baseline Payment Date
ValueDate ActionGL ValueDate Value Date
HouseBank ActionGL HouseBank House Bank
HouseBankAccount ActionGL HouseBankAccount House Bank Account
IsNotCashDiscountLiable ActionGL IsNotCashDiscountLiable Not Cash Discount Liable
PaymentDifferenceReason ActionGL PaymentDifferenceReason Reason Code
Reference3IDByBusinessPartner ActionGL Reference3IDByBusinessPartner Reference Key 3
StateCentralBankPaymentReason ActionGL StateCentralBankPaymentReason Central Bank Payment Reason
SupplyingCountry ActionGL SupplyingCountry Supplying Country/Region
OrderID ActionGL OrderID Order ID
ProcessingRuleItemDebitAmount ActionGL ProcessingRuleItemDebitAmount
ProcessingRuleItemCreditAmount ActionGL ProcessingRuleItemCreditAmount
ProcgRuleItemAmountPercent ActionGL ProcgRuleItemAmountPercent
_RuleredirectedtoparentC_ARPostingRule

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ARPostgRuleActnGL.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_ARPostgRuleActnGL AS
SELECT
  ActionGL.PostingRuleActionUUID AS PostingRuleActionUUID,
  ActionGL.PostingRuleUUID AS PostingRuleUUID,
  ActionGL.GLAccount AS GLAccount,
  ActionGL.ProfitCenter AS ProfitCenter,
  ActionGL.CostCenter AS CostCenter,
  ActionGL.BusinessArea AS BusinessArea,
  ActionGL.SalesOrder AS SalesOrder,
  ActionGL.BudgetPeriod AS BudgetPeriod,
  ActionGL.BusinessProcess AS BusinessProcess,
  ActionGL.MasterFixedAsset AS MasterFixedAsset,
  ActionGL.FixedAsset AS FixedAsset,
  ActionGL.LineItemIsCompleted AS LineItemIsCompleted,
  ActionGL.FinancialManagementArea AS FinancialManagementArea,
  ActionGL.CommitmentItem AS CommitmentItem,
  ActionGL.FunctionalArea AS FunctionalArea,
  ActionGL.EarmarkedFundsDocument AS EarmarkedFundsDocument,
  ActionGL.EarmarkedFundsDocumentItem AS EarmarkedFundsDocumentItem,
  ActionGL.Fund AS Fund,
  ActionGL.ScheduleLine AS ScheduleLine,
  ActionGL.SalesOrderItem AS SalesOrderItem,
  ActionGL.CostObject AS CostObject,
  ActionGL.FundedProgram AS FundedProgram,
  ActionGL.ProjectNetwork AS ProjectNetwork,
  ActionGL.ProfitabilitySegment AS ProfitabilitySegment,
  ActionGL.PartnerBusinessArea AS PartnerBusinessArea,
  ActionGL.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  ActionGL.PersonnelNumber AS PersonnelNumber,
  ActionGL.PartnerFunctionalArea AS PartnerFunctionalArea,
  ActionGL.PartnerFund AS PartnerFund,
  ActionGL.PartnerGrant AS PartnerGrant,
  ActionGL.PartnerProfitCenter AS PartnerProfitCenter,
  ActionGL.WBSElement AS WBSElement,
  ActionGL.PartnerSegment AS PartnerSegment,
  ActionGL.FinancialTransactionType AS FinancialTransactionType,
  ActionGL.Segment AS Segment,
  ActionGL.ServiceDocumentItem AS ServiceDocumentItem,
  ActionGL.ServiceDocumentType AS ServiceDocumentType,
  ActionGL.PartnerCompany AS PartnerCompany,
  ActionGL.PartnerAccountNumber AS PartnerAccountNumber,
  ActionGL.DocumentItemText AS DocumentItemText,
  ActionGL.AssignmentReference AS AssignmentReference,
  ActionGL.TaxCode AS TaxCode,
  ActionGL.TaxDeterminationDate AS TaxDeterminationDate,
  ActionGL.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  ActionGL.TaxJurisdiction AS TaxJurisdiction,
  ActionGL.TaxItemAcctgDocItemRef AS TaxItemAcctgDocItemRef,
  ActionGL.IsEUTriangularDeal AS IsEUTriangularDeal,
  ActionGL.DeliveryOfGoodsReportingCntry AS DeliveryOfGoodsReportingCntry,
  ActionGL.GrossIncomeTaxActivityCode AS GrossIncomeTaxActivityCode,
  ActionGL.GrossIncomeTaxRegion AS GrossIncomeTaxRegion,
  ActionGL.BranchCode AS BranchCode,
  ActionGL.PurchasingDocument AS PurchasingDocument,
  ActionGL.PurchasingDocumentItem AS PurchasingDocumentItem,
  ActionGL.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  ActionGL.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  ActionGL.DueCalculationBaseDate AS DueCalculationBaseDate,
  ActionGL.ValueDate AS ValueDate,
  ActionGL.HouseBank AS HouseBank,
  ActionGL.HouseBankAccount AS HouseBankAccount,
  ActionGL.IsNotCashDiscountLiable AS IsNotCashDiscountLiable,
  ActionGL.PaymentDifferenceReason AS PaymentDifferenceReason,
  ActionGL.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  ActionGL.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  ActionGL.SupplyingCountry AS SupplyingCountry,
  ActionGL.OrderID AS OrderID,
  ActionGL.ProcessingRuleItemDebitAmount AS ProcessingRuleItemDebitAmount,
  ActionGL.ProcessingRuleItemCreditAmount AS ProcessingRuleItemCreditAmount,
  ActionGL.ProcgRuleItemAmountPercent AS ProcgRuleItemAmountPercent
FROM I_ARPostgRuleActnGLTP
;

Learn More