P_APLineItem_3

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 P_APLineItem_3.
-- 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.
-- Parameters: P_KeyDate : vdm_v_key_date

CREATE VIEW P_APLineItem_3 AS
SELECT
  _Item.CompanyCode AS CompanyCode,
  _Item.AccountingDocument AS AccountingDocument,
  _Item.FiscalYear AS FiscalYear,
  _Item.AccountingDocumentItem AS AccountingDocumentItem,
  $parameters.P_KeyDate AS KEYDT2,
  case when _Item.SpecialGLTransactionType = 'A' and _Item.SpecialGLCode != 'F' then 'X' else '' end as DPNOTDUE AS SpecialGLCodeFthenXelseendasDPNOTDUE,
  _Item.PaymentDifferenceReason AS PaymentDifferenceReason,
  _Item.Supplier AS Supplier,
  _Item.ClearingDate AS ClearingDate,
  _Item.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  _Item.ClearingAccountingDocument AS ClearingAccountingDocument,
  _Item.PostingKey AS PostingKey,
  _Item.FinancialAccountType AS FinancialAccountType,
  _Item.SpecialGLCode AS SpecialGLCode,
  _Item.SpecialGLTransactionType AS SpecialGLTransactionType,
  _Item.DebitCreditCode AS DebitCreditCode,
  _Item.BusinessArea AS BusinessArea,
  _Item.TaxCode AS TaxCode,
  _Item.TaxCountry AS TaxCountry,
  _Item.TaxReportingDate AS TaxReportingDate,
  _Item.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  _Item.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  _Item.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  _Item.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  _Item.WithholdingTaxBaseAmount AS WithholdingTaxBaseAmount,
  _Item.ValuationDiffAmtInCoCodeCrcy AS ValuationDiffAmtInCoCodeCrcy,
  _Item.ValuationDiffAmtInAddlCrcy1 AS ValuationDiffAmtInAddlCrcy1,
  _Item.ValueDate AS ValueDate,
  _Item.AssignmentReference AS AssignmentReference,
  _Item.DocumentItemText AS DocumentItemText,
  _Item.PartnerCompany AS PartnerCompany,
  _Item.CostCenter AS CostCenter,
  _Item.OrderID AS OrderID,
  _Item.BillingDocument AS BillingDocument,
  _Item.SalesDocument AS SalesDocument,
  _Item.SalesDocumentItem AS SalesDocumentItem,
  _Item.ScheduleLine AS ScheduleLine,
  _Item.MasterFixedAsset AS MasterFixedAsset,
  _Item.FixedAsset AS FixedAsset,
  _Item.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  _Item.GLAccount AS GLAccount,
  _Item.Branch AS Branch,
  _Item.DueCalculationBaseDate AS DueCalculationBaseDate,
  _Item.PaymentTerms AS PaymentTerms,
  _Item.CashDiscount1Days AS CashDiscount1Days,
  _Item.CashDiscount2Days AS CashDiscount2Days,
  _Item.NetPaymentDays AS NetPaymentDays,
  _Item.CashDiscount1Percent AS CashDiscount1Percent,
  _Item.CashDiscount2Percent AS CashDiscount2Percent,
  _Item.CashDiscountBaseAmount AS CashDiscountBaseAmount,
  _Item.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  _Item.CashDiscountAmount AS CashDiscountAmount,
  _Item.PaymentMethod AS PaymentMethod,
  _Item.PaymentBlockingReason AS PaymentBlockingReason,
  _Item.FixedCashDiscount AS FixedCashDiscount,
  _Item.InvoiceReference AS InvoiceReference,
  _Item.FollowOnDocumentType AS FollowOnDocumentType,
  _Item.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  _Item.SupplyingCountry AS SupplyingCountry,
  _Item.InvoiceList AS InvoiceList,
  _Item.BillOfExchangeUsage AS BillOfExchangeUsage,
  _Item.DunningKey AS DunningKey,
  _Item.DunningBlockingReason AS DunningBlockingReason,
  _Item.LastDunningDate AS LastDunningDate,
  _Item.DunningLevel AS DunningLevel,
  _Item.DunningArea AS DunningArea,
  _Item.WithholdingTaxAmount AS WithholdingTaxAmount,
  _Item.WithholdingTaxExemptionAmt AS WithholdingTaxExemptionAmt,
  _Item.Plant AS Plant,
  _Item.PurchasingDocument AS PurchasingDocument,
  _Item.PurchasingDocumentItem AS PurchasingDocumentItem,
  _Item.ProfitCenter AS ProfitCenter,
  _Item.TreasuryContractType AS TreasuryContractType,
  _Item.AssetContract AS AssetContract,
  _Item.CashFlowType AS CashFlowType,
  _Item.WBSElement AS WBSElement,
  _Item.AlternativeGLAccount AS AlternativeGLAccount,
  _Item.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  _Item.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  _Item.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  _Item.ValuationDiffAmtInAddlCrcy2 AS ValuationDiffAmtInAddlCrcy2,
  _Item.ClearingIsReversed AS ClearingIsReversed,
  _Item.PaymentMethodSupplement AS PaymentMethodSupplement,
  _Item.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  _Item.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  _Item.PaymentCardItem AS PaymentCardItem,
  _Item.PaymentCardPaymentSettlement AS PaymentCardPaymentSettlement,
  _Item.CreditControlArea AS CreditControlArea,
  _Item.PayableAlternativePayee AS PayableAlternativePayee,
  _Item.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  _Item.DataExchangeInstruction1 AS DataExchangeInstruction1,
  _Item.DataExchangeInstruction2 AS DataExchangeInstruction2,
  _Item.DataExchangeInstruction3 AS DataExchangeInstruction3,
  _Item.DataExchangeInstruction4 AS DataExchangeInstruction4,
  _Item.HasPaymentOrder AS HasPaymentOrder,
  _Item.PaymentReference AS PaymentReference,
  _Item.HedgedAmount AS HedgedAmount,
  _Item.PaymentCurrency AS PaymentCurrency,
  _Item.AmountInPaymentCurrency AS AmountInPaymentCurrency,
  _Item.BusinessPlace AS BusinessPlace,
  _Item.TaxSection AS TaxSection,
  _Item.AccountsReceivableIsPledged AS AccountsReceivableIsPledged,
  _Item.RealEstateObject AS RealEstateObject,
  _Item.FundsCenter AS FundsCenter,
  _Item.SettlementReferenceDate AS SettlementReferenceDate,
  _Item.IsSalesRelated AS IsSalesRelated,
  _Item.PostingDate AS PostingDate,
  _Item.AccountingDocumentCategory AS AccountingDocumentCategory,
  _Item.FiscalPeriod AS FiscalPeriod,
  _Item.DocumentDate AS DocumentDate,
  _Item.AccountingDocumentType AS AccountingDocumentType,
  _Item.TransactionCurrency AS TransactionCurrency,
  _Item.PlannedAmtInTransactionCrcy AS PlannedAmtInTransactionCrcy,
  _Item.NetDueDate AS NetDueDate,
  _Item.CashDiscount1DueDate AS CashDiscount1DueDate,
  _Item.SourceCompanyCode AS SourceCompanyCode,
  _Item.DocumentReferenceID AS DocumentReferenceID,
  _Item.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  _Item.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _Item.AdditionalCurrency1 AS AdditionalCurrency1,
  _Item.AdditionalCurrency2 AS AdditionalCurrency2,
  _Item.FunctionalCurrency AS FunctionalCurrency,
  _Item.OffsettingAccount AS OffsettingAccount,
  _Item.OffsettingAccountType AS OffsettingAccountType,
  _Item.ITEM_TYPE_BRANCH AS ITEM_TYPE_BRANCH,
  _Item.DocumentIsArchived AS DocumentIsArchived,
  _Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Item.BPBankAccountInternalID AS BPBankAccountInternalID,
  case when _Item.SpecialGLTransactionType = 'A' then _TaxCode.TargetTaxCode else ' ' end as TargetTaxCode AS TargetTaxCodeelseendasTargetTaxCode,
  _Item.HouseBank AS HouseBank,
  _Item.HouseBankAccount AS HouseBankAccount,
  _Item.Debtor AS Debtor,
  _Item.AdditionalCurrency1Role AS AdditionalCurrency1Role,
  _Item.AdditionalCurrency2Role AS AdditionalCurrency2Role,
  _Item.BranchCode AS BranchCode,
  _Item.ReferenceDocumentType AS ReferenceDocumentType,
  _Item.OriginalReferenceDocument AS OriginalReferenceDocument,
  _Item.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  _Item.PaymentReason AS PaymentReason,
  _Item.BillOfExchangeUsageDocument AS BillOfExchangeUsageDocument,
  _Item.BOEUsageDocFiscalYear AS BOEUsageDocFiscalYear,
  _Item.BOEUsageDocLineItem AS BOEUsageDocLineItem,
  _Item.JointVenture AS JointVenture,
  _Item.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  _Item.JointVentureBillingType AS JointVentureBillingType,
  _Item.JointVentureCorporateEquityGrp AS JointVentureCorporateEquityGrp
FROM P_APLineItem_4 AS _Item
;