P_ARLineItem_10
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)
| Source | Alias | Join Type |
|---|---|---|
| I_ReceivablesPayablesItem | I_ReceivablesPayablesItem | from |
Annotations (5)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PARLINEITEM10 | view | |
| VDM.viewType | #BASIC | view | |
| VDM.private | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view |
Fields (120)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA