P_ARLineItem_4
P_ARLineItem_4 is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_ReceivablesPayablesItem, far_mult_mix_acc, P_ARLineItem_9) and exposes 156 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 2 associations to related views.
Data Sources (3)
| Source | Alias | Join Type |
|---|---|---|
| I_ReceivablesPayablesItem | I_ReceivablesPayablesItem | union_all |
| far_mult_mix_acc | MixAcc1 | inner |
| P_ARLineItem_9 | P_ARLineItem_9 | from |
Parameters (1)
| Name | Type | Default |
|---|---|---|
| P_DisputeCaseAccessIsGranted | boole_d |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | P_ARLineItem_Base_Bset | _BsetBase | $projection.CompanyCode = _BsetBase.CompanyCode and $projection.AccountingDocument = _BsetBase.AccountingDocument and $projection.FiscalYear = _BsetBase.FiscalYear |
| [0..1] | P_ARLineItem_Sum_Bset | _BsetTax | $projection.CompanyCode = _BsetTax.CompanyCode and $projection.AccountingDocument = _BsetTax.AccountingDocument and $projection.FiscalYear = _BsetTax.FiscalYear |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PARLINEITEM4 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view |
Fields (156)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | CompanyCode | P_ARLineItem_9 | CompanyCode | |
| KEY | AccountingDocument | P_ARLineItem_9 | AccountingDocument | |
| KEY | FiscalYear | P_ARLineItem_9 | FiscalYear | |
| KEY | AccountingDocumentItem | P_ARLineItem_9 | AccountingDocumentItem | |
| AccountingDocCreatedByUser | _JournalEntry | AccountingDocCreatedByUser | ||
| AccountingDocumentCategory | P_ARLineItem_9 | AccountingDocumentCategory | ||
| AccountingDocumentCreationDate | ||||
| AccountingDocumentType | P_ARLineItem_9 | AccountingDocumentType | ||
| AccountsReceivableIsPledged | P_ARLineItem_9 | AccountsReceivableIsPledged | ||
| AdditionalCurrency1 | P_ARLineItem_9 | AdditionalCurrency1 | ||
| AdditionalCurrency2 | P_ARLineItem_9 | AdditionalCurrency2 | ||
| AlternativeGLAccount | P_ARLineItem_9 | AlternativeGLAccount | ||
| AmountInAdditionalCurrency1 | P_ARLineItem_9 | AmountInAdditionalCurrency1 | ||
| AmountInAdditionalCurrency2 | P_ARLineItem_9 | AmountInAdditionalCurrency2 | ||
| AmountInBalanceTransacCrcy | P_ARLineItem_9 | AmountInBalanceTransacCrcy | ||
| AmountInCompanyCodeCurrency | P_ARLineItem_9 | AmountInCompanyCodeCurrency | ||
| AmountInFunctionalCurrency | P_ARLineItem_9 | AmountInFunctionalCurrency | ||
| AmountInPaymentCurrency | P_ARLineItem_9 | AmountInPaymentCurrency | ||
| AmountInTransactionCurrency | P_ARLineItem_9 | AmountInTransactionCurrency | ||
| AssetContract | P_ARLineItem_9 | AssetContract | ||
| AssignmentReference | P_ARLineItem_9 | AssignmentReference | ||
| BalanceTransactionCurrency | P_ARLineItem_9 | BalanceTransactionCurrency | ||
| BillingDocument | P_ARLineItem_9 | BillingDocument | ||
| BillOfExchangeUsage | P_ARLineItem_9 | BillOfExchangeUsage | ||
| Branch | P_ARLineItem_9 | Branch | ||
| BusinessArea | P_ARLineItem_9 | BusinessArea | ||
| BusinessPlace | P_ARLineItem_9 | BusinessPlace | ||
| CashDiscount1Days | P_ARLineItem_9 | CashDiscount1Days | ||
| CashDiscount1DueDate | P_ARLineItem_9 | CashDiscount1DueDate | ||
| CashDiscount1Percent | P_ARLineItem_9 | CashDiscount1Percent | ||
| CashDiscount2Days | P_ARLineItem_9 | CashDiscount2Days | ||
| CashDiscount2Percent | P_ARLineItem_9 | CashDiscount2Percent | ||
| CashDiscountAmount | P_ARLineItem_9 | CashDiscountAmount | ||
| CashDiscountAmtInCoCodeCrcy | P_ARLineItem_9 | CashDiscountAmtInCoCodeCrcy | ||
| CashDiscountBaseAmount | P_ARLineItem_9 | CashDiscountBaseAmount | ||
| CashFlowType | P_ARLineItem_9 | CashFlowType | ||
| ClearingAccountingDocument | P_ARLineItem_9 | ClearingAccountingDocument | ||
| ClearingDate | P_ARLineItem_9 | ClearingDate | ||
| ClearingDocFiscalYear | P_ARLineItem_9 | ClearingDocFiscalYear | ||
| ClearingIsReversed | P_ARLineItem_9 | ClearingIsReversed | ||
| CompanyCodeCurrency | P_ARLineItem_9 | CompanyCodeCurrency | ||
| CostCenter | P_ARLineItem_9 | CostCenter | ||
| CreditControlArea | P_ARLineItem_9 | CreditControlArea | ||
| ReceivableAlternativePayer | P_ARLineItem_9 | ReceivableAlternativePayer | ||
| DataExchangeInstruction1 | P_ARLineItem_9 | DataExchangeInstruction1 | ||
| DataExchangeInstruction2 | P_ARLineItem_9 | DataExchangeInstruction2 | ||
| DataExchangeInstruction3 | P_ARLineItem_9 | DataExchangeInstruction3 | ||
| DataExchangeInstruction4 | P_ARLineItem_9 | DataExchangeInstruction4 | ||
| DebitCreditCode | P_ARLineItem_9 | DebitCreditCode | ||
| Debtor | P_ARLineItem_9 | Debtor | ||
| DocumentDate | P_ARLineItem_9 | DocumentDate | ||
| DocumentIsArchived | ||||
| DocumentItemText | P_ARLineItem_9 | DocumentItemText | ||
| DocumentReferenceID | ||||
| DueCalculationBaseDate | P_ARLineItem_9 | DueCalculationBaseDate | ||
| DunningArea | P_ARLineItem_9 | DunningArea | ||
| DunningBlockingReason | P_ARLineItem_9 | DunningBlockingReason | ||
| DunningLevel | P_ARLineItem_9 | DunningLevel | ||
| FinancialAccountType | P_ARLineItem_9 | FinancialAccountType | ||
| FiscalPeriod | P_ARLineItem_9 | FiscalPeriod | ||
| FixedAsset | P_ARLineItem_9 | FixedAsset | ||
| FixedCashDiscount | P_ARLineItem_9 | FixedCashDiscount | ||
| FollowOnDocumentType | P_ARLineItem_9 | FollowOnDocumentType | ||
| StateCentralBankPaymentReason | P_ARLineItem_9 | StateCentralBankPaymentReason | ||
| SupplyingCountry | P_ARLineItem_9 | SupplyingCountry | ||
| FunctionalCurrency | P_ARLineItem_9 | FunctionalCurrency | ||
| FundsCenter | P_ARLineItem_9 | FundsCenter | ||
| GLAccount | P_ARLineItem_9 | GLAccount | ||
| HasPaymentOrder | P_ARLineItem_9 | HasPaymentOrder | ||
| HedgedAmount | P_ARLineItem_9 | HedgedAmount | ||
| HouseBankAccount | P_ARLineItem_9 | HouseBankAccount | ||
| InvoiceList | P_ARLineItem_9 | InvoiceList | ||
| InvoiceReference | P_ARLineItem_9 | InvoiceReference | ||
| IsSalesRelated | P_ARLineItem_9 | IsSalesRelated | ||
| IsUsedInPaymentTransaction | P_ARLineItem_9 | IsUsedInPaymentTransaction | ||
| ITEM_TYPE_BRANCH | ||||
| LastDunningDate | P_ARLineItem_9 | LastDunningDate | ||
| MasterFixedAsset | P_ARLineItem_9 | MasterFixedAsset | ||
| DunningKey | P_ARLineItem_9 | DunningKey | ||
| NetDueDate | P_ARLineItem_9 | NetDueDate | ||
| NetPaymentDays | P_ARLineItem_9 | NetPaymentDays | ||
| OffsettingAccount | P_ARLineItem_9 | OffsettingAccount | ||
| OffsettingAccountType | P_ARLineItem_9 | OffsettingAccountType | ||
| OrderID | P_ARLineItem_9 | OrderID | ||
| PartnerCompany | P_ARLineItem_9 | PartnerCompany | ||
| PaymentBlockingReason | P_ARLineItem_9 | PaymentBlockingReason | ||
| PaymentCardItem | P_ARLineItem_9 | PaymentCardItem | ||
| PaymentCardPaymentSettlement | P_ARLineItem_9 | PaymentCardPaymentSettlement | ||
| PaymentCurrency | P_ARLineItem_9 | PaymentCurrency | ||
| PaymentDifferenceReason | P_ARLineItem_9 | PaymentDifferenceReason | ||
| PaymentMethod | P_ARLineItem_9 | PaymentMethod | ||
| PaymentMethodSupplement | P_ARLineItem_9 | PaymentMethodSupplement | ||
| PaymentReference | P_ARLineItem_9 | PaymentReference | ||
| PaymentTerms | P_ARLineItem_9 | PaymentTerms | ||
| PlannedAmtInTransactionCrcy | P_ARLineItem_9 | PlannedAmtInTransactionCrcy | ||
| Plant | P_ARLineItem_9 | Plant | ||
| PostingDate | P_ARLineItem_9 | PostingDate | ||
| PostingKey | P_ARLineItem_9 | PostingKey | ||
| ProfitCenter | P_ARLineItem_9 | ProfitCenter | ||
| PurchasingDocument | P_ARLineItem_9 | PurchasingDocument | ||
| PurchasingDocumentItem | P_ARLineItem_9 | PurchasingDocumentItem | ||
| RealEstateObject | P_ARLineItem_9 | RealEstateObject | ||
| Reference1IDByBusinessPartner | P_ARLineItem_9 | Reference1IDByBusinessPartner | ||
| Reference2IDByBusinessPartner | P_ARLineItem_9 | Reference2IDByBusinessPartner | ||
| Reference3IDByBusinessPartner | P_ARLineItem_9 | Reference3IDByBusinessPartner | ||
| SalesDocument | P_ARLineItem_9 | SalesDocument | ||
| SalesDocumentItem | P_ARLineItem_9 | SalesDocumentItem | ||
| ScheduleLine | P_ARLineItem_9 | ScheduleLine | ||
| SettlementReferenceDate | P_ARLineItem_9 | SettlementReferenceDate | ||
| SourceCompanyCode | ||||
| SpecialGLCode | P_ARLineItem_9 | SpecialGLCode | ||
| SpecialGLTransactionType | P_ARLineItem_9 | SpecialGLTransactionType | ||
| TaxAmountInCoCodeCrcy | _BsetTax | TaxAmountInCoCodeCrcy | ||
| TaxBaseAmountInCoCodeCrcy | _BsetBase | TaxBaseAmountInCoCodeCrcy | ||
| TaxCalculationProcedure | ||||
| TaxCode | P_ARLineItem_9 | TaxCode | ||
| TaxCountry | P_ARLineItem_9 | TaxCountry | ||
| TaxReportingDate | _JournalEntry | TaxReportingDate | ||
| TaxSection | P_ARLineItem_9 | TaxSection | ||
| TransactionCurrency | P_ARLineItem_9 | TransactionCurrency | ||
| TreasuryContractType | P_ARLineItem_9 | TreasuryContractType | ||
| ValuationDiffAmtInAddlCrcy1 | P_ARLineItem_9 | ValuationDiffAmtInAddlCrcy1 | ||
| ValuationDiffAmtInAddlCrcy2 | P_ARLineItem_9 | ValuationDiffAmtInAddlCrcy2 | ||
| ValuationDiffAmtInCoCodeCrcy | P_ARLineItem_9 | ValuationDiffAmtInCoCodeCrcy | ||
| ValueDate | P_ARLineItem_9 | ValueDate | ||
| WBSElement | P_ARLineItem_9 | WBSElement | ||
| WithholdingTaxAmount | P_ARLineItem_9 | WithholdingTaxAmount | ||
| WithholdingTaxBaseAmount | P_ARLineItem_9 | WithholdingTaxBaseAmount | ||
| WithholdingTaxExemptionAmt | P_ARLineItem_9 | WithholdingTaxExemptionAmt | ||
| BPBankAccountInternalID | P_ARLineItem_9 | BPBankAccountInternalID | ||
| HouseBank | P_ARLineItem_9 | HouseBank | ||
| CaseID | _CaseAttribute | CaseID | ||
| DisputeCasePriority | _CaseAttribute | DisputeCasePriority | ||
| DisputeCasePriorityName | _CaseAttribute | DisputeCasePriorityName | ||
| DisputeCaseTitle | _CaseAttribute | DisputeCaseTitle | ||
| DisputeCaseReason | _CaseAttribute | DisputeCaseReason | ||
| DisputeCaseReasonName | _CaseAttribute | DisputeCaseReasonName | ||
| DisputeCaseStatus | _CaseAttribute | DisputeCaseStatus | ||
| DisputeCaseStatusName | _CaseAttribute | DisputeCaseStatusName | ||
| DisputeCaseProcessor | _CaseAttribute | DisputeCaseProcessor | ||
| DisputeCaseProcessorFullName | _CaseAttribute | DisputeCaseProcessorFullName | ||
| DisputeCaseUUID | _CaseAttribute | DisputeCaseUUID | ||
| Creditor | P_ARLineItem_9 | Creditor | ||
| AdditionalCurrency1Role | ||||
| AdditionalCurrency2Role | ||||
| BranchCode | P_ARLineItem_9 | BranchCode | ||
| ReferenceDocumentType | P_ARLineItem_9 | ReferenceDocumentType | ||
| OriginalReferenceDocument | P_ARLineItem_9 | OriginalReferenceDocument | ||
| ReferenceDocumentLogicalSystem | P_ARLineItem_9 | ReferenceDocumentLogicalSystem | ||
| BillOfExchangeUsageDocument | P_ARLineItem_9 | BillOfExchangeUsageDocument | ||
| BOEUsageDocFiscalYear | P_ARLineItem_9 | BOEUsageDocFiscalYear | ||
| BOEUsageDocLineItem | P_ARLineItem_9 | BOEUsageDocLineItem | ||
| JointVenture | P_ARLineItem_9 | JointVenture | ||
| JointVentureCostRecoveryCode | P_ARLineItem_9 | JointVentureCostRecoveryCode | ||
| JointVentureBillingType | P_ARLineItem_9 | JointVentureBillingType | ||
| JointVentureCorporateEquityGrp | P_ARLineItem_9 | JointVentureCorporateEquityGrp |
@AbapCatalog.sqlViewName: 'PARLINEITEM4'
@AbapCatalog.compiler.compareFilter:true
@AbapCatalog.preserveKey:true
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
// To get rid of a database division by zero error the case statement for the field HWBASSTE in CDS view P_ARLineItem_2
// and the case statement for field NET_GROSS_RATIO in P_ARLineItem_1 have the field ITEM_TYPE_BRANCH in their condition
// as a temporary solution. In case the union in P_ARLineItem_4 is changed in a way that a union branch is removed,
// or a new union branch is added, then the ITEM_TYPE_BRANCH related condition in these case statements
// need to be checked and eventually adjusted!
define view P_ARLineItem_4
with parameters
P_DisputeCaseAccessIsGranted : boole_d
as
// posted debit items
select from P_ARLineItem_9(P_DisputeCaseAccessIsGranted : :P_DisputeCaseAccessIsGranted)
left outer to one join P_ProcIntegDsputCase as _CaseAttribute on DisputeCaseObjectKey = _CaseAttribute.ObjectKey
and P_ARLineItem_9.DisputeCaseAccessIsGranted = 'X'
association [0..1] to P_ARLineItem_Base_Bset as _BsetBase on $projection.CompanyCode = _BsetBase.CompanyCode
and $projection.AccountingDocument = _BsetBase.AccountingDocument
and $projection.FiscalYear = _BsetBase.FiscalYear
association [0..1] to P_ARLineItem_Sum_Bset as _BsetTax on $projection.CompanyCode = _BsetTax.CompanyCode
and $projection.AccountingDocument = _BsetTax.AccountingDocument
and $projection.FiscalYear = _BsetTax.FiscalYear
{
key P_ARLineItem_9.CompanyCode as CompanyCode,
key P_ARLineItem_9.AccountingDocument as AccountingDocument,
key P_ARLineItem_9.FiscalYear as FiscalYear,
key P_ARLineItem_9.AccountingDocumentItem as AccountingDocumentItem,
_JournalEntry.AccountingDocCreatedByUser as AccountingDocCreatedByUser,
P_ARLineItem_9.AccountingDocumentCategory as AccountingDocumentCategory,
P_ARLineItem_9._JournalEntry.AccountingDocumentCreationDate as AccountingDocumentCreationDate,
P_ARLineItem_9.AccountingDocumentType as AccountingDocumentType,
P_ARLineItem_9.AccountsReceivableIsPledged as AccountsReceivableIsPledged,
P_ARLineItem_9.AdditionalCurrency1 as AdditionalCurrency1,
P_ARLineItem_9.AdditionalCurrency2 as AdditionalCurrency2,
P_ARLineItem_9.AlternativeGLAccount as AlternativeGLAccount,
P_ARLineItem_9.AmountInAdditionalCurrency1 as AmountInAdditionalCurrency1,
P_ARLineItem_9.AmountInAdditionalCurrency2 as AmountInAdditionalCurrency2,
P_ARLineItem_9.AmountInBalanceTransacCrcy as AmountInBalanceTransacCrcy,
P_ARLineItem_9.AmountInCompanyCodeCurrency as AmountInCompanyCodeCurrency,
P_ARLineItem_9.AmountInFunctionalCurrency as AmountInFunctionalCurrency,
P_ARLineItem_9.AmountInPaymentCurrency as AmountInPaymentCurrency,
P_ARLineItem_9.AmountInTransactionCurrency as AmountInTransactionCurrency,
P_ARLineItem_9.AssetContract as AssetContract,
P_ARLineItem_9.AssignmentReference as AssignmentReference,
P_ARLineItem_9.BalanceTransactionCurrency as BalanceTransactionCurrency,
P_ARLineItem_9.BillingDocument as BillingDocument,
P_ARLineItem_9.BillOfExchangeUsage as BillOfExchangeUsage,
P_ARLineItem_9.Branch as Branch,
P_ARLineItem_9.BusinessArea as BusinessArea,
P_ARLineItem_9.BusinessPlace as BusinessPlace,
P_ARLineItem_9.CashDiscount1Days as CashDiscount1Days,
P_ARLineItem_9.CashDiscount1DueDate as CashDiscount1DueDate,
P_ARLineItem_9.CashDiscount1Percent as CashDiscount1Percent,
P_ARLineItem_9.CashDiscount2Days as CashDiscount2Days,
P_ARLineItem_9.CashDiscount2Percent as CashDiscount2Percent,
P_ARLineItem_9.CashDiscountAmount as CashDiscountAmount,
P_ARLineItem_9.CashDiscountAmtInCoCodeCrcy as CashDiscountAmtInCoCodeCrcy,
P_ARLineItem_9.CashDiscountBaseAmount as CashDiscountBaseAmount,
P_ARLineItem_9.CashFlowType as CashFlowType,
P_ARLineItem_9.ClearingAccountingDocument as ClearingAccountingDocument,
P_ARLineItem_9.ClearingDate as ClearingDate,
P_ARLineItem_9.ClearingDocFiscalYear as ClearingDocFiscalYear,
P_ARLineItem_9.ClearingIsReversed as ClearingIsReversed,
P_ARLineItem_9.CompanyCodeCurrency as CompanyCodeCurrency,
P_ARLineItem_9.CostCenter as CostCenter,
P_ARLineItem_9.CreditControlArea as CreditControlArea,
P_ARLineItem_9.ReceivableAlternativePayer as ReceivableAlternativePayer,
P_ARLineItem_9.DataExchangeInstruction1 as DataExchangeInstruction1,
P_ARLineItem_9.DataExchangeInstruction2 as DataExchangeInstruction2,
P_ARLineItem_9.DataExchangeInstruction3 as DataExchangeInstruction3,
P_ARLineItem_9.DataExchangeInstruction4 as DataExchangeInstruction4,
P_ARLineItem_9.DebitCreditCode as DebitCreditCode,
P_ARLineItem_9.Debtor as Debtor,
P_ARLineItem_9.DocumentDate as DocumentDate,
' ' as DocumentIsArchived,
P_ARLineItem_9.DocumentItemText as DocumentItemText,
P_ARLineItem_9._JournalEntry.DocumentReferenceID as DocumentReferenceID,
P_ARLineItem_9.DueCalculationBaseDate as DueCalculationBaseDate,
P_ARLineItem_9.DunningArea as DunningArea,
P_ARLineItem_9.DunningBlockingReason as DunningBlockingReason,
P_ARLineItem_9.DunningLevel as DunningLevel,
P_ARLineItem_9.FinancialAccountType as FinancialAccountType,
P_ARLineItem_9.FiscalPeriod as FiscalPeriod,
P_ARLineItem_9.FixedAsset as FixedAsset,
P_ARLineItem_9.FixedCashDiscount as FixedCashDiscount,
P_ARLineItem_9.FollowOnDocumentType as FollowOnDocumentType,
P_ARLineItem_9.StateCentralBankPaymentReason as StateCentralBankPaymentReason,
P_ARLineItem_9.SupplyingCountry as SupplyingCountry,
P_ARLineItem_9.FunctionalCurrency as FunctionalCurrency,
P_ARLineItem_9.FundsCenter as FundsCenter,
P_ARLineItem_9.GLAccount as GLAccount,
P_ARLineItem_9.HasPaymentOrder as HasPaymentOrder,
P_ARLineItem_9.HedgedAmount as HedgedAmount,
P_ARLineItem_9.HouseBankAccount as HouseBankAccount,
P_ARLineItem_9.InvoiceList as InvoiceList,
P_ARLineItem_9.InvoiceReference as InvoiceReference,
P_ARLineItem_9.IsSalesRelated as IsSalesRelated,
P_ARLineItem_9.IsUsedInPaymentTransaction as IsUsedInPaymentTransaction,
// Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.
// The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.
@Consumption.hidden: true
cast ( 'BSEG_DEBIT_SIDE_BRANCH' as char30 ) as ITEM_TYPE_BRANCH,
P_ARLineItem_9.LastDunningDate as LastDunningDate,
P_ARLineItem_9.MasterFixedAsset as MasterFixedAsset,
P_ARLineItem_9.DunningKey as DunningKey,
P_ARLineItem_9.NetDueDate as NetDueDate,
P_ARLineItem_9.NetPaymentDays as NetPaymentDays,
P_ARLineItem_9.OffsettingAccount as OffsettingAccount,
P_ARLineItem_9.OffsettingAccountType as OffsettingAccountType,
P_ARLineItem_9.OrderID as OrderID,
P_ARLineItem_9.PartnerCompany as PartnerCompany,
P_ARLineItem_9.PaymentBlockingReason as PaymentBlockingReason,
P_ARLineItem_9.PaymentCardItem as PaymentCardItem,
P_ARLineItem_9.PaymentCardPaymentSettlement as PaymentCardPaymentSettlement,
P_ARLineItem_9.PaymentCurrency as PaymentCurrency,
P_ARLineItem_9.PaymentDifferenceReason as PaymentDifferenceReason,
P_ARLineItem_9.PaymentMethod as PaymentMethod,
P_ARLineItem_9.PaymentMethodSupplement as PaymentMethodSupplement,
P_ARLineItem_9.PaymentReference as PaymentReference,
P_ARLineItem_9.PaymentTerms as PaymentTerms,
P_ARLineItem_9.PlannedAmtInTransactionCrcy as PlannedAmtInTransactionCrcy,
P_ARLineItem_9.Plant as Plant,
P_ARLineItem_9.PostingDate as PostingDate,
P_ARLineItem_9.PostingKey as PostingKey,
P_ARLineItem_9.ProfitCenter as ProfitCenter,
P_ARLineItem_9.PurchasingDocument as PurchasingDocument,
P_ARLineItem_9.PurchasingDocumentItem as PurchasingDocumentItem,
P_ARLineItem_9.RealEstateObject as RealEstateObject,
P_ARLineItem_9.Reference1IDByBusinessPartner as Reference1IDByBusinessPartner,
P_ARLineItem_9.Reference2IDByBusinessPartner as Reference2IDByBusinessPartner,
P_ARLineItem_9.Reference3IDByBusinessPartner as Reference3IDByBusinessPartner,
P_ARLineItem_9.SalesDocument as SalesDocument,
P_ARLineItem_9.SalesDocumentItem as SalesDocumentItem,
P_ARLineItem_9.ScheduleLine as ScheduleLine,
P_ARLineItem_9.SettlementReferenceDate as SettlementReferenceDate,
'' as SourceCompanyCode,
P_ARLineItem_9.SpecialGLCode as SpecialGLCode,
P_ARLineItem_9.SpecialGLTransactionType as SpecialGLTransactionType,
_BsetTax.TaxAmountInCoCodeCrcy as TaxAmountInCoCodeCrcy,
_BsetBase.TaxBaseAmountInCoCodeCrcy as TaxBaseAmountInCoCodeCrcy,
P_ARLineItem_9._CompanyCode._Country.TaxCalculationProcedure as TaxCalculationProcedure,
P_ARLineItem_9.TaxCode as TaxCode,
P_ARLineItem_9.TaxCountry as TaxCountry,
_JournalEntry.TaxReportingDate as TaxReportingDate,
P_ARLineItem_9.TaxSection as TaxSection,
P_ARLineItem_9.TransactionCurrency as TransactionCurrency,
P_ARLineItem_9.TreasuryContractType as TreasuryContractType,
P_ARLineItem_9.ValuationDiffAmtInAddlCrcy1 as ValuationDiffAmtInAddlCrcy1,
P_ARLineItem_9.ValuationDiffAmtInAddlCrcy2 as ValuationDiffAmtInAddlCrcy2,
P_ARLineItem_9.ValuationDiffAmtInCoCodeCrcy as ValuationDiffAmtInCoCodeCrcy,
P_ARLineItem_9.ValueDate as ValueDate,
P_ARLineItem_9.WBSElement as WBSElement,
P_ARLineItem_9.WithholdingTaxAmount as WithholdingTaxAmount,
P_ARLineItem_9.WithholdingTaxBaseAmount as WithholdingTaxBaseAmount,
P_ARLineItem_9.WithholdingTaxExemptionAmt as WithholdingTaxExemptionAmt,
P_ARLineItem_9.BPBankAccountInternalID as BPBankAccountInternalID,
P_ARLineItem_9.HouseBank as HouseBank,
_CaseAttribute.CaseID,
_CaseAttribute.DisputeCasePriority,
_CaseAttribute.DisputeCasePriorityName,
_CaseAttribute.DisputeCaseTitle,
_CaseAttribute.DisputeCaseReason,
_CaseAttribute.DisputeCaseReasonName,
_CaseAttribute.DisputeCaseStatus,
_CaseAttribute.DisputeCaseStatusName,
_CaseAttribute.DisputeCaseProcessor,
_CaseAttribute.DisputeCaseProcessorFullName,
_CaseAttribute.DisputeCaseUUID,
P_ARLineItem_9.Creditor as Creditor,
cast( _JournalEntry.AdditionalCurrency1Role as fis_adl1_currole preserving type ) as AdditionalCurrency1Role,
cast( _JournalEntry.AdditionalCurrency2Role as fis_adl2_currole preserving type ) as AdditionalCurrency2Role,
P_ARLineItem_9.BranchCode as BranchCode,
P_ARLineItem_9.ReferenceDocumentType as ReferenceDocumentType,
P_ARLineItem_9.OriginalReferenceDocument as OriginalReferenceDocument,
P_ARLineItem_9.ReferenceDocumentLogicalSystem as ReferenceDocumentLogicalSystem,
P_ARLineItem_9.BillOfExchangeUsageDocument as BillOfExchangeUsageDocument,
P_ARLineItem_9.BOEUsageDocFiscalYear as BOEUsageDocFiscalYear,
P_ARLineItem_9.BOEUsageDocLineItem as BOEUsageDocLineItem,
P_ARLineItem_9.JointVenture as JointVenture,
P_ARLineItem_9.JointVentureCostRecoveryCode as JointVentureCostRecoveryCode,
P_ARLineItem_9.JointVentureBillingType as JointVentureBillingType,
P_ARLineItem_9.JointVentureCorporateEquityGrp as JointVentureCorporateEquityGrp
}
where
(
FinancialAccountType = 'D'
)
and not(
AccountingDocumentCategory = 'D'
)
and not //D = Recurring entry document
(
AccountingDocumentCategory = 'M'
)
union all
// posted credit items of mixed accounts
select from I_ReceivablesPayablesItem
// inner join P_ARLineItem_6 as MixAcc1 on Creditor = MixAcc1.Supplier
inner join far_mult_mix_acc as MixAcc1 on I_ReceivablesPayablesItem.Creditor = MixAcc1.supplier
and I_ReceivablesPayablesItem.CompanyCode = MixAcc1.companycode
association [0..1] to P_ARLineItem_Base_Bset as _BsetBase on $projection.CompanyCode = _BsetBase.CompanyCode
and $projection.AccountingDocument = _BsetBase.AccountingDocument
and $projection.FiscalYear = _BsetBase.FiscalYear
association [0..1] to P_ARLineItem_Sum_Bset as _BsetTax on $projection.CompanyCode = _BsetTax.CompanyCode
and $projection.AccountingDocument = _BsetTax.AccountingDocument
and $projection.FiscalYear = _BsetTax.FiscalYear
{
key I_ReceivablesPayablesItem.CompanyCode as CompanyCode,
key I_ReceivablesPayablesItem.AccountingDocument as AccountingDocument,
key I_ReceivablesPayablesItem.FiscalYear as FiscalYear,
key I_ReceivablesPayablesItem.AccountingDocumentItem as AccountingDocumentItem,
_JournalEntry.AccountingDocCreatedByUser as AccountingDocCreatedByUser,
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,
MixAcc1.debtor as Debtor,
I_ReceivablesPayablesItem.DocumentDate as DocumentDate,
' ' as DocumentIsArchived,
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,
// Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.
// The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.
@Consumption.hidden: true
'BSEG_CREDIT_SIDE_BRANCH' as ITEM_TYPE_BRANCH,
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,
'' as SourceCompanyCode,
I_ReceivablesPayablesItem.SpecialGLCode as SpecialGLCode,
I_ReceivablesPayablesItem.SpecialGLTransactionType as SpecialGLTransactionType,
_BsetTax.TaxAmountInCoCodeCrcy as TaxAmountInCoCodeCrcy,
_BsetBase.TaxBaseAmountInCoCodeCrcy as TaxBaseAmountInCoCodeCrcy,
I_ReceivablesPayablesItem._CompanyCode._Country.TaxCalculationProcedure as TaxCalculationProcedure,
I_ReceivablesPayablesItem.TaxCode as TaxCode,
I_ReceivablesPayablesItem.TaxCountry as TaxCountry,
_JournalEntry.TaxReportingDate as TaxReportingDate,
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,
'' as CaseID,
'0' as DisputeCasePriority,
'' as DisputeCasePriorityName,
'' as DisputeCaseTitle,
'' as DisputeCaseReason,
'' as DisputeCaseReasonName,
'00' as DisputeCaseStatus,
'' as DisputeCaseStatusName,
'' as DisputeCaseProcessor,
'' as DisputeCaseProcessorFullName,
'' as DisputeCaseUUID,
I_ReceivablesPayablesItem.Creditor as Creditor,
cast( _JournalEntry.AdditionalCurrency1Role as fis_adl1_currole preserving type ) as AdditionalCurrency1Role,
cast( _JournalEntry.AdditionalCurrency2Role as fis_adl2_currole preserving type ) as AdditionalCurrency2Role,
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
}
where
FinancialAccountType = 'K'
and not(
AccountingDocumentCategory = 'D'
) //D = Recurring entry document
and not(
AccountingDocumentCategory = 'M'
) //M = Sample document
and MixAcc1.supplier != ''
union all
// parked debit items
select from I_ParkedOplAcctgDocRblsItem
{
key I_ParkedOplAcctgDocRblsItem.CompanyCode,
key I_ParkedOplAcctgDocRblsItem.SourceAccountingDocument as AccountingDocument,
key I_ParkedOplAcctgDocRblsItem.SourceFiscalYear as FiscalYear,
key I_ParkedOplAcctgDocRblsItem.SourceAccountingDocumentItem as AccountingDocumentItem,
_ParkedOplAcctgDocument.AccountingDocCreatedByUser as AccountingDocCreatedByUser,
_ParkedOplAcctgDocument.AccountingDocumentCategory as AccountingDocumentCategory,
_ParkedOplAcctgDocument.AccountingDocumentCreationDate as AccountingDocumentCreationDate,
_ParkedOplAcctgDocument.AccountingDocumentType as AccountingDocumentType,
' ' as AccountsReceivableIsPledged,
I_ParkedOplAcctgDocRblsItem.AdditionalCurrency1 as AdditionalCurrency1,
I_ParkedOplAcctgDocRblsItem.AdditionalCurrency2 as AdditionalCurrency2,
' ' as AlternativeGLAccount,
I_ParkedOplAcctgDocRblsItem.AmountInAdditionalCurrency1 as AmountInAdditionalCurrency1,
I_ParkedOplAcctgDocRblsItem.AmountInAdditionalCurrency2 as AmountInAdditionalCurrency2,
0 as AmountInBalanceTransacCrcy,
I_ParkedOplAcctgDocRblsItem.AmountInCompanyCodeCurrency as AmountInCompanyCodeCurrency,
0 as AmountInFunctionalCurrency,
I_ParkedOplAcctgDocRblsItem.AmountInPaymentCurrency as AmountInPaymentCurrency,
I_ParkedOplAcctgDocRblsItem.AmountInTransactionCurrency as AmountInTransactionCurrency,
I_ParkedOplAcctgDocRblsItem.AssetContract as AssetContract,
I_ParkedOplAcctgDocRblsItem.AssignmentReference as AssignmentReference,
' ' as BalanceTransactionCurrency,
' ' as BillingDocument,
' ' as BillOfExchangeUsage,
I_ParkedOplAcctgDocRblsItem.BranchAccount as Branch,
I_ParkedOplAcctgDocRblsItem.BusinessArea as BusinessArea,
I_ParkedOplAcctgDocRblsItem.BusinessPlace as BusinessPlace,
I_ParkedOplAcctgDocRblsItem.CashDiscount1Days as CashDiscount1Days,
I_ParkedOplAcctgDocRblsItem.CashDiscount1DueDate as CashDiscount1DueDate,
I_ParkedOplAcctgDocRblsItem.CashDiscount1Percent as CashDiscount1Percent,
I_ParkedOplAcctgDocRblsItem.CashDiscount2Days as CashDiscount2Days,
I_ParkedOplAcctgDocRblsItem.CashDiscount2Percent as CashDiscount2Percent,
I_ParkedOplAcctgDocRblsItem.CashDiscountAmount as CashDiscountAmount,
I_ParkedOplAcctgDocRblsItem.CashDiscountAmtInCoCodeCrcy as CashDiscountAmtInCoCodeCrcy,
I_ParkedOplAcctgDocRblsItem.CashDiscountBaseAmount as CashDiscountBaseAmount,
I_ParkedOplAcctgDocRblsItem.CashFlowType as CashFlowType,
' ' as ClearingAccountingDocument,
'00000000' as ClearingDate,
'0000' as ClearingDocFiscalYear,
' ' as ClearingIsReversed,
I_ParkedOplAcctgDocRblsItem.CompanyCodeCurrency as CompanyCodeCurrency,
' ' as CostCenter,
I_ParkedOplAcctgDocRblsItem.CreditControlArea as CreditControlArea,
I_ParkedOplAcctgDocRblsItem.AlternativePayeePayer as ReceivableAlternativePayer,
I_ParkedOplAcctgDocRblsItem.DataExchangeInstruction1 as DataExchangeInstruction1,
I_ParkedOplAcctgDocRblsItem.DataExchangeInstruction2 as DataExchangeInstruction2,
I_ParkedOplAcctgDocRblsItem.DataExchangeInstruction3 as DataExchangeInstruction3,
I_ParkedOplAcctgDocRblsItem.DataExchangeInstruction4 as DataExchangeInstruction4,
I_ParkedOplAcctgDocRblsItem.DebitCreditCode as DebitCreditCode,
I_ParkedOplAcctgDocRblsItem.Customer as Debtor,
_ParkedOplAcctgDocument.DocumentDate as DocumentDate,
' ' as DocumentIsArchived,
I_ParkedOplAcctgDocRblsItem.DocumentItemText as DocumentItemText,
_ParkedOplAcctgDocument.DocumentReferenceID as DocumentReferenceID,
I_ParkedOplAcctgDocRblsItem.DueCalculationBaseDate as DueCalculationBaseDate,
I_ParkedOplAcctgDocRblsItem.DunningArea as DunningArea,
I_ParkedOplAcctgDocRblsItem.DunningBlockingReason as DunningBlockingReason,
I_ParkedOplAcctgDocRblsItem.DunningLevel as DunningLevel,
'D' as FinancialAccountType,
_ParkedOplAcctgDocument.FiscalPeriod as FiscalPeriod,
' ' as FixedAsset,
' ' as FixedCashDiscount,
I_ParkedOplAcctgDocRblsItem.FollowOnDocumentType as FollowOnDocumentType,
I_ParkedOplAcctgDocRblsItem.StateCentralBankPaymentReason as StateCentralBankPaymentReason,
I_ParkedOplAcctgDocRblsItem.SupplyingCountry as SupplyingCountry,
' ' as FunctionalCurrency,
I_ParkedOplAcctgDocRblsItem.FundsCenter as FundsCenter,
I_ParkedOplAcctgDocRblsItem.GLAccount as GLAccount,
' ' as HasPaymentOrder,
0 as HedgedAmount,
I_ParkedOplAcctgDocRblsItem.HouseBankAccount as HouseBankAccount,
I_ParkedOplAcctgDocRblsItem.InvoiceList as InvoiceList,
I_ParkedOplAcctgDocRblsItem.InvoiceReference as InvoiceReference,
I_ParkedOplAcctgDocRblsItem.IsSalesRelated as IsSalesRelated,
' ' as IsUsedInPaymentTransaction,
// Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.
// The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.
@Consumption.hidden: true
'VBSEGD_BRANCH' as ITEM_TYPE_BRANCH,
I_ParkedOplAcctgDocRblsItem.LastDunningDate as LastDunningDate,
' ' as MasterFixedAsset,
I_ParkedOplAcctgDocRblsItem.DunningKey as DunningKey,
I_ParkedOplAcctgDocRblsItem.NetDueDate as NetDueDate,
I_ParkedOplAcctgDocRblsItem.NetPaymentDays as NetPaymentDays,
' ' as OffsettingAccount,
' ' as OffsettingAccountType,
' ' as OrderID,
_ParkedOplAcctgDocument.PartnerCompany as PartnerCompany,
I_ParkedOplAcctgDocRblsItem.PaymentBlockingReason as PaymentBlockingReason,
'000' as PaymentCardItem,
' ' as PaymentCardPaymentSettlement,
I_ParkedOplAcctgDocRblsItem.PaymentCurrency as PaymentCurrency,
I_ParkedOplAcctgDocRblsItem.PaymentDifferenceReason as PaymentDifferenceReason,
I_ParkedOplAcctgDocRblsItem.PaymentMethod as PaymentMethod,
I_ParkedOplAcctgDocRblsItem.PaymentMethodSupplement as PaymentMethodSupplement,
I_ParkedOplAcctgDocRblsItem.PaymentReference as PaymentReference,
I_ParkedOplAcctgDocRblsItem.PaymentTerms as PaymentTerms,
I_ParkedOplAcctgDocRblsItem.PlannedAmtInTransactionCrcy as PlannedAmtInTransactionCrcy,
' ' as Plant,
_ParkedOplAcctgDocument.PostingDate as PostingDate,
I_ParkedOplAcctgDocRblsItem.PostingKey as PostingKey,
' ' as ProfitCenter,
' ' as PurchasingDocument,
'00000' as PurchasingDocumentItem,
' ' as RealEstateObject,
I_ParkedOplAcctgDocRblsItem.Reference1IDByBusinessPartner as Reference1IDByBusinessPartner,
I_ParkedOplAcctgDocRblsItem.Reference2IDByBusinessPartner as Reference2IDByBusinessPartner,
I_ParkedOplAcctgDocRblsItem.Reference3IDByBusinessPartner as Reference3IDByBusinessPartner,
' ' as SalesDocument,
'000000' as SalesDocumentItem,
'0000' as ScheduleLine,
'00000000' as SettlementReferenceDate,
I_ParkedOplAcctgDocRblsItem.SourceCompanyCode as SourceCompanyCode,
I_ParkedOplAcctgDocRblsItem.SpecialGLCode as SpecialGLCode,
I_ParkedOplAcctgDocRblsItem.SpecialGLTransactionType as SpecialGLTransactionType,
0 as TaxAmountInCoCodeCrcy,
0 as TaxBaseAmountInCoCodeCrcy,
I_ParkedOplAcctgDocRblsItem._CompanyCode._Country.TaxCalculationProcedure as TaxCalculationProcedure,
I_ParkedOplAcctgDocRblsItem.TaxCode as TaxCode,
I_ParkedOplAcctgDocRblsItem.TaxCountry as TaxCountry,
_ParkedOplAcctgDocument.TaxReportingDate as TaxReportingDate,
I_ParkedOplAcctgDocRblsItem.TaxSection as TaxSection,
I_ParkedOplAcctgDocRblsItem.TransactionCurrency as TransactionCurrency,
I_ParkedOplAcctgDocRblsItem.TreasuryContractType as TreasuryContractType,
0 as ValuationDiffAmtInAddlCrcy1,
0 as ValuationDiffAmtInAddlCrcy2,
0 as ValuationDiffAmtInCoCodeCrcy,
I_ParkedOplAcctgDocRblsItem.ValueDate as ValueDate,
'00000000' as WBSElement,
0 as WithholdingTaxAmount,
0 as WithholdingTaxBaseAmount,
0 as WithholdingTaxExemptionAmt,
I_ParkedOplAcctgDocRblsItem.BPBankAccountInternalID as BPBankAccountInternalID,
I_ParkedOplAcctgDocRblsItem.HouseBank as HouseBank,
'' as CaseID,
'0' as DisputeCasePriority,
'' as DisputeCasePriorityName,
'' as DisputeCaseTitle,
'' as DisputeCaseReason,
'' as DisputeCaseReasonName,
'00' as DisputeCaseStatus,
'' as DisputeCaseStatusName,
'' as DisputeCaseProcessor,
'' as DisputeCaseProcessorFullName,
'' as DisputeCaseUUID,
' ' as Creditor,
_ParkedOplAcctgDocument.AdditionalCurrency1Role as AdditionalCurrency1Role,
_ParkedOplAcctgDocument.AdditionalCurrency2Role as AdditionalCurrency2Role,
I_ParkedOplAcctgDocRblsItem.BranchCode as BranchCode,
_ParkedOplAcctgDocument.ReferenceDocumentType as ReferenceDocumentType,
_ParkedOplAcctgDocument.OriginalReferenceDocument as OriginalReferenceDocument,
_ParkedOplAcctgDocument.ReferenceDocumentLogicalSystem as ReferenceDocumentLogicalSystem,
' ' as BillOfExchangeUsageDocument,
' ' as BOEUsageDocFiscalYear,
' ' as BOEUsageDocLineItem,
I_ParkedOplAcctgDocRblsItem.JointVenture as JointVenture,
' ' as JointVentureCostRecoveryCode,
I_ParkedOplAcctgDocRblsItem.JointVentureBillingType as JointVentureBillingType,
I_ParkedOplAcctgDocRblsItem.JointVentureEquityGroup as JointVentureCorporateEquityGrp
}
union all
// parked credit items of mixed accounts
select from I_ParkedOplAcctgDocPyblsItem
// inner join P_ARLineItem_6 as MixAcc2 on Creditor = MixAcc2.Supplier
inner join far_mult_mix_acc as MixAcc2 on I_ParkedOplAcctgDocPyblsItem.Supplier = MixAcc2.supplier
and I_ParkedOplAcctgDocPyblsItem.CompanyCode = MixAcc2.companycode
{
key I_ParkedOplAcctgDocPyblsItem.CompanyCode,
key I_ParkedOplAcctgDocPyblsItem.SourceAccountingDocument as AccountingDocument,
key I_ParkedOplAcctgDocPyblsItem.SourceFiscalYear as FiscalYear,
key I_ParkedOplAcctgDocPyblsItem.SourceAccountingDocumentItem as AccountingDocumentItem,
_ParkedOplAcctgDocument.AccountingDocCreatedByUser as AccountingDocCreatedByUser,
_ParkedOplAcctgDocument.AccountingDocumentCategory as AccountingDocumentCategory,
_ParkedOplAcctgDocument.AccountingDocumentCreationDate as AccountingDocumentCreationDate,
_ParkedOplAcctgDocument.AccountingDocumentType as AccountingDocumentType,
' ' as AccountsReceivableIsPledged,
I_ParkedOplAcctgDocPyblsItem.AdditionalCurrency1 as AdditionalCurrency1,
I_ParkedOplAcctgDocPyblsItem.AdditionalCurrency2 as AdditionalCurrency2,
' ' as AlternativeGLAccount,
I_ParkedOplAcctgDocPyblsItem.AmountInAdditionalCurrency1 as AmountInAdditionalCurrency1,
I_ParkedOplAcctgDocPyblsItem.AmountInAdditionalCurrency2 as AmountInAdditionalCurrency2,
0 as AmountInBalanceTransacCrcy,
I_ParkedOplAcctgDocPyblsItem.AmountInCompanyCodeCurrency as AmountInCompanyCodeCurrency,
0 as AmountInFunctionalCurrency,
I_ParkedOplAcctgDocPyblsItem.AmountInPaymentCurrency as AmountInPaymentCurrency,
I_ParkedOplAcctgDocPyblsItem.AmountInTransactionCurrency as AmountInTransactionCurrency,
I_ParkedOplAcctgDocPyblsItem.AssetContract as AssetContract,
I_ParkedOplAcctgDocPyblsItem.AssignmentReference as AssignmentReference,
' ' as BalanceTransactionCurrency,
' ' as BillingDocument,
' ' as BillOfExchangeUsage,
I_ParkedOplAcctgDocPyblsItem.BranchAccount as Branch,
I_ParkedOplAcctgDocPyblsItem.BusinessArea as BusinessArea,
I_ParkedOplAcctgDocPyblsItem.BusinessPlace as BusinessPlace,
I_ParkedOplAcctgDocPyblsItem.CashDiscount1Days as CashDiscount1Days,
I_ParkedOplAcctgDocPyblsItem.CashDiscount1DueDate as CashDiscount1DueDate,
I_ParkedOplAcctgDocPyblsItem.CashDiscount1Percent as CashDiscount1Percent,
I_ParkedOplAcctgDocPyblsItem.CashDiscount2Days as CashDiscount2Days,
I_ParkedOplAcctgDocPyblsItem.CashDiscount2Percent as CashDiscount2Percent,
I_ParkedOplAcctgDocPyblsItem.CashDiscountAmount as CashDiscountAmount,
I_ParkedOplAcctgDocPyblsItem.CashDiscountAmtInCoCodeCrcy as CashDiscountAmtInCoCodeCrcy,
I_ParkedOplAcctgDocPyblsItem.CashDiscountBaseAmount as CashDiscountBaseAmount,
I_ParkedOplAcctgDocPyblsItem.CashFlowType as CashFlowType,
' ' as ClearingAccountingDocument,
'00000000' as ClearingDate,
'0000' as ClearingDocFiscalYear,
' ' as ClearingIsReversed,
I_ParkedOplAcctgDocPyblsItem.CompanyCodeCurrency as CompanyCodeCurrency,
' ' as CostCenter,
'' as CreditControlArea,
I_ParkedOplAcctgDocPyblsItem.AlternativePayeePayer as ReceivableAlternativePayer,
I_ParkedOplAcctgDocPyblsItem.DataExchangeInstruction1 as DataExchangeInstruction1,
I_ParkedOplAcctgDocPyblsItem.DataExchangeInstruction2 as DataExchangeInstruction2,
I_ParkedOplAcctgDocPyblsItem.DataExchangeInstruction3 as DataExchangeInstruction3,
I_ParkedOplAcctgDocPyblsItem.DataExchangeInstruction4 as DataExchangeInstruction4,
I_ParkedOplAcctgDocPyblsItem.DebitCreditCode as DebitCreditCode,
MixAcc2.debtor as Debtor,
_ParkedOplAcctgDocument.DocumentDate as DocumentDate,
' ' as DocumentIsArchived,
I_ParkedOplAcctgDocPyblsItem.DocumentItemText as DocumentItemText,
_ParkedOplAcctgDocument.DocumentReferenceID as DocumentReferenceID,
I_ParkedOplAcctgDocPyblsItem.DueCalculationBaseDate as DueCalculationBaseDate,
I_ParkedOplAcctgDocPyblsItem.DunningArea as DunningArea,
I_ParkedOplAcctgDocPyblsItem.DunningBlockingReason as DunningBlockingReason,
I_ParkedOplAcctgDocPyblsItem.DunningLevel as DunningLevel,
'K' as FinancialAccountType,
_ParkedOplAcctgDocument.FiscalPeriod as FiscalPeriod,
' ' as FixedAsset,
I_ParkedOplAcctgDocPyblsItem.FixedCashDiscount as FixedCashDiscount,
I_ParkedOplAcctgDocPyblsItem.FollowOnDocumentType as FollowOnDocumentType,
I_ParkedOplAcctgDocPyblsItem.StateCentralBankPaymentReason as StateCentralBankPaymentReason,
I_ParkedOplAcctgDocPyblsItem.SupplyingCountry as SupplyingCountry,
' ' as FunctionalCurrency,
I_ParkedOplAcctgDocPyblsItem.FundsCenter as FundsCenter,
I_ParkedOplAcctgDocPyblsItem.GLAccount as GLAccount,
' ' as HasPaymentOrder,
0 as HedgedAmount,
I_ParkedOplAcctgDocPyblsItem.HouseBankAccount as HouseBankAccount,
I_ParkedOplAcctgDocPyblsItem.InvoiceList as InvoiceList,
I_ParkedOplAcctgDocPyblsItem.InvoiceReference as InvoiceReference,
I_ParkedOplAcctgDocPyblsItem.IsSalesRelated as IsSalesRelated,
' ' as IsUsedInPaymentTransaction,
// Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.
// The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.
@Consumption.hidden: true
'VBSEGK_BRANCH' as ITEM_TYPE_BRANCH,
I_ParkedOplAcctgDocPyblsItem.LastDunningDate as LastDunningDate,
' ' as MasterFixedAsset,
I_ParkedOplAcctgDocPyblsItem.DunningKey as DunningKey,
I_ParkedOplAcctgDocPyblsItem.NetDueDate as NetDueDate,
I_ParkedOplAcctgDocPyblsItem.NetPaymentDays as NetPaymentDays,
' ' as OffsettingAccount,
' ' as OffsettingAccountType,
' ' as OrderID,
_ParkedOplAcctgDocument.PartnerCompany as PartnerCompany,
I_ParkedOplAcctgDocPyblsItem.PaymentBlockingReason as PaymentBlockingReason,
'000' as PaymentCardItem,
' ' as PaymentCardPaymentSettlement,
I_ParkedOplAcctgDocPyblsItem.PaymentCurrency as PaymentCurrency,
I_ParkedOplAcctgDocPyblsItem.PaymentDifferenceReason as PaymentDifferenceReason,
I_ParkedOplAcctgDocPyblsItem.PaymentMethod as PaymentMethod,
I_ParkedOplAcctgDocPyblsItem.PaymentMethodSupplement as PaymentMethodSupplement,
I_ParkedOplAcctgDocPyblsItem.PaymentReference as PaymentReference,
I_ParkedOplAcctgDocPyblsItem.PaymentTerms as PaymentTerms,
I_ParkedOplAcctgDocPyblsItem.PlannedAmtInTransactionCrcy as PlannedAmtInTransactionCrcy,
' ' as Plant,
_ParkedOplAcctgDocument.PostingDate as PostingDate,
I_ParkedOplAcctgDocPyblsItem.PostingKey as PostingKey,
' ' as ProfitCenter,
' ' as PurchasingDocument,
'00000' as PurchasingDocumentItem,
' ' as RealEstateObject,
I_ParkedOplAcctgDocPyblsItem.Reference1IDByBusinessPartner as Reference1IDByBusinessPartner,
I_ParkedOplAcctgDocPyblsItem.Reference2IDByBusinessPartner as Reference2IDByBusinessPartner,
I_ParkedOplAcctgDocPyblsItem.Reference3IDByBusinessPartner as Reference3IDByBusinessPartner,
' ' as SalesDocument,
'000000' as SalesDocumentItem,
'0000' as ScheduleLine,
I_ParkedOplAcctgDocPyblsItem.SettlementReferenceDate as SettlementReferenceDate,
I_ParkedOplAcctgDocPyblsItem.SourceCompanyCode as SourceCompanyCode,
I_ParkedOplAcctgDocPyblsItem.SpecialGLCode as SpecialGLCode,
I_ParkedOplAcctgDocPyblsItem.SpecialGLTransactionType as SpecialGLTransactionType,
0 as TaxAmountInCoCodeCrcy,
0 as TaxBaseAmountInCoCodeCrcy,
I_ParkedOplAcctgDocPyblsItem._CompanyCode._Country.TaxCalculationProcedure as TaxCalculationProcedure,
I_ParkedOplAcctgDocPyblsItem.TaxCode as TaxCode,
I_ParkedOplAcctgDocPyblsItem.TaxCountry as TaxCountry,
_ParkedOplAcctgDocument.TaxReportingDate as TaxReportingDate,
I_ParkedOplAcctgDocPyblsItem.TaxSection as TaxSection,
I_ParkedOplAcctgDocPyblsItem.TransactionCurrency as TransactionCurrency,
I_ParkedOplAcctgDocPyblsItem.TreasuryContractType as TreasuryContractType,
0 as ValuationDiffAmtInAddlCrcy1,
0 as ValuationDiffAmtInAddlCrcy2,
0 as ValuationDiffAmtInCoCodeCrcy,
I_ParkedOplAcctgDocPyblsItem.ValueDate as ValueDate,
'00000000' as WBSElement,
I_ParkedOplAcctgDocPyblsItem.WithholdingTaxAmount as WithholdingTaxAmount,
I_ParkedOplAcctgDocPyblsItem.WithholdingTaxBaseAmount as WithholdingTaxBaseAmount,
I_ParkedOplAcctgDocPyblsItem.WithholdingTaxExemptionAmt as WithholdingTaxExemptionAmt,
I_ParkedOplAcctgDocPyblsItem.BPBankAccountInternalID as BPBankAccountInternalID,
I_ParkedOplAcctgDocPyblsItem.HouseBank as HouseBank,
'' as CaseID,
'0' as DisputeCasePriority,
'' as DisputeCasePriorityName,
'' as DisputeCaseTitle,
'' as DisputeCaseReason,
'' as DisputeCaseReasonName,
'00' as DisputeCaseStatus,
'' as DisputeCaseStatusName,
'' as DisputeCaseProcessor,
'' as DisputeCaseProcessorFullName,
'' as DisputeCaseUUID,
I_ParkedOplAcctgDocPyblsItem.Supplier as Creditor,
_ParkedOplAcctgDocument.AdditionalCurrency1Role as AdditionalCurrency1Role,
_ParkedOplAcctgDocument.AdditionalCurrency2Role as AdditionalCurrency2Role,
I_ParkedOplAcctgDocPyblsItem.BranchCode as BranchCode,
_ParkedOplAcctgDocument.ReferenceDocumentType as ReferenceDocumentType,
_ParkedOplAcctgDocument.OriginalReferenceDocument as OriginalReferenceDocument,
_ParkedOplAcctgDocument.ReferenceDocumentLogicalSystem as ReferenceDocumentLogicalSystem,
' ' as BillOfExchangeUsageDocument,
' ' as BOEUsageDocFiscalYear,
' ' as BOEUsageDocLineItem,
I_ParkedOplAcctgDocPyblsItem.JointVenture as JointVenture,
' ' as JointVentureCostRecoveryCode,
I_ParkedOplAcctgDocPyblsItem.JointVentureBillingType as JointVentureBillingType,
I_ParkedOplAcctgDocPyblsItem.JointVentureEquityGroup as JointVentureCorporateEquityGrp
}
where
MixAcc2.supplier != ''
union all
select from P_ARLineItem_7
{
key P_ARLineItem_7.CompanyCode as CompanyCode,
key P_ARLineItem_7.AccountingDocument as AccountingDocument,
key P_ARLineItem_7.FiscalYear as FiscalYear,
key P_ARLineItem_7.AccountingDocumentItem as AccountingDocumentItem,
' ' as AccountingDocCreatedByUser,
P_ARLineItem_7.AccountingDocumentCategory as AccountingDocumentCategory,
P_ARLineItem_7.CreationDate as AccountingDocumentCreationDate,
P_ARLineItem_7.AccountingDocumentType as AccountingDocumentType,
P_ARLineItem_7.AccountsReceivableIsPledged as AccountsReceivableIsPledged,
P_ARLineItem_7._AdditionalCompanyCurrency.AdditionalCurrency1 as AdditionalCurrency1,
P_ARLineItem_7._AdditionalCompanyCurrency.AdditionalCurrency2 as AdditionalCurrency2,
' ' as AlternativeGLAccount,
P_ARLineItem_7.AmountInAdditionalCurrency1 as AmountInAdditionalCurrency1,
P_ARLineItem_7.AmountInAdditionalCurrency2 as AmountInAdditionalCurrency2,
P_ARLineItem_7.AmountInBalanceTransacCrcy as AmountInBalanceTransacCrcy,
P_ARLineItem_7.AmountInCompanyCodeCurrency as AmountInCompanyCodeCurrency,
0 as AmountInFunctionalCurrency,
P_ARLineItem_7.AmountInPaymentCurrency as AmountInPaymentCurrency,
P_ARLineItem_7.AmountInTransactionCurrency as AmountInTransactionCurrency,
P_ARLineItem_7.AssetContract as AssetContract,
P_ARLineItem_7.AssignmentReference as AssignmentReference,
P_ARLineItem_7.BalanceTransactionCurrency as BalanceTransactionCurrency,
P_ARLineItem_7.BillingDocument as BillingDocument,
P_ARLineItem_7.BillOfExchangeUsage as BillOfExchangeUsage,
P_ARLineItem_7.Branch as Branch,
P_ARLineItem_7.BusinessArea as BusinessArea,
P_ARLineItem_7.BusinessPlace as BusinessPlace,
P_ARLineItem_7.CashDiscount1Days as CashDiscount1Days,
'00000000' as CashDiscount1DueDate,
P_ARLineItem_7.CashDiscount1Percent as CashDiscount1Percent,
P_ARLineItem_7.CashDiscount2Days as CashDiscount2Days,
P_ARLineItem_7.CashDiscount2Percent as CashDiscount2Percent,
P_ARLineItem_7.CashDiscountAmount as CashDiscountAmount,
P_ARLineItem_7.CashDiscountAmtInCoCodeCrcy as CashDiscountAmtInCoCodeCrcy,
P_ARLineItem_7.CashDiscountBaseAmount as CashDiscountBaseAmount,
P_ARLineItem_7.CashFlowType as CashFlowType,
P_ARLineItem_7.ClearingAccountingDocument as ClearingAccountingDocument,
P_ARLineItem_7.ClearingDate as ClearingDate,
P_ARLineItem_7.ClearingDocFiscalYear as ClearingDocFiscalYear,
P_ARLineItem_7.ClearingIsReversed as ClearingIsReversed,
_CompanyCode.Currency as CompanyCodeCurrency,
P_ARLineItem_7.CostCenter as CostCenter,
P_ARLineItem_7.CreditControlArea as CreditControlArea,
P_ARLineItem_7.ReceivableAlternativePayer as ReceivableAlternativePayer,
P_ARLineItem_7.DataExchangeInstruction1 as DataExchangeInstruction1,
P_ARLineItem_7.DataExchangeInstruction2 as DataExchangeInstruction2,
P_ARLineItem_7.DataExchangeInstruction3 as DataExchangeInstruction3,
P_ARLineItem_7.DataExchangeInstruction4 as DataExchangeInstruction4,
P_ARLineItem_7.DebitCreditCode as DebitCreditCode,
P_ARLineItem_7.Debtor as Debtor,
P_ARLineItem_7.DocumentDate as DocumentDate,
P_ARLineItem_7.DocumentIsArchived as DocumentIsArchived,
P_ARLineItem_7.DocumentItemText as DocumentItemText,
P_ARLineItem_7.DocumentReferenceID as DocumentReferenceID,
P_ARLineItem_7.DueCalculationBaseDate as DueCalculationBaseDate,
P_ARLineItem_7.DunningArea as DunningArea,
P_ARLineItem_7.DunningBlockingReason as DunningBlockingReason,
P_ARLineItem_7.DunningLevel as DunningLevel,
'D' as FinancialAccountType,
P_ARLineItem_7.FiscalPeriod as FiscalPeriod,
P_ARLineItem_7.FixedAsset as FixedAsset,
P_ARLineItem_7.FixedCashDiscount as FixedCashDiscount,
P_ARLineItem_7.FollowOnDocumentType as FollowOnDocumentType,
P_ARLineItem_7.StateCentralBankPaymentReason as StateCentralBankPaymentReason,
P_ARLineItem_7.SupplyingCountry as SupplyingCountry,
' ' as FunctionalCurrency,
P_ARLineItem_7.FundsCenter as FundsCenter,
P_ARLineItem_7.GLAccount as GLAccount,
P_ARLineItem_7.HasPaymentOrder as HasPaymentOrder,
P_ARLineItem_7.HedgedAmount as HedgedAmount,
P_ARLineItem_7.HouseBankAccount as HouseBankAccount,
P_ARLineItem_7.InvoiceList as InvoiceList,
P_ARLineItem_7.InvoiceReference as InvoiceReference,
' ' as IsSalesRelated,
P_ARLineItem_7.IsUsedInPaymentTransaction as IsUsedInPaymentTransaction,
// Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.
// The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.
@Consumption.hidden: true
'BSAD_BCK_BRANCH' as ITEM_TYPE_BRANCH,
P_ARLineItem_7.LastDunningDate as LastDunningDate,
P_ARLineItem_7.MasterFixedAsset as MasterFixedAsset,
P_ARLineItem_7.DunningKey as DunningKey,
'00000000' as NetDueDate,
P_ARLineItem_7.NetPaymentDays as NetPaymentDays,
' ' as OffsettingAccount,
' ' as OffsettingAccountType,
P_ARLineItem_7.OrderID as OrderID,
P_ARLineItem_7.PartnerCompany as PartnerCompany,
P_ARLineItem_7.PaymentBlockingReason as PaymentBlockingReason,
P_ARLineItem_7.PaymentCardItem as PaymentCardItem,
P_ARLineItem_7.PaymentCardPaymentSettlement as PaymentCardPaymentSettlement,
P_ARLineItem_7.PaymentCurrency as PaymentCurrency,
P_ARLineItem_7.PaymentDifferenceReason as PaymentDifferenceReason,
P_ARLineItem_7.PaymentMethod as PaymentMethod,
P_ARLineItem_7.PaymentMethodSupplement as PaymentMethodSupplement,
P_ARLineItem_7.PaymentReference as PaymentReference,
P_ARLineItem_7.PaymentTerms as PaymentTerms,
0 as PlannedAmtInTransactionCrcy,
' ' as Plant,
P_ARLineItem_7.PostingDate as PostingDate,
P_ARLineItem_7.PostingKey as PostingKey,
P_ARLineItem_7.ProfitCenter as ProfitCenter,
' ' as PurchasingDocument,
'00000' as PurchasingDocumentItem,
P_ARLineItem_7.RealEstateObject as RealEstateObject,
P_ARLineItem_7.Reference1IDByBusinessPartner as Reference1IDByBusinessPartner,
P_ARLineItem_7.Reference2IDByBusinessPartner as Reference2IDByBusinessPartner,
P_ARLineItem_7.Reference3IDByBusinessPartner as Reference3IDByBusinessPartner,
P_ARLineItem_7.SalesDocument as SalesDocument,
P_ARLineItem_7.SalesDocumentItem as SalesDocumentItem,
P_ARLineItem_7.ScheduleLine as ScheduleLine,
P_ARLineItem_7.SettlementReferenceDate as SettlementReferenceDate,
'' as SourceCompanyCode,
P_ARLineItem_7.SpecialGLCode as SpecialGLCode,
P_ARLineItem_7.SpecialGLTransactionType as SpecialGLTransactionType,
0 as TaxAmountInCoCodeCrcy,
0 as TaxBaseAmountInCoCodeCrcy,
P_ARLineItem_7._CompanyCode._Country.TaxCalculationProcedure as TaxCalculationProcedure,
P_ARLineItem_7.TaxCode as TaxCode,
P_ARLineItem_7.TaxCountry as TaxCountry,
' ' as TaxReportingDate,
P_ARLineItem_7.TaxSection as TaxSection,
P_ARLineItem_7.TransactionCurrency as TransactionCurrency,
P_ARLineItem_7.TreasuryContractType as TreasuryContractType,
P_ARLineItem_7.ValuationDiffAmtInAddlCrcy1 as ValuationDiffAmtInAddlCrcy1,
P_ARLineItem_7.ValuationDiffAmtInAddlCrcy2 as ValuationDiffAmtInAddlCrcy2,
P_ARLineItem_7.ValuationDiffAmtInCoCodeCrcy as ValuationDiffAmtInCoCodeCrcy,
'00000000' as ValueDate,
P_ARLineItem_7.WBSElement as WBSElement,
0 as WithholdingTaxAmount,
0 as WithholdingTaxBaseAmount,
0 as WithholdingTaxExemptionAmt,
P_ARLineItem_7.BPBankAccountInternalID as BPBankAccountInternalID,
P_ARLineItem_7.HouseBank as HouseBank,
'' as CaseID,
'0' as DisputeCasePriority,
'' as DisputeCasePriorityName,
'' as DisputeCaseTitle,
'' as DisputeCaseReason,
'' as DisputeCaseReasonName,
'00' as DisputeCaseStatus,
'' as DisputeCaseStatusName,
'' as DisputeCaseProcessor,
'' as DisputeCaseProcessorFullName,
'' as DisputeCaseUUID,
' ' as Creditor,
_AdditionalCompanyCurrency.AdditionalCurrency1Role,
_AdditionalCompanyCurrency.AdditionalCurrency2Role,
' ' as BranchCode,
P_ARLineItem_7.ReferenceDocumentType as ReferenceDocumentType,
P_ARLineItem_7.OriginalReferenceDocument as OriginalReferenceDocument,
P_ARLineItem_7.ReferenceDocumentLogicalSystem as ReferenceDocumentLogicalSystem,
' ' as BillOfExchangeUsageDocument,
' ' as BOEUsageDocFiscalYear,
' ' as BOEUsageDocLineItem,
' ' as JointVenture,
' ' as JointVentureCostRecoveryCode,
' ' as JointVentureBillingType,
' ' as JointVentureCorporateEquityGrp
}
union all
select from P_ARLineItem_8
{
key P_ARLineItem_8.CompanyCode as CompanyCode,
key P_ARLineItem_8.AccountingDocument as AccountingDocument,
key P_ARLineItem_8.FiscalYear as FiscalYear,
key P_ARLineItem_8.AccountingDocumentItem as AccountingDocumentItem,
' ' as AccountingDocCreatedByUser,
P_ARLineItem_8.AccountingDocumentCategory as AccountingDocumentCategory,
P_ARLineItem_8.CreationDate as AccountingDocumentCreationDate,
P_ARLineItem_8.AccountingDocumentType as AccountingDocumentType,
' ' as AccountsReceivableIsPledged,
P_ARLineItem_8._AdditionalCompanyCurrency.AdditionalCurrency1 as AdditionalCurrency1,
P_ARLineItem_8._AdditionalCompanyCurrency.AdditionalCurrency2 as AdditionalCurrency2,
' ' as AlternativeGLAccount,
P_ARLineItem_8.AmountInAdditionalCurrency1 as AmountInAdditionalCurrency1,
P_ARLineItem_8.AmountInAdditionalCurrency2 as AmountInAdditionalCurrency2,
P_ARLineItem_8.AmountInBalanceTransacCrcy as AmountInBalanceTransacCrcy,
P_ARLineItem_8.AmountInCompanyCodeCurrency as AmountInCompanyCodeCurrency,
0 as AmountInFunctionalCurrency,
P_ARLineItem_8.AmountInPaymentCurrency as AmountInPaymentCurrency,
P_ARLineItem_8.AmountInTransactionCurrency as AmountInTransactionCurrency,
P_ARLineItem_8.AssetContract as AssetContract,
P_ARLineItem_8.AssignmentReference as AssignmentReference,
P_ARLineItem_8.BalanceTransactionCurrency as BalanceTransactionCurrency,
' ' as BillingDocument,
' ' as BillOfExchangeUsage,
P_ARLineItem_8.Branch as Branch,
P_ARLineItem_8.BusinessArea as BusinessArea,
P_ARLineItem_8.BusinessPlace as BusinessPlace,
P_ARLineItem_8.CashDiscount1Days as CashDiscount1Days,
'00000000' as CashDiscount1DueDate,
P_ARLineItem_8.CashDiscount1Percent as CashDiscount1Percent,
P_ARLineItem_8.CashDiscount2Days as CashDiscount2Days,
P_ARLineItem_8.CashDiscount2Percent as CashDiscount2Percent,
P_ARLineItem_8.CashDiscountAmount as CashDiscountAmount,
P_ARLineItem_8.CashDiscountAmtInCoCodeCrcy as CashDiscountAmtInCoCodeCrcy,
P_ARLineItem_8.CashDiscountBaseAmount as CashDiscountBaseAmount,
P_ARLineItem_8.CashFlowType as CashFlowType,
P_ARLineItem_8.ClearingAccountingDocument as ClearingAccountingDocument,
P_ARLineItem_8.ClearingDate as ClearingDate,
P_ARLineItem_8.ClearingDocFiscalYear as ClearingDocFiscalYear,
P_ARLineItem_8.ClearingIsReversed as ClearingIsReversed,
_CompanyCode.Currency as CompanyCodeCurrency,
P_ARLineItem_8.CostCenter as CostCenter,
'' as CreditControlArea,
P_ARLineItem_8.ReceivableAlternativePayer as ReceivableAlternativePayer,
P_ARLineItem_8.DataExchangeInstruction1 as DataExchangeInstruction1,
P_ARLineItem_8.DataExchangeInstruction2 as DataExchangeInstruction2,
P_ARLineItem_8.DataExchangeInstruction3 as DataExchangeInstruction3,
P_ARLineItem_8.DataExchangeInstruction4 as DataExchangeInstruction4,
P_ARLineItem_8.DebitCreditCode as DebitCreditCode,
P_ARLineItem_8.Debtor as Debtor,
P_ARLineItem_8.DocumentDate as DocumentDate,
P_ARLineItem_8.DocumentIsArchived as DocumentIsArchived,
P_ARLineItem_8.DocumentItemText as DocumentItemText,
P_ARLineItem_8.DocumentReferenceID as DocumentReferenceID,
P_ARLineItem_8.DueCalculationBaseDate as DueCalculationBaseDate,
P_ARLineItem_8.DunningArea as DunningArea,
P_ARLineItem_8.DunningBlockingReason as DunningBlockingReason,
P_ARLineItem_8.DunningLevel as DunningLevel,
'K' as FinancialAccountType,
P_ARLineItem_8.FiscalPeriod as FiscalPeriod,
P_ARLineItem_8.FixedAsset as FixedAsset,
P_ARLineItem_8.FixedCashDiscount as FixedCashDiscount,
P_ARLineItem_8.FollowOnDocumentType as FollowOnDocumentType,
P_ARLineItem_8.StateCentralBankPaymentReason as StateCentralBankPaymentReason,
P_ARLineItem_8.SupplyingCountry as SupplyingCountry,
' ' as FunctionalCurrency,
P_ARLineItem_8.FundsCenter as FundsCenter,
P_ARLineItem_8.GLAccount as GLAccount,
P_ARLineItem_8.HasPaymentOrder as HasPaymentOrder,
0 as HedgedAmount,
P_ARLineItem_8.HouseBankAccount as HouseBankAccount,
P_ARLineItem_8.InvoiceList as InvoiceList,
P_ARLineItem_8.InvoiceReference as InvoiceReference,
' ' as IsSalesRelated,
P_ARLineItem_8.IsUsedInPaymentTransaction as IsUsedInPaymentTransaction,
// Do not use the auxiliary field ITEM_TYPE_BRANCH. It is only for SAP internal usage. It might be removed in the future.
// The field is needed for performance optimization. It specifies the branch of the Union per which a line item was selected.
@Consumption.hidden: true
'BSAK_BCK_BRANCH' as ITEM_TYPE_BRANCH,
P_ARLineItem_8.LastDunningDate as LastDunningDate,
P_ARLineItem_8.MasterFixedAsset as MasterFixedAsset,
P_ARLineItem_8.DunningKey as DunningKey,
'00000000' as NetDueDate,
P_ARLineItem_8.NetPaymentDays as NetPaymentDays,
' ' as OffsettingAccount,
' ' as OffsettingAccountType,
P_ARLineItem_8.OrderID as OrderID,
P_ARLineItem_8.PartnerCompany as PartnerCompany,
P_ARLineItem_8.PaymentBlockingReason as PaymentBlockingReason,
'000' as PaymentCardItem,
' ' as PaymentCardPaymentSettlement,
P_ARLineItem_8.PaymentCurrency as PaymentCurrency,
P_ARLineItem_8.PaymentDifferenceReason as PaymentDifferenceReason,
P_ARLineItem_8.PaymentMethod as PaymentMethod,
P_ARLineItem_8.PaymentMethodSupplement as PaymentMethodSupplement,
P_ARLineItem_8.PaymentReference as PaymentReference,
P_ARLineItem_8.PaymentTerms as PaymentTerms,
0 as PlannedAmtInTransactionCrcy,
' ' as Plant,
P_ARLineItem_8.PostingDate as PostingDate,
P_ARLineItem_8.PostingKey as PostingKey,
P_ARLineItem_8.ProfitCenter as ProfitCenter,
P_ARLineItem_8.PurchasingDocument as PurchasingDocument,
P_ARLineItem_8.PurchasingDocumentItem as PurchasingDocumentItem,
P_ARLineItem_8.RealEstateObject as RealEstateObject,
P_ARLineItem_8.Reference1IDByBusinessPartner as Reference1IDByBusinessPartner,
P_ARLineItem_8.Reference2IDByBusinessPartner as Reference2IDByBusinessPartner,
P_ARLineItem_8.Reference3IDByBusinessPartner as Reference3IDByBusinessPartner,
' ' as SalesDocument,
'000000' as SalesDocumentItem,
'0000' as ScheduleLine,
P_ARLineItem_8.SettlementReferenceDate as SettlementReferenceDate,
'' as SourceCompanyCode,
P_ARLineItem_8.SpecialGLCode as SpecialGLCode,
P_ARLineItem_8.SpecialGLTransactionType as SpecialGLTransactionType,
0 as TaxAmountInCoCodeCrcy,
0 as TaxBaseAmountInCoCodeCrcy,
P_ARLineItem_8._CompanyCode._Country.TaxCalculationProcedure as TaxCalculationProcedure,
P_ARLineItem_8.TaxCode as TaxCode,
P_ARLineItem_8.TaxCountry as TaxCountry,
' ' as TaxReportingDate,
P_ARLineItem_8.TaxSection as TaxSection,
P_ARLineItem_8.TransactionCurrency as TransactionCurrency,
P_ARLineItem_8.TreasuryContractType as TreasuryContractType,
P_ARLineItem_8.ValuationDiffAmtInAddlCrcy1 as ValuationDiffAmtInAddlCrcy1,
P_ARLineItem_8.ValuationDiffAmtInAddlCrcy2 as ValuationDiffAmtInAddlCrcy2,
P_ARLineItem_8.ValuationDiffAmtInCoCodeCrcy as ValuationDiffAmtInCoCodeCrcy,
'00000000' as ValueDate,
P_ARLineItem_8.WBSElement as WBSElement,
P_ARLineItem_8.WithholdingTaxAmount as WithholdingTaxAmount,
P_ARLineItem_8.WithholdingTaxBaseAmount as WithholdingTaxBaseAmount,
P_ARLineItem_8.WithholdingTaxExemptionAmt as WithholdingTaxExemptionAmt,
P_ARLineItem_8.BPBankAccountInternalID as BPBankAccountInternalID,
P_ARLineItem_8.HouseBank as HouseBank,
'' as CaseID,
'0' as DisputeCasePriority,
'' as DisputeCasePriorityName,
'' as DisputeCaseTitle,
'' as DisputeCaseReason,
'' as DisputeCaseReasonName,
'00' as DisputeCaseStatus,
'' as DisputeCaseStatusName,
'' as DisputeCaseProcessor,
'' as DisputeCaseProcessorFullName,
'' as DisputeCaseUUID,
P_ARLineItem_8.Supplier as Creditor,
_AdditionalCompanyCurrency.AdditionalCurrency1Role,
_AdditionalCompanyCurrency.AdditionalCurrency2Role,
' ' as BranchCode,
P_ARLineItem_8.ReferenceDocumentType as ReferenceDocumentType,
P_ARLineItem_8.OriginalReferenceDocument as OriginalReferenceDocument,
P_ARLineItem_8.ReferenceDocumentLogicalSystem as ReferenceDocumentLogicalSystem,
' ' as BillOfExchangeUsageDocument,
' ' as BOEUsageDocFiscalYear,
' ' as BOEUsageDocLineItem,
' ' as JointVenture,
' ' as JointVentureCostRecoveryCode,
' ' as JointVentureBillingType,
' ' as JointVentureCorporateEquityGrp
};
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA