I_ARPostgRuleActnGLTP

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 I_ARPostgRuleActnGLTP.
-- 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 I_ARPostgRuleActnGLTP AS
SELECT
  Action.postingruleactionuuid AS PostingRuleActionUUID,
  Action.postingruleuuid AS PostingRuleUUID,
  Action.glaccount AS GLAccount,
  Action.profitcenter AS ProfitCenter,
  Action.costcenter AS CostCenter,
  Action.businessarea AS BusinessArea,
  Action.salesorder AS SalesOrder,
  Action.budgetperiod AS BudgetPeriod,
  Action.businessprocess AS BusinessProcess,
  Action.masterfixedasset AS MasterFixedAsset,
  Action.fixedasset AS FixedAsset,
  Action.lineitemiscompleted AS LineItemIsCompleted,
  Action.financialmanagementarea AS FinancialManagementArea,
  Action.commitmentitem AS CommitmentItem,
  Action.functionalarea AS FunctionalArea,
  Action.fund AS Fund,
  Action.earmarkedfundsdocument AS EarmarkedFundsDocument,
  Action.earmarkedfundsdocumentitem AS EarmarkedFundsDocumentItem,
  Action.scheduleline AS ScheduleLine,
  Action.salesorderitem AS SalesOrderItem,
  Action.costobject AS CostObject,
  Action.fundedprogram AS FundedProgram,
  Action.projectnetwork AS ProjectNetwork,
  Action.profitabilitysegment AS ProfitabilitySegment,
  Action.partnerbusinessarea AS PartnerBusinessArea,
  Action.partnerbudgetperiod AS PartnerBudgetPeriod,
  Action.personnelnumber AS PersonnelNumber,
  Action.partnerfunctionalarea AS PartnerFunctionalArea,
  Action.partnerfund AS PartnerFund,
  Action.partnergrant AS PartnerGrant,
  Action.partnerprofitcenter AS PartnerProfitCenter,
  Action.wbselement AS WBSElement,
  Action.partnersegment AS PartnerSegment,
  Action.financialtransactiontype AS FinancialTransactionType,
  Action.segment AS Segment,
  Action.servicedocumentitem AS ServiceDocumentItem,
  Action.servicedocumenttype AS ServiceDocumentType,
  Action.partnercompany AS PartnerCompany,
  Action.partneraccountnumber AS PartnerAccountNumber,
  cast(Action.documentitemtext as farp_sgtxt_2) AS DocumentItemText,
  Action.assignmentreference AS AssignmentReference,
  Action.taxcode AS TaxCode,
  Action.taxdeterminationdate AS TaxDeterminationDate,
  Action.taxratevaliditystartdate AS TaxRateValidityStartDate,
  Action.taxjurisdiction AS TaxJurisdiction,
  Action.taxitemacctgdocitemref AS TaxItemAcctgDocItemRef,
  Action.iseutriangulardeal AS IsEUTriangularDeal,
  Action.deliveryofgoodsreportingcntry AS DeliveryOfGoodsReportingCntry,
  Action.grossincometaxactivitycode AS GrossIncomeTaxActivityCode,
  Action.grossincometaxregion AS GrossIncomeTaxRegion,
  Action.branchcode AS BranchCode,
  Action.purchasingdocument AS PurchasingDocument,
  Action.purchasingdocumentitem AS PurchasingDocumentItem,
  Action.reference1idbybusinesspartner AS Reference1IDByBusinessPartner,
  Action.reference2idbybusinesspartner AS Reference2IDByBusinessPartner,
  Action.duecalculationbasedate AS DueCalculationBaseDate,
  Action.valuedate AS ValueDate,
  Action.housebank AS HouseBank,
  Action.housebankaccount AS HouseBankAccount,
  Action.isnotcashdiscountliable AS IsNotCashDiscountLiable,
  Action.paymentdifferencereason AS PaymentDifferenceReason,
  Action.reference3idbybusinesspartner AS Reference3IDByBusinessPartner,
  Action.statecentralbankpaymentreason AS StateCentralBankPaymentReason,
  Action.supplyingcountry AS SupplyingCountry,
  Action.orderid AS OrderID,
  Action.processingruleitemdebitamount AS ProcessingRuleItemDebitAmount,
  Action.processingruleitemcreditamount AS ProcessingRuleItemCreditAmount,
  Action.procgruleitemamountpercent AS ProcgRuleItemAmountPercent
FROM far_pstrl_agl AS Action
LEFT OUTER JOIN E_ARPostgRuleActnGL AS _Extension ON PostingRuleActionUUID = _Extension.PostingRuleActionUUID  -- association [1]
;