@AbapCatalog.sqlViewName: 'PARLINEITEM9'
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@VDM.viewType: #BASIC
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_ARLineItem_9
with parameters
P_DisputeCaseAccessIsGranted : boole_d
as select from I_ReceivablesPayablesItem
{
key I_ReceivablesPayablesItem.CompanyCode as CompanyCode,
key I_ReceivablesPayablesItem.AccountingDocument as AccountingDocument,
key I_ReceivablesPayablesItem.FiscalYear as FiscalYear,
key I_ReceivablesPayablesItem.AccountingDocumentItem as AccountingDocumentItem,
// cast( concat(concat(I_ReceivablesPayablesItem.CompanyCode, I_ReceivablesPayablesItem.AccountingDocument), concat(I_ReceivablesPayablesItem.FiscalYear, I_ReceivablesPayablesItem.AccountingDocumentItem)) as swo_typeid ) as DisputeCaseObjectKey,
cast (
case length(I_ReceivablesPayablesItem.CompanyCode)
when 4
then concat(concat(I_ReceivablesPayablesItem.CompanyCode,I_ReceivablesPayablesItem.AccountingDocument), concat(I_ReceivablesPayablesItem.FiscalYear, I_ReceivablesPayablesItem.AccountingDocumentItem))
when 3
then concat(concat_with_space(I_ReceivablesPayablesItem.CompanyCode, I_ReceivablesPayablesItem.AccountingDocument, 1), concat(I_ReceivablesPayablesItem.FiscalYear, I_ReceivablesPayablesItem.AccountingDocumentItem))
when 2
then concat(concat_with_space(I_ReceivablesPayablesItem.CompanyCode, I_ReceivablesPayablesItem.AccountingDocument, 2), concat(I_ReceivablesPayablesItem.FiscalYear, I_ReceivablesPayablesItem.AccountingDocumentItem))
when 1
then concat(concat_with_space(I_ReceivablesPayablesItem.CompanyCode, I_ReceivablesPayablesItem.AccountingDocument, 3), concat(I_ReceivablesPayablesItem.FiscalYear, I_ReceivablesPayablesItem.AccountingDocumentItem))
when 0
then concat(concat_with_space(I_ReceivablesPayablesItem.CompanyCode, I_ReceivablesPayablesItem.AccountingDocument, 4), concat(I_ReceivablesPayablesItem.FiscalYear, I_ReceivablesPayablesItem.AccountingDocumentItem))
end as swo_typeid
) as DisputeCaseObjectKey,
I_ReceivablesPayablesItem.AccountingDocumentCategory as AccountingDocumentCategory,
I_ReceivablesPayablesItem._JournalEntry.AccountingDocumentCreationDate as AccountingDocumentCreationDate,
I_ReceivablesPayablesItem.AccountingDocumentType as AccountingDocumentType,
I_ReceivablesPayablesItem.AccountsReceivableIsPledged as AccountsReceivableIsPledged,
I_ReceivablesPayablesItem.AdditionalCurrency1 as AdditionalCurrency1,
I_ReceivablesPayablesItem.AdditionalCurrency2 as AdditionalCurrency2,
I_ReceivablesPayablesItem.AlternativeGLAccount as AlternativeGLAccount,
I_ReceivablesPayablesItem.AmountInAdditionalCurrency1 as AmountInAdditionalCurrency1,
I_ReceivablesPayablesItem.AmountInAdditionalCurrency2 as AmountInAdditionalCurrency2,
I_ReceivablesPayablesItem.AmountInBalanceTransacCrcy as AmountInBalanceTransacCrcy,
I_ReceivablesPayablesItem.AmountInCompanyCodeCurrency as AmountInCompanyCodeCurrency,
I_ReceivablesPayablesItem.AmountInFunctionalCurrency as AmountInFunctionalCurrency,
I_ReceivablesPayablesItem.AmountInPaymentCurrency as AmountInPaymentCurrency,
I_ReceivablesPayablesItem.AmountInTransactionCurrency as AmountInTransactionCurrency,
I_ReceivablesPayablesItem.AssetContract as AssetContract,
I_ReceivablesPayablesItem.AssignmentReference as AssignmentReference,
I_ReceivablesPayablesItem.BalanceTransactionCurrency as BalanceTransactionCurrency,
I_ReceivablesPayablesItem.BillingDocument as BillingDocument,
I_ReceivablesPayablesItem.BillOfExchangeUsage as BillOfExchangeUsage,
I_ReceivablesPayablesItem.BranchAccount as Branch,
I_ReceivablesPayablesItem.BusinessArea as BusinessArea,
I_ReceivablesPayablesItem.BusinessPlace as BusinessPlace,
I_ReceivablesPayablesItem.CashDiscount1Days as CashDiscount1Days,
I_ReceivablesPayablesItem.CashDiscount1DueDate as CashDiscount1DueDate,
I_ReceivablesPayablesItem.CashDiscount1Percent as CashDiscount1Percent,
I_ReceivablesPayablesItem.CashDiscount2Days as CashDiscount2Days,
I_ReceivablesPayablesItem.CashDiscount2Percent as CashDiscount2Percent,
I_ReceivablesPayablesItem.CashDiscountAmount as CashDiscountAmount,
I_ReceivablesPayablesItem.CashDiscountAmtInCoCodeCrcy as CashDiscountAmtInCoCodeCrcy,
I_ReceivablesPayablesItem.CashDiscountBaseAmount as CashDiscountBaseAmount,
I_ReceivablesPayablesItem.CashFlowType as CashFlowType,
I_ReceivablesPayablesItem.ClearingAccountingDocument as ClearingAccountingDocument,
I_ReceivablesPayablesItem.ClearingDate as ClearingDate,
I_ReceivablesPayablesItem.ClearingDocFiscalYear as ClearingDocFiscalYear,
I_ReceivablesPayablesItem.ClearingIsReversed as ClearingIsReversed,
I_ReceivablesPayablesItem.CompanyCodeCurrency as CompanyCodeCurrency,
I_ReceivablesPayablesItem.CostCenter as CostCenter,
I_ReceivablesPayablesItem.CreditControlArea as CreditControlArea,
I_ReceivablesPayablesItem.AlternativePayeePayer as ReceivableAlternativePayer,
I_ReceivablesPayablesItem.DataExchangeInstruction1 as DataExchangeInstruction1,
I_ReceivablesPayablesItem.DataExchangeInstruction2 as DataExchangeInstruction2,
I_ReceivablesPayablesItem.DataExchangeInstruction3 as DataExchangeInstruction3,
I_ReceivablesPayablesItem.DataExchangeInstruction4 as DataExchangeInstruction4,
I_ReceivablesPayablesItem.DebitCreditCode as DebitCreditCode,
I_ReceivablesPayablesItem.Debtor as Debtor,
I_ReceivablesPayablesItem.DocumentDate as DocumentDate,
I_ReceivablesPayablesItem.DocumentItemText as DocumentItemText,
I_ReceivablesPayablesItem._JournalEntry.DocumentReferenceID as DocumentReferenceID,
I_ReceivablesPayablesItem.DueCalculationBaseDate as DueCalculationBaseDate,
I_ReceivablesPayablesItem.DunningArea as DunningArea,
I_ReceivablesPayablesItem.DunningBlockingReason as DunningBlockingReason,
I_ReceivablesPayablesItem.DunningLevel as DunningLevel,
I_ReceivablesPayablesItem.FinancialAccountType as FinancialAccountType,
I_ReceivablesPayablesItem.FiscalPeriod as FiscalPeriod,
I_ReceivablesPayablesItem.FixedAsset as FixedAsset,
I_ReceivablesPayablesItem.FixedCashDiscount as FixedCashDiscount,
I_ReceivablesPayablesItem.FollowOnDocumentType as FollowOnDocumentType,
I_ReceivablesPayablesItem.StateCentralBankPaymentReason as StateCentralBankPaymentReason,
I_ReceivablesPayablesItem.SupplyingCountry as SupplyingCountry,
I_ReceivablesPayablesItem.FunctionalCurrency as FunctionalCurrency,
I_ReceivablesPayablesItem.FundsCenter as FundsCenter,
I_ReceivablesPayablesItem.GLAccount as GLAccount,
I_ReceivablesPayablesItem.HasPaymentOrder as HasPaymentOrder,
I_ReceivablesPayablesItem.HedgedAmount as HedgedAmount,
I_ReceivablesPayablesItem.HouseBankAccount as HouseBankAccount,
I_ReceivablesPayablesItem.InvoiceList as InvoiceList,
I_ReceivablesPayablesItem.InvoiceReference as InvoiceReference,
I_ReceivablesPayablesItem.IsSalesRelated as IsSalesRelated,
I_ReceivablesPayablesItem.IsUsedInPaymentTransaction as IsUsedInPaymentTransaction,
I_ReceivablesPayablesItem.LastDunningDate as LastDunningDate,
I_ReceivablesPayablesItem.MasterFixedAsset as MasterFixedAsset,
I_ReceivablesPayablesItem.DunningKey as DunningKey,
I_ReceivablesPayablesItem.NetDueDate as NetDueDate,
I_ReceivablesPayablesItem.NetPaymentDays as NetPaymentDays,
I_ReceivablesPayablesItem.OffsettingAccount as OffsettingAccount,
I_ReceivablesPayablesItem.OffsettingAccountType as OffsettingAccountType,
I_ReceivablesPayablesItem.OrderID as OrderID,
I_ReceivablesPayablesItem.PartnerCompany as PartnerCompany,
I_ReceivablesPayablesItem.PaymentBlockingReason as PaymentBlockingReason,
I_ReceivablesPayablesItem.PaymentCardItem as PaymentCardItem,
I_ReceivablesPayablesItem.PaymentCardPaymentSettlement as PaymentCardPaymentSettlement,
I_ReceivablesPayablesItem.PaymentCurrency as PaymentCurrency,
I_ReceivablesPayablesItem.PaymentDifferenceReason as PaymentDifferenceReason,
I_ReceivablesPayablesItem.PaymentMethod as PaymentMethod,
I_ReceivablesPayablesItem.PaymentMethodSupplement as PaymentMethodSupplement,
I_ReceivablesPayablesItem.PaymentReference as PaymentReference,
I_ReceivablesPayablesItem.PaymentTerms as PaymentTerms,
I_ReceivablesPayablesItem.PlannedAmtInTransactionCrcy as PlannedAmtInTransactionCrcy,
I_ReceivablesPayablesItem.Plant as Plant,
I_ReceivablesPayablesItem.PostingDate as PostingDate,
I_ReceivablesPayablesItem.PostingKey as PostingKey,
I_ReceivablesPayablesItem.ProfitCenter as ProfitCenter,
I_ReceivablesPayablesItem.PurchasingDocument as PurchasingDocument,
I_ReceivablesPayablesItem.PurchasingDocumentItem as PurchasingDocumentItem,
I_ReceivablesPayablesItem.RealEstateObject as RealEstateObject,
I_ReceivablesPayablesItem.Reference1IDByBusinessPartner as Reference1IDByBusinessPartner,
I_ReceivablesPayablesItem.Reference2IDByBusinessPartner as Reference2IDByBusinessPartner,
I_ReceivablesPayablesItem.Reference3IDByBusinessPartner as Reference3IDByBusinessPartner,
I_ReceivablesPayablesItem.SalesDocument as SalesDocument,
I_ReceivablesPayablesItem.SalesDocumentItem as SalesDocumentItem,
I_ReceivablesPayablesItem.ScheduleLine as ScheduleLine,
I_ReceivablesPayablesItem.SettlementReferenceDate as SettlementReferenceDate,
I_ReceivablesPayablesItem.SpecialGLCode as SpecialGLCode,
I_ReceivablesPayablesItem.SpecialGLTransactionType as SpecialGLTransactionType,
I_ReceivablesPayablesItem._CompanyCode._Country.TaxCalculationProcedure as TaxCalculationProcedure,
I_ReceivablesPayablesItem.TaxCode as TaxCode,
I_ReceivablesPayablesItem.TaxSection as TaxSection,
I_ReceivablesPayablesItem.TaxCountry as TaxCountry,
I_ReceivablesPayablesItem.TransactionCurrency as TransactionCurrency,
I_ReceivablesPayablesItem.TreasuryContractType as TreasuryContractType,
I_ReceivablesPayablesItem.ValuationDiffAmtInAddlCrcy1 as ValuationDiffAmtInAddlCrcy1,
I_ReceivablesPayablesItem.ValuationDiffAmtInAddlCrcy2 as ValuationDiffAmtInAddlCrcy2,
I_ReceivablesPayablesItem.ValuationDiffAmtInCoCodeCrcy as ValuationDiffAmtInCoCodeCrcy,
I_ReceivablesPayablesItem.ValueDate as ValueDate,
I_ReceivablesPayablesItem.WBSElement as WBSElement,
I_ReceivablesPayablesItem.WithholdingTaxAmount as WithholdingTaxAmount,
I_ReceivablesPayablesItem.WithholdingTaxBaseAmount as WithholdingTaxBaseAmount,
I_ReceivablesPayablesItem.WithholdingTaxExemptionAmt as WithholdingTaxExemptionAmt,
I_ReceivablesPayablesItem.BPBankAccountInternalID as BPBankAccountInternalID,
I_ReceivablesPayablesItem.HouseBank as HouseBank,
I_ReceivablesPayablesItem.Creditor as Creditor,
I_ReceivablesPayablesItem.BranchCode as BranchCode,
I_ReceivablesPayablesItem.ReferenceDocumentType as ReferenceDocumentType,
I_ReceivablesPayablesItem.OriginalReferenceDocument as OriginalReferenceDocument,
I_ReceivablesPayablesItem.ReferenceDocumentLogicalSystem as ReferenceDocumentLogicalSystem,
I_ReceivablesPayablesItem.BillOfExchangeUsageDocument as BillOfExchangeUsageDocument,
I_ReceivablesPayablesItem.BOEUsageDocFiscalYear as BOEUsageDocFiscalYear,
I_ReceivablesPayablesItem.BOEUsageDocLineItem as BOEUsageDocLineItem,
I_ReceivablesPayablesItem.JointVenture as JointVenture,
I_ReceivablesPayablesItem.JointVentureCostRecoveryCode as JointVentureCostRecoveryCode,
I_ReceivablesPayablesItem.JointVentureBillingType as JointVentureBillingType,
I_ReceivablesPayablesItem.JointVentureEquityGroup as JointVentureCorporateEquityGrp,
:P_DisputeCaseAccessIsGranted as DisputeCaseAccessIsGranted,
_JournalEntry,
_CompanyCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_COUNTRY",
"I_JOURNALENTRY",
"I_RECEIVABLESPAYABLESITEM"
],
"ASSOCIATED":
[
"I_COMPANYCODE",
"I_JOURNALENTRY"
],
"BASE":
[
"I_RECEIVABLESPAYABLESITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/