P_ARLineItem_10

DDL: P_ARLINEITEM_10 SQL: PARLINEITEM10 Type: view BASIC Package: FINS_FIS_APAR_APPS

Dispute Case Object Key Calculation

P_ARLineItem_10 is a Basic CDS View that provides data about "Dispute Case Object Key Calculation" in SAP S/4HANA. It reads from 1 data source (I_ReceivablesPayablesItem) and exposes 120 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. Part of development package FINS_FIS_APAR_APPS.

Data Sources (1)

SourceAliasJoin Type
I_ReceivablesPayablesItem I_ReceivablesPayablesItem from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PARLINEITEM10 view
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (120)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_ReceivablesPayablesItem CompanyCode Receiver Company Code
KEY AccountingDocument I_ReceivablesPayablesItem AccountingDocument Journal Entry
KEY FiscalYear I_ReceivablesPayablesItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_ReceivablesPayablesItem AccountingDocumentItem Posting View Item
DisputeCaseObjectKey
AccountingDocumentCategory I_ReceivablesPayablesItem AccountingDocumentCategory Journal Entry Category
AccountingDocumentCreationDate
AccountingDocumentType I_ReceivablesPayablesItem AccountingDocumentType Journal Entry Type
AccountsReceivableIsPledged I_ReceivablesPayablesItem AccountsReceivableIsPledged Accounts Receivable Is Pledged
AdditionalCurrency1 I_ReceivablesPayablesItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_ReceivablesPayablesItem AdditionalCurrency2 Local curr. 3
AlternativeGLAccount I_ReceivablesPayablesItem AlternativeGLAccount Group Account
AmountInAdditionalCurrency1 I_ReceivablesPayablesItem AmountInAdditionalCurrency1 Amount in Additional Currency 1
AmountInAdditionalCurrency2 I_ReceivablesPayablesItem AmountInAdditionalCurrency2 LC2 Amount
AmountInBalanceTransacCrcy I_ReceivablesPayablesItem AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
AmountInCompanyCodeCurrency I_ReceivablesPayablesItem AmountInCompanyCodeCurrency Local Crcy Amt
AmountInPaymentCurrency I_ReceivablesPayablesItem AmountInPaymentCurrency Amount in Payment Currency
AmountInTransactionCurrency I_ReceivablesPayablesItem AmountInTransactionCurrency Pt Crcy Amt
AssetContract I_ReceivablesPayablesItem AssetContract Asset Contract
AssignmentReference I_ReceivablesPayablesItem AssignmentReference Assignment Reference
BalanceTransactionCurrency I_ReceivablesPayablesItem BalanceTransactionCurrency Currency
BillingDocument I_ReceivablesPayablesItem BillingDocument SD Document
BillOfExchangeUsage I_ReceivablesPayablesItem BillOfExchangeUsage BoE Usage
Branch I_ReceivablesPayablesItem BranchAccount Branch Account No.
BusinessArea I_ReceivablesPayablesItem BusinessArea Business Area
BusinessPlace I_ReceivablesPayablesItem BusinessPlace Business place
CashDiscount1Days I_ReceivablesPayablesItem CashDiscount1Days Days from Baseline Date for Payment
CashDiscount1DueDate I_ReceivablesPayablesItem CashDiscount1DueDate Cash Discount 1
CashDiscount1Percent I_ReceivablesPayablesItem CashDiscount1Percent Disc. Percent 1
CashDiscount2Days I_ReceivablesPayablesItem CashDiscount2Days Days from Baseline Date for Payment
CashDiscount2Percent I_ReceivablesPayablesItem CashDiscount2Percent Disc. Percent 2
CashDiscountAmount I_ReceivablesPayablesItem CashDiscountAmount CD Amount
CashDiscountAmtInCoCodeCrcy I_ReceivablesPayablesItem CashDiscountAmtInCoCodeCrcy Discount Amt
CashDiscountBaseAmount I_ReceivablesPayablesItem CashDiscountBaseAmount Cash Dscnt Base Amt
CashFlowType I_ReceivablesPayablesItem CashFlowType Flow Type
ClearingAccountingDocument I_ReceivablesPayablesItem ClearingAccountingDocument Clearing Journal Entry
ClearingDate I_ReceivablesPayablesItem ClearingDate Clearing Date
ClearingDocFiscalYear I_ReceivablesPayablesItem ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
ClearingIsReversed I_ReceivablesPayablesItem ClearingIsReversed Clearing Is Reversed
CompanyCodeCurrency I_ReceivablesPayablesItem CompanyCodeCurrency Local Currency
CostCenter I_ReceivablesPayablesItem CostCenter Cost Center
CreditControlArea I_ReceivablesPayablesItem CreditControlArea Credit Control Area
DataExchangeInstruction1 I_ReceivablesPayablesItem DataExchangeInstruction1 Instruction 1
DataExchangeInstruction2 I_ReceivablesPayablesItem DataExchangeInstruction2 Instruction 2
DataExchangeInstruction3 I_ReceivablesPayablesItem DataExchangeInstruction3 Instruction 3
DataExchangeInstruction4 I_ReceivablesPayablesItem DataExchangeInstruction4 Instruction 4
DebitCreditCode I_ReceivablesPayablesItem DebitCreditCode Single-Character Flag
Debtor I_ReceivablesPayablesItem Debtor Debtor
DocumentDate I_ReceivablesPayablesItem DocumentDate Journal Entry Date
DocumentItemText I_ReceivablesPayablesItem DocumentItemText Text
DocumentReferenceID
DueCalculationBaseDate I_ReceivablesPayablesItem DueCalculationBaseDate Due Calculation Base Date
DunningArea I_ReceivablesPayablesItem DunningArea Dunning Area
DunningBlockingReason I_ReceivablesPayablesItem DunningBlockingReason Set Dunning Block
DunningLevel I_ReceivablesPayablesItem DunningLevel Dunning Level
FinancialAccountType I_ReceivablesPayablesItem FinancialAccountType Fin. Account Type
FiscalPeriod I_ReceivablesPayablesItem FiscalPeriod Tax period
FixedAsset I_ReceivablesPayablesItem FixedAsset Sub-number
FixedCashDiscount I_ReceivablesPayablesItem FixedCashDiscount Fixed Cash Discount
FollowOnDocumentType I_ReceivablesPayablesItem FollowOnDocumentType Follow-On Document Type
FundsCenter I_ReceivablesPayablesItem FundsCenter Funds Center
GLAccount I_ReceivablesPayablesItem GLAccount General Ledger
HasPaymentOrder I_ReceivablesPayablesItem HasPaymentOrder Payment Sent
HedgedAmount I_ReceivablesPayablesItem HedgedAmount
InvoiceList I_ReceivablesPayablesItem InvoiceList Invoice List
InvoiceReference I_ReceivablesPayablesItem InvoiceReference Invoice Reference
IsSalesRelated I_ReceivablesPayablesItem IsSalesRelated Is Sales Related
IsUsedInPaymentTransaction I_ReceivablesPayablesItem IsUsedInPaymentTransaction Is Used In Payment Transaction
LastDunningDate I_ReceivablesPayablesItem LastDunningDate Last Dunned
MasterFixedAsset I_ReceivablesPayablesItem MasterFixedAsset Fixed Asset
DunningKey I_ReceivablesPayablesItem DunningKey Dunning Key
NetDueDate I_ReceivablesPayablesItem NetDueDate Net Due Date
NetPaymentDays I_ReceivablesPayablesItem NetPaymentDays Net Pmt Terms Period
OffsettingAccount I_ReceivablesPayablesItem OffsettingAccount Offsetting Acct
OffsettingAccountType I_ReceivablesPayablesItem OffsettingAccountType Offset Acct Type
OrderID I_ReceivablesPayablesItem OrderID Order ID
PartnerCompany I_ReceivablesPayablesItem PartnerCompany Trading Partner
PaymentBlockingReason I_ReceivablesPayablesItem PaymentBlockingReason Pmnt block
PaymentCardItem I_ReceivablesPayablesItem PaymentCardItem Payment Card Item
PaymentCardPaymentSettlement I_ReceivablesPayablesItem PaymentCardPaymentSettlement Payment Card Payment Settlement
PaymentCurrency I_ReceivablesPayablesItem PaymentCurrency Payment Currency
PaymentDifferenceReason I_ReceivablesPayablesItem PaymentDifferenceReason Reason Code
PaymentMethod I_ReceivablesPayablesItem PaymentMethod Pymt Meth.
PaymentMethodSupplement I_ReceivablesPayablesItem PaymentMethodSupplement Pmnt Meth. Sup.
PaymentReference I_ReceivablesPayablesItem PaymentReference Payment Reference
PaymentTerms I_ReceivablesPayablesItem PaymentTerms Pyt Terms
PlannedAmtInTransactionCrcy I_ReceivablesPayablesItem PlannedAmtInTransactionCrcy Plnd Amt Trans. Crcy
Plant I_ReceivablesPayablesItem Plant Valuation Area
PostingDate I_ReceivablesPayablesItem PostingDate Posting Date for GR
PostingKey I_ReceivablesPayablesItem PostingKey Posting Key
ProfitCenter I_ReceivablesPayablesItem ProfitCenter Profit Center
PurchasingDocument I_ReceivablesPayablesItem PurchasingDocument Purchasing Document
PurchasingDocumentItem I_ReceivablesPayablesItem PurchasingDocumentItem Purchasing Doc. Item
RealEstateObject I_ReceivablesPayablesItem RealEstateObject Real Estate Key
Reference1IDByBusinessPartner I_ReceivablesPayablesItem Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner I_ReceivablesPayablesItem Reference2IDByBusinessPartner Reference Key 2
Reference3IDByBusinessPartner I_ReceivablesPayablesItem Reference3IDByBusinessPartner Reference Key 3
SalesDocument I_ReceivablesPayablesItem SalesDocument SD Document
SalesDocumentItem I_ReceivablesPayablesItem SalesDocumentItem Sales Document Item
ScheduleLine I_ReceivablesPayablesItem ScheduleLine Schedule Line
SettlementReferenceDate I_ReceivablesPayablesItem SettlementReferenceDate Reference date
SpecialGLCode I_ReceivablesPayablesItem SpecialGLCode Special G/L Ind
SpecialGLTransactionType I_ReceivablesPayablesItem SpecialGLTransactionType Transact.Type
TaxCalculationProcedure
TaxCode I_ReceivablesPayablesItem TaxCode Tax Code
TaxSection I_ReceivablesPayablesItem TaxSection Tax Section
TransactionCurrency I_ReceivablesPayablesItem TransactionCurrency Transaction Currency
TreasuryContractType I_ReceivablesPayablesItem TreasuryContractType Treasury Contract Type
ValuationDiffAmtInAddlCrcy1 I_ReceivablesPayablesItem ValuationDiffAmtInAddlCrcy1
ValuationDiffAmtInAddlCrcy2 I_ReceivablesPayablesItem ValuationDiffAmtInAddlCrcy2
ValuationDiffAmtInCoCodeCrcy I_ReceivablesPayablesItem ValuationDiffAmtInCoCodeCrcy
ValueDate I_ReceivablesPayablesItem ValueDate Value Date
WBSElement I_ReceivablesPayablesItem WBSElement WBS Internal ID
WithholdingTaxAmount I_ReceivablesPayablesItem WithholdingTaxAmount Withholding Tax Amt
WithholdingTaxBaseAmount I_ReceivablesPayablesItem WithholdingTaxBaseAmount WTax Base Amt
WithholdingTaxExemptionAmt I_ReceivablesPayablesItem WithholdingTaxExemptionAmt WTax-Exempt
BPBankAccountInternalID I_ReceivablesPayablesItem BPBankAccountInternalID BP Bank Account
HouseBank I_ReceivablesPayablesItem HouseBank House Bank
_JournalEntry _JournalEntry
_CompanyCode _CompanyCode

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_ARLineItem_10.
-- 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: PARLINEITEM10

CREATE VIEW P_ARLineItem_10 AS
SELECT
  I_ReceivablesPayablesItem.CompanyCode AS CompanyCode,
  I_ReceivablesPayablesItem.AccountingDocument AS AccountingDocument,
  I_ReceivablesPayablesItem.FiscalYear AS FiscalYear,
  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,
  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.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.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.FundsCenter AS FundsCenter,
  I_ReceivablesPayablesItem.GLAccount AS GLAccount,
  I_ReceivablesPayablesItem.HasPaymentOrder AS HasPaymentOrder,
  I_ReceivablesPayablesItem.HedgedAmount AS HedgedAmount,
  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.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
FROM I_ReceivablesPayablesItem
;