P_APLineItem_1

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_1.
-- 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.
-- SQL view name: PAPLINEITEM1
-- Parameters: P_KEYDATE : vdm_v_key_date, P_TodayDate : abap.dats, P_Language : sylangu

CREATE VIEW P_APLineItem_1 AS
SELECT
  P_APLineItem_2.CompanyCode AS CompanyCode,
  P_APLineItem_2.AccountingDocument AS AccountingDocument,
  P_APLineItem_2.FiscalYear AS FiscalYear,
  P_APLineItem_2.AccountingDocumentItem AS AccountingDocumentItem,
  :P_Language AS Language,
  P_APLineItem_2.KEYDT2 AS KEYDT2,
  P_APLineItem_2.PaymentDifferenceReason AS PaymentDifferenceReason,
  P_APLineItem_2.Supplier AS Supplier,
  P_APLineItem_2.ClearingDate AS ClearingDate,
  P_APLineItem_2.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  P_APLineItem_2.ClearingAccountingDocument AS ClearingAccountingDocument,
  P_APLineItem_2.PostingKey AS PostingKey,
  P_APLineItem_2.FinancialAccountType AS FinancialAccountType,
  P_APLineItem_2.SpecialGLCode AS SpecialGLCode,
  P_APLineItem_2.SpecialGLTransactionType AS SpecialGLTransactionType,
  P_APLineItem_2.DebitCreditCode AS DebitCreditCode,
  P_APLineItem_2.BusinessArea AS BusinessArea,
  P_APLineItem_2.TaxCode AS TaxCode,
  P_APLineItem_2.TaxCountry AS TaxCountry,
  P_APLineItem_2.TaxReportingDate AS TaxReportingDate,
  P_APLineItem_2.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  P_APLineItem_2.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  P_APLineItem_2.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  P_APLineItem_2.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  P_APLineItem_2.WithholdingTaxBaseAmount AS WithholdingTaxBaseAmount,
  P_APLineItem_2.ValuationDiffAmtInCoCodeCrcy AS ValuationDiffAmtInCoCodeCrcy,
  P_APLineItem_2.ValuationDiffAmtInAddlCrcy1 AS ValuationDiffAmtInAddlCrcy1,
  P_APLineItem_2.ValueDate AS ValueDate,
  P_APLineItem_2.AssignmentReference AS AssignmentReference,
  P_APLineItem_2.DocumentItemText AS DocumentItemText,
  P_APLineItem_2.PartnerCompany AS PartnerCompany,
  P_APLineItem_2.CostCenter AS CostCenter,
  P_APLineItem_2.OrderID AS OrderID,
  P_APLineItem_2.BillingDocument AS BillingDocument,
  P_APLineItem_2.SalesDocument AS SalesDocument,
  P_APLineItem_2.SalesDocumentItem AS SalesDocumentItem,
  P_APLineItem_2.ScheduleLine AS ScheduleLine,
  P_APLineItem_2.MasterFixedAsset AS MasterFixedAsset,
  P_APLineItem_2.FixedAsset AS FixedAsset,
  P_APLineItem_2.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  P_APLineItem_2.GLAccount AS GLAccount,
  P_APLineItem_2.Branch AS Branch,
  P_APLineItem_2.DueCalculationBaseDate AS DueCalculationBaseDate,
  P_APLineItem_2.PaymentTerms AS PaymentTerms,
  P_APLineItem_2.CashDiscount1Days AS CashDiscount1Days,
  P_APLineItem_2.CashDiscount2Days AS CashDiscount2Days,
  P_APLineItem_2.NetPaymentDays AS NetPaymentDays,
  P_APLineItem_2.CashDiscount1Percent AS CashDiscount1Percent,
  P_APLineItem_2.CashDiscount2Percent AS CashDiscount2Percent,
  P_APLineItem_2.CashDiscountBaseAmount AS CashDiscountBaseAmount,
  P_APLineItem_2.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  P_APLineItem_2.CashDiscountAmount AS CashDiscountAmount,
  P_APLineItem_2.PaymentMethod AS PaymentMethod,
  P_APLineItem_2.PaymentBlockingReason AS PaymentBlockingReason,
  P_APLineItem_2.FixedCashDiscount AS FixedCashDiscount,
  P_APLineItem_2.FollowOnDocumentType AS FollowOnDocumentType,
  P_APLineItem_2.StateCentralBankPaymentReason AS StateCentralBankPaymentReason,
  P_APLineItem_2.SupplyingCountry AS SupplyingCountry,
  P_APLineItem_2.InvoiceList AS InvoiceList,
  P_APLineItem_2.BillOfExchangeUsage AS BillOfExchangeUsage,
  P_APLineItem_2.DunningKey AS DunningKey,
  P_APLineItem_2.DunningBlockingReason AS DunningBlockingReason,
  P_APLineItem_2.LastDunningDate AS LastDunningDate,
  P_APLineItem_2.DunningLevel AS DunningLevel,
  P_APLineItem_2.DunningArea AS DunningArea,
  P_APLineItem_2.WithholdingTaxAmount AS WithholdingTaxAmount,
  P_APLineItem_2.WithholdingTaxExemptionAmt AS WithholdingTaxExemptionAmt,
  P_APLineItem_2.Plant AS Plant,
  P_APLineItem_2.PurchasingDocument AS PurchasingDocument,
  P_APLineItem_2.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_APLineItem_2.ProfitCenter AS ProfitCenter,
  P_APLineItem_2.TreasuryContractType AS TreasuryContractType,
  P_APLineItem_2.AssetContract AS AssetContract,
  P_APLineItem_2.CashFlowType AS CashFlowType,
  P_APLineItem_2.WBSElement AS WBSElement,
  P_APLineItem_2.AlternativeGLAccount AS AlternativeGLAccount,
  P_APLineItem_2.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  P_APLineItem_2.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  P_APLineItem_2.AmountInFunctionalCurrency AS AmountInFunctionalCurrency,
  P_APLineItem_2.ValuationDiffAmtInAddlCrcy2 AS ValuationDiffAmtInAddlCrcy2,
  P_APLineItem_2.ClearingIsReversed AS ClearingIsReversed,
  P_APLineItem_2.PaymentMethodSupplement AS PaymentMethodSupplement,
  P_APLineItem_2.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  P_APLineItem_2.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  P_APLineItem_2.PaymentCardItem AS PaymentCardItem,
  P_APLineItem_2.PaymentCardPaymentSettlement AS PaymentCardPaymentSettlement,
  P_APLineItem_2.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  P_APLineItem_2.DataExchangeInstruction1 AS DataExchangeInstruction1,
  P_APLineItem_2.DataExchangeInstruction2 AS DataExchangeInstruction2,
  P_APLineItem_2.DataExchangeInstruction3 AS DataExchangeInstruction3,
  P_APLineItem_2.DataExchangeInstruction4 AS DataExchangeInstruction4,
  P_APLineItem_2.HasPaymentOrder AS HasPaymentOrder,
  P_APLineItem_2.PaymentReference AS PaymentReference,
  P_APLineItem_2.HedgedAmount AS HedgedAmount,
  P_APLineItem_2.PaymentCurrency AS PaymentCurrency,
  P_APLineItem_2.AmountInPaymentCurrency AS AmountInPaymentCurrency,
  P_APLineItem_2.BusinessPlace AS BusinessPlace,
  P_APLineItem_2.TaxSection AS TaxSection,
  P_APLineItem_2.AccountsReceivableIsPledged AS AccountsReceivableIsPledged,
  P_APLineItem_2.RealEstateObject AS RealEstateObject,
  P_APLineItem_2.FundsCenter AS FundsCenter,
  P_APLineItem_2.SettlementReferenceDate AS SettlementReferenceDate,
  P_APLineItem_2.IsSalesRelated AS IsSalesRelated,
  P_APLineItem_2.PostingDate AS PostingDate,
  P_APLineItem_2.AccountingDocumentCategory AS AccountingDocumentCategory,
  P_APLineItem_2.FiscalPeriod AS FiscalPeriod,
  P_APLineItem_2.DocumentDate AS DocumentDate,
  P_APLineItem_2.AccountingDocumentType AS AccountingDocumentType,
  P_APLineItem_2.TransactionCurrency AS TransactionCurrency,
  P_APLineItem_2.PlannedAmtInTransactionCrcy AS PlannedAmtInTransactionCrcy,
  P_APLineItem_2.NetDueDate AS NetDueDate,
  P_APLineItem_2.CashDiscount1DueDate AS CashDiscount1DueDate,
  P_APLineItem_2.SourceCompanyCode AS SourceCompanyCode,
  P_APLineItem_2.DocumentReferenceID AS DocumentReferenceID,
  P_APLineItem_2.AccountingDocumentCreationDate AS AccountingDocumentCreationDate,
  P_APLineItem_2.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  P_APLineItem_2.AdditionalCurrency1 AS AdditionalCurrency1,
  P_APLineItem_2.AdditionalCurrency2 AS AdditionalCurrency2,
  P_APLineItem_2.FunctionalCurrency AS FunctionalCurrency,
  P_APLineItem_2.OffsettingAccount AS OffsettingAccount,
  P_APLineItem_2.OffsettingAccountType AS OffsettingAccountType,
  P_APLineItem_2.ITEM_TYPE_BRANCH AS ITEM_TYPE_BRANCH,
  P_APLineItem_2.DPNOTDUE AS DPNOTDUE,
  P_APLineItem_2.DocumentIsArchived AS DocumentIsArchived,
  P_APLineItem_2.TargetTaxCode AS TargetTaxCode,
  P_APLineItem_2.KeyDate AS KeyDate,
  P_APLineItem_2.CompanyCodeCurrency AS CompanyCodeCurrency,
  P_APLineItem_2.AcctgDocTypeAuthorizationGroup AS AcctgDocTypeAuthorizationGroup,
  P_APLineItem_2.BPBankAccountInternalID AS BPBankAccountInternalID,
  P_APLineItem_2.HouseBank AS HouseBank,
  P_APLineItem_2.HouseBankAccount AS HouseBankAccount,
  P_APLineItem_2.PayableAlternativePayee AS PayableAlternativePayee,
  _Creditor.xzemp AS AlternativePayeeIsAllowed,
  _Supplier.SortField AS SupplierSearchText,
  _Supplier.SupplierName AS SupplierName,
  _Supplier.Industry AS SupplierIndustry,
  _Supplier.CreationDate AS SupplierCreationDate,
  _Supplier.CreatedByUser AS SupplierCreatedByUser,
  _Supplier.SupplierCorporateGroup AS SupplierCorporateGroup,
  _Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  _Supplier.Customer AS Customer,
  _Supplier.PostingIsBlocked AS PostingIsBlockedForSupplier,
  _Supplier.TaxNumber1 AS SupplierTaxID1,
  _Supplier.TaxNumber2 AS SupplierTaxID2,
  _Supplier.TaxNumber3 AS SupplierTaxID3,
  _Supplier.TaxNumber4 AS SupplierTaxID4,
  _Supplier.TaxNumber5 AS SupplierTaxID5,
  _Supplier.IsOneTimeAccount AS SupplierIsOneTimeAccount,
  _Supplier.VATRegistration AS SupplierVATRegistration,
  _Supplier.TaxJurisdiction AS SupplierTaxJurisdiction,
  _Supplier._StandardAddress.Country AS SupplierCountry,
  _Supplier._StandardAddress.CityName AS SupplierCityName,
  _Supplier._StandardAddress.POBox AS SupplierPOBox,
  _Supplier._StandardAddress.POBoxPostalCode AS SupplierPOBoxPostalCode,
  _Supplier._StandardAddress.PostalCode AS SupplierPostalCode,
  _Supplier._StandardAddress.Region AS SupplierRegion,
  _SupplierCompany.AccountingClerk AS AccountingClerk,
  _SupplierCompany.ReconciliationAccount AS ReconciliationAccount,
  _SupplierCompany.InterestCalculationCode AS InterestCalculationCode,
  _SupplierCompany.SupplierHeadOffice AS SupplierHeadOffice,
  _SupplierCompany.AlternativePayee AS AlternativePayee,
  _SupplierCompany.PaymentBlockingReason AS SupplierPaymentBlockingReason,
  _SupplierCompany.InterestCalculationDate AS InterestCalculationDate,
  _SupplierCompany.IntrstCalcFrequencyInMonths AS IntrstCalcFrequencyInMonths,
  _SupplierCompany.APARToleranceGroup AS APARToleranceGroup,
  _SupplierCompany.ItemIsToBePaidSeparately AS ItemIsToBePaidSeparately,
  _SupplierCompany.PaymentIsToBeSentByEDI AS PaymentIsToBeSentByEDI,
  _SupplierCompany.SupplierAccountNote AS SupplierAccountNote,
  _Supplier.AuthorizationGroup AS SupplierBasicAuthorizationGrp,
  _SupplierCompany.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _PaymentDifferenceReason.IsDisputed AS IsDisputed,
  case when P_APLineItem_2.FinancialAccountType = 'D' then P_APLineItem_2._Supplier.Customer else P_APLineItem_2.Supplier end as CustomerSupplierAccount AS SupplierendasCustomerSupplierAccount,
  case when P_APLineItem_2.InvoiceReference = '' and P_APLineItem_2.FollowOnDocumentType = '' then P_APLineItem_2.AccountingDocument else P_APLineItem_2.InvoiceReference end as InvoiceReference AS InvoiceReferenceendasInvoiceReference,
  concat(P_APLineItem_2.FiscalYear, P_APLineItem_2.FiscalPeriod) AS FiscalYearPeriod,
  case when P_APLineItem_2.CreditControlArea != '' then P_APLineItem_2.CreditControlArea else _CompanyCode.CreditControlArea end as CreditControlArea AS CreditControlAreaendasCreditControlArea,
  case when P_APLineItem_2.DPNOTDUE = 'X' then 0 else case when P_APLineItem_2.ClearingDate > '00000000' and P_APLineItem_2.ClearingDate < KeyDate then cast( dats_days_between(P_APLineItem_2.NetDueDate, P_APLineItem_2.ClearingDate) as abap.dec(7,0) ) else cast( dats_days_between(P_APLineItem_2.NetDueDate, KeyDate) as abap.dec(7,0) ) end end as NetDueArrearsDays AS dec70endendasNetDueArrearsDays,
  case when P_APLineItem_2.DPNOTDUE = 'X' then 0 else case when P_APLineItem_2.ClearingDate > '00000000' and P_APLineItem_2.ClearingDate < KeyDate then cast( dats_days_between(P_APLineItem_2.CashDiscount1DueDate, P_APLineItem_2.ClearingDate) as abap.dec(7,0) ) else cast( dats_days_between(P_APLineItem_2.CashDiscount1DueDate, KeyDate) as abap.dec(7,0) ) end end as CashDiscount1ArrearsDays AS dec70endendasCashDiscount1ArrearsDays,
  dats_days_between(P_APLineItem_2.DueCalculationBaseDate, :P_TodayDate) AS zfbdt_today,
  P_APLineItem_2.AmountInCompanyCodeCurrency + P_APLineItem_2.ValuationDiffAmtInCoCodeCrcy AS ValuatedAmtInCompanyCodeCrcy,
  P_APLineItem_2.AmountInAdditionalCurrency1 + P_APLineItem_2.ValuationDiffAmtInAddlCrcy1 AS ValuatedAmtInAdditionalCrcy1,
  P_APLineItem_2.AmountInAdditionalCurrency2 + P_APLineItem_2.ValuationDiffAmtInAddlCrcy2 AS ValuatedAmtInAdditionalCrcy2,
  P_APLineItem_2.Debtor AS Debtor,
  AdditionalCurrency1Role,
  AdditionalCurrency2Role,
  P_APLineItem_2.BranchCode AS BranchCode,
  P_APLineItem_2.ReferenceDocumentType AS ReferenceDocumentType,
  P_APLineItem_2.OriginalReferenceDocument AS OriginalReferenceDocument,
  P_APLineItem_2.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  PaymentReason,
  BillOfExchangeUsageDocument,
  BOEUsageDocFiscalYear,
  BOEUsageDocLineItem,
  JointVenture,
  JointVentureCostRecoveryCode,
  JointVentureBillingType,
  JointVentureCorporateEquityGrp
FROM P_APLineItem_2
LEFT OUTER JOIN t016t AS _IndustryName ON SupplierIndustry = _IndustryName.brsch AND Language = _IndustryName.spras  -- association [0..1]
LEFT OUTER JOIN I_RegionText AS _RegionText ON SupplierCountry = _RegionText.Country AND SupplierRegion = _RegionText.Region AND Language = _RegionText.Language  -- association [0..1]
;