P_RU_ExchDiff0

DDL: P_RU_EXCHDIFF0 SQL: PRUEXCHDIFF0 Type: view CONSUMPTION
205 Fields 2 Data Sources

P_RU_ExchDiff0 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_RU_Contract, I_ReceivablesPayablesItem) and exposes 205 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_RU_Contract _Contract left_outer
I_ReceivablesPayablesItem RP from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PRUEXCHDIFF0 view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view

Fields (205)

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
FiscalYearVariant I_ReceivablesPayablesItem FiscalYearVariant FY Variant
ClearingDate I_ReceivablesPayablesItem ClearingDate Clearing Date
ClearingCreationDate I_ReceivablesPayablesItem ClearingCreationDate Clrg Creation Date
ClearingAccountingDocument I_ReceivablesPayablesItem ClearingAccountingDocument Clearing Journal Entry
PostingKey I_ReceivablesPayablesItem PostingKey Posting Key
FinancialAccountType I_ReceivablesPayablesItem FinancialAccountType Fin. Account Type
SpecialGLCode I_ReceivablesPayablesItem SpecialGLCode Special G/L Ind
SpecialGLTransactionType I_ReceivablesPayablesItem SpecialGLTransactionType Transact.Type
TargetSpecialGLCode I_ReceivablesPayablesItem TargetSpecialGLCode Trg.Sp.G/L Ind.
DebitCreditCode I_ReceivablesPayablesItem DebitCreditCode Single-Character Flag
BusinessArea I_ReceivablesPayablesItem BusinessArea Business Area
PartnerBusinessArea I_ReceivablesPayablesItem PartnerBusinessArea Trdg Part.BA
TaxCode I_ReceivablesPayablesItem TaxCode Tax Code
WithholdingTaxCode I_ReceivablesPayablesItem WithholdingTaxCode WTax Code
AmountInCompanyCodeCurrency I_ReceivablesPayablesItem AmountInCompanyCodeCurrency Local Crcy Amt
AmountInTransactionCurrency I_ReceivablesPayablesItem AmountInTransactionCurrency Pt Crcy Amt
AmountInBalanceTransacCrcy I_ReceivablesPayablesItem AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
BalanceTransactionCurrency I_ReceivablesPayablesItem BalanceTransactionCurrency Currency
TaxAmountInCoCodeCrcy I_ReceivablesPayablesItem TaxAmountInCoCodeCrcy Tax Amount in Company Code Currency
TaxAmount I_ReceivablesPayablesItem TaxAmount Tax Amt in Rptg Crcy
TaxBaseAmountInTransCrcy I_ReceivablesPayablesItem TaxBaseAmountInTransCrcy Value-Added Tax
TaxBaseAmountInCoCodeCrcy I_ReceivablesPayablesItem TaxBaseAmountInCoCodeCrcy TxBaseAmt CoCodeCrcy
TaxType I_ReceivablesPayablesItem TaxType Tax Type
TaxItemGroup I_ReceivablesPayablesItem TaxItemGroup Tax doc. item number
TransactionTypeDetermination I_ReceivablesPayablesItem TransactionTypeDetermination Transaction Key
WithholdingTaxBaseAmount I_ReceivablesPayablesItem WithholdingTaxBaseAmount WTax Base Amt
ValuationDiffAmtInCoCodeCrcy I_ReceivablesPayablesItem ValuationDiffAmtInCoCodeCrcy
ValuationDiffAmtInAddlCrcy1 I_ReceivablesPayablesItem ValuationDiffAmtInAddlCrcy1
ValueDate I_ReceivablesPayablesItem ValueDate Value Date
AssignmentReference
DocumentItemText I_ReceivablesPayablesItem DocumentItemText Text
PartnerCompany I_ReceivablesPayablesItem PartnerCompany Trading Partner
FinancialTransactionType I_ReceivablesPayablesItem FinancialTransactionType Transact. Type
CorporateGroupAccount I_ReceivablesPayablesItem CorporateGroupAccount Group Account Number
PlanningLevel I_ReceivablesPayablesItem PlanningLevel Planning Level
PlannedAmtInTransactionCrcy I_ReceivablesPayablesItem PlannedAmtInTransactionCrcy Plnd Amt Trans. Crcy
ControllingArea I_ReceivablesPayablesItem ControllingArea Controlling Area
CostCenter I_ReceivablesPayablesItem CostCenter Cost Center
WBSElementInternalID I_ReceivablesPayablesItem WBSElementInternalID WBS Internal ID
OrderID I_ReceivablesPayablesItem OrderID Order ID
BillingDocument I_ReceivablesPayablesItem BillingDocument SD Document
SalesDocument I_ReceivablesPayablesItem SalesDocument SD Document
SalesDocumentItem I_ReceivablesPayablesItem SalesDocumentItem Sales Document Item
ScheduleLine I_ReceivablesPayablesItem ScheduleLine Schedule Line
MasterFixedAsset I_ReceivablesPayablesItem MasterFixedAsset Fixed Asset
FixedAsset I_ReceivablesPayablesItem FixedAsset Sub-number
AssetTransactionType I_ReceivablesPayablesItem AssetTransactionType Trans.Type
Employee I_ReceivablesPayablesItem Employee Object ID
IsSalesRelated I_ReceivablesPayablesItem IsSalesRelated Is Sales Related
LineItemDisplayIsEnabled I_ReceivablesPayablesItem LineItemDisplayIsEnabled Line Items
IsOpenItemManaged I_ReceivablesPayablesItem IsOpenItemManaged Open Item Management
AddressAndBankIsSetManually I_ReceivablesPayablesItem AddressAndBankIsSetManually Address and Bank is Set Manually
IsAutomaticallyCreated I_ReceivablesPayablesItem IsAutomaticallyCreated Is Automatically Created
IsUsedInPaymentTransaction I_ReceivablesPayablesItem IsUsedInPaymentTransaction Is Used In Payment Transaction
GLAccount I_ReceivablesPayablesItem GLAccount General Ledger
Debtor I_ReceivablesPayablesItem Debtor Debtor
Creditor I_ReceivablesPayablesItem Creditor Supplier
Branch I_ReceivablesPayablesItem Branch Repository branch
IsBalanceSheetAccount I_ReceivablesPayablesItem IsBalanceSheetAccount Is Balance Sheet Account
ProfitLossAccountType I_ReceivablesPayablesItem ProfitLossAccountType Profit Loss Account Type
SpecialGLAccountAssignment I_ReceivablesPayablesItem SpecialGLAccountAssignment Special G/L Assignmt
DueCalculationBaseDate I_ReceivablesPayablesItem DueCalculationBaseDate Due Calculation Base Date
PaymentTerms I_ReceivablesPayablesItem PaymentTerms Pyt Terms
CashDiscount1Days I_ReceivablesPayablesItem CashDiscount1Days Days from Baseline Date for Payment
CashDiscount2Days I_ReceivablesPayablesItem CashDiscount2Days Days from Baseline Date for Payment
NetPaymentDays I_ReceivablesPayablesItem NetPaymentDays Net Pmt Terms Period
CashDiscount1Percent I_ReceivablesPayablesItem CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent I_ReceivablesPayablesItem CashDiscount2Percent Disc. Percent 2
CashDiscountBaseAmount I_ReceivablesPayablesItem CashDiscountBaseAmount Cash Dscnt Base Amt
CashDiscountAmtInCoCodeCrcy I_ReceivablesPayablesItem CashDiscountAmtInCoCodeCrcy Discount Amt
CashDiscountAmount I_ReceivablesPayablesItem CashDiscountAmount CD Amount
PaymentMethod I_ReceivablesPayablesItem PaymentMethod Pymt Meth.
PaymentBlockingReason I_ReceivablesPayablesItem PaymentBlockingReason Pmnt block
FixedCashDiscount I_ReceivablesPayablesItem FixedCashDiscount Fixed Cash Discount
HouseBank I_ReceivablesPayablesItem HouseBank House Bank
TaxDistributionCode1 I_ReceivablesPayablesItem TaxDistributionCode1 Tax Distr. Code 1
TaxDistributionCode2 I_ReceivablesPayablesItem TaxDistributionCode2 Tax Distr. Code 2
TaxDistributionCode3 I_ReceivablesPayablesItem TaxDistributionCode3 Tax Distr. Code 3
InvoiceReference I_ReceivablesPayablesItem InvoiceReference Invoice Reference
InvoiceReferenceFiscalYear I_ReceivablesPayablesItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
InvoiceItemReference I_ReceivablesPayablesItem InvoiceItemReference Item
FollowOnDocumentType I_ReceivablesPayablesItem FollowOnDocumentType Follow-On Document Type
SupplyingCountry I_ReceivablesPayablesItem SupplyingCountry Supplying Ctry/Reg.
InvoiceList I_ReceivablesPayablesItem InvoiceList Invoice List
SettlementFiscalYearPeriod I_ReceivablesPayablesItem SettlementFiscalYearPeriod Settl.Period
BillOfExchangeUsage I_ReceivablesPayablesItem BillOfExchangeUsage BoE Usage
DunningKey I_ReceivablesPayablesItem DunningKey Dunning Key
DunningBlockingReason I_ReceivablesPayablesItem DunningBlockingReason Set Dunning Block
LastDunningDate I_ReceivablesPayablesItem LastDunningDate Last Dunned
DunningLevel I_ReceivablesPayablesItem DunningLevel Dunning Level
DunningArea I_ReceivablesPayablesItem DunningArea Dunning Area
WithholdingTaxAmount I_ReceivablesPayablesItem WithholdingTaxAmount Withholding Tax Amt
WithholdingTaxExemptionAmt I_ReceivablesPayablesItem WithholdingTaxExemptionAmt WTax-Exempt
Material I_ReceivablesPayablesItem Material Vehicle Model
Plant I_ReceivablesPayablesItem Plant Valuation Area
Quantity I_ReceivablesPayablesItem Quantity Value
BaseUnit I_ReceivablesPayablesItem BaseUnit Unit of Measure
QuantityInEntryUnit I_ReceivablesPayablesItem QuantityInEntryUnit Quantity in Unit of Entry
EntryUnit I_ReceivablesPayablesItem EntryUnit Unit of Entry
PurchaseOrderQty I_ReceivablesPayablesItem PurchaseOrderQty Purchase Order Quantity
PurchaseOrderPriceUnit I_ReceivablesPayablesItem PurchaseOrderPriceUnit Order Price Un.
PurchasingDocument I_ReceivablesPayablesItem PurchasingDocument Purchasing Document
PurchasingDocumentItem I_ReceivablesPayablesItem PurchasingDocumentItem Purchasing Doc. Item
AccountAssignmentNumber I_ReceivablesPayablesItem AccountAssignmentNumber Account Assgmt No.
IsCompletelyDelivered I_ReceivablesPayablesItem IsCompletelyDelivered Is completely delivered
MaterialPriceControl I_ReceivablesPayablesItem MaterialPriceControl Price Control
MaterialPriceUnitQty I_ReceivablesPayablesItem MaterialPriceUnitQty Price unit
ValuationArea I_ReceivablesPayablesItem ValuationArea Valuation Area
InventoryValuationType I_ReceivablesPayablesItem InventoryValuationType Valuation Type
InvoiceAmtInCoCodeCrcy I_ReceivablesPayablesItem InvoiceAmtInCoCodeCrcy
InvoiceAmountInFrgnCurrency I_ReceivablesPayablesItem InvoiceAmountInFrgnCurrency Invc. Amt Frgn Crcy
VATRegistration I_ReceivablesPayablesItem VATRegistration VAT Registration No.
DelivOfGoodsDestCountry I_ReceivablesPayablesItem DelivOfGoodsDestCountry Dest. C/R
DelivOfGoodsOriginCountry I_ReceivablesPayablesItem DelivOfGoodsOriginCountry Supplying C/R
PaymentDifferenceReason I_ReceivablesPayablesItem PaymentDifferenceReason Reason Code
ProfitCenter I_ReceivablesPayablesItem ProfitCenter Profit Center
JointVenture I_ReceivablesPayablesItem JointVenture Joint venture
JointVentureCostRecoveryCode I_ReceivablesPayablesItem JointVentureCostRecoveryCode Recovery Ind.
JointVentureEquityGroup I_ReceivablesPayablesItem JointVentureEquityGroup Joint Venture Equity Group
TreasuryContractType I_ReceivablesPayablesItem TreasuryContractType Treasury Contract Type
AssetContract I_ReceivablesPayablesItem AssetContract Asset Contract
CashFlowType I_ReceivablesPayablesItem CashFlowType Flow Type
TaxJurisdiction I_ReceivablesPayablesItem TaxJurisdiction Tax Jurisdiction
RealEstateObject I_ReceivablesPayablesItem RealEstateObject Real Estate Key
SettlementReferenceDate I_ReceivablesPayablesItem SettlementReferenceDate Reference date
CommitmentItem I_ReceivablesPayablesItem CommitmentItem Commitment item
CostObject I_ReceivablesPayablesItem CostObject Cost Object
ProjectNetwork I_ReceivablesPayablesItem ProjectNetwork Order
WBSElement I_ReceivablesPayablesItem WBSElement WBS Internal ID
ProfitabilitySegment I_ReceivablesPayablesItem ProfitabilitySegment Profitability Segment
JointVentureEquityType I_ReceivablesPayablesItem JointVentureEquityType Joint Venture Equity Type
IsEUTriangularDeal I_ReceivablesPayablesItem IsEUTriangularDeal Is EU Triangular Deal
CostOriginGroup I_ReceivablesPayablesItem CostOriginGroup Origin Group
AmountInAdditionalCurrency1 I_ReceivablesPayablesItem AmountInAdditionalCurrency1 Amount in Additional Currency 1
AmountInAdditionalCurrency2 I_ReceivablesPayablesItem AmountInAdditionalCurrency2 LC2 Amount
ValuationDiffAmtInAddlCrcy2 I_ReceivablesPayablesItem ValuationDiffAmtInAddlCrcy2
ClearingIsReversed I_ReceivablesPayablesItem ClearingIsReversed Clearing Is Reversed
PaymentMethodSupplement I_ReceivablesPayablesItem PaymentMethodSupplement Pmnt Meth. Sup.
AlternativeGLAccount I_ReceivablesPayablesItem AlternativeGLAccount Group Account
FundsCenter I_ReceivablesPayablesItem FundsCenter Funds Center
Fund I_ReceivablesPayablesItem Fund Sender Fund
PartnerProfitCenter I_ReceivablesPayablesItem PartnerProfitCenter Profit Center
Reference1IDByBusinessPartner I_ReceivablesPayablesItem Reference1IDByBusinessPartner Reference Key 1
Reference2IDByBusinessPartner I_ReceivablesPayablesItem Reference2IDByBusinessPartner Reference Key 2
PaymentCardItem I_ReceivablesPayablesItem PaymentCardItem Payment Card Item
PaymentCardPaymentSettlement I_ReceivablesPayablesItem PaymentCardPaymentSettlement Payment Card Payment Settlement
CreditControlArea I_ReceivablesPayablesItem CreditControlArea Credit Control Area
Reference3IDByBusinessPartner I_ReceivablesPayablesItem Reference3IDByBusinessPartner Reference Key 3
DataExchangeInstruction1 I_ReceivablesPayablesItem DataExchangeInstruction1 Instruction 1
DataExchangeInstruction2 I_ReceivablesPayablesItem DataExchangeInstruction2 Instruction 2
DataExchangeInstruction3 I_ReceivablesPayablesItem DataExchangeInstruction3 Instruction 3
DataExchangeInstruction4 I_ReceivablesPayablesItem DataExchangeInstruction4 Instruction 4
Region I_ReceivablesPayablesItem Region Venue Region
HasPaymentOrder I_ReceivablesPayablesItem HasPaymentOrder Payment Sent
PaymentReference I_ReceivablesPayablesItem PaymentReference Payment Reference
HedgedAmount I_ReceivablesPayablesItem HedgedAmount
TaxDeterminationDate I_ReceivablesPayablesItem TaxDeterminationDate Tx Determination Dte
ClearingItem I_ReceivablesPayablesItem ClearingItem Clearing Item
PaymentCurrency I_ReceivablesPayablesItem PaymentCurrency Payment Currency
AmountInPaymentCurrency I_ReceivablesPayablesItem AmountInPaymentCurrency Amount in Payment Currency
BusinessPlace I_ReceivablesPayablesItem BusinessPlace Business place
TaxSection I_ReceivablesPayablesItem TaxSection Tax Section
CostCtrActivityType I_ReceivablesPayablesItem CostCtrActivityType Activity Type
AccountsReceivableIsPledged I_ReceivablesPayablesItem AccountsReceivableIsPledged Accounts Receivable Is Pledged
BusinessProcess I_ReceivablesPayablesItem BusinessProcess Business Process
GrantID I_ReceivablesPayablesItem GrantID Sender Grant
FunctionalArea I_ReceivablesPayablesItem FunctionalArea Sendr Fctl Area
CustomerIsInExecution I_ReceivablesPayablesItem CustomerIsInExecution Customer Is In Execution
ClearingDocFiscalYear I_ReceivablesPayablesItem ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry
Segment I_ReceivablesPayablesItem Segment Segment number
PartnerSegment I_ReceivablesPayablesItem PartnerSegment Partner Segment
PartnerFunctionalArea I_ReceivablesPayablesItem PartnerFunctionalArea Rec. Fntcl Area
HouseBankAccount I_ReceivablesPayablesItem HouseBankAccount House Bank Account
CostElement I_ReceivablesPayablesItem CostElement G/L Account
ReferenceDocumentType I_ReceivablesPayablesItem ReferenceDocumentType Reference Document Type
OriginalReferenceDocument I_ReceivablesPayablesItem OriginalReferenceDocument Reference Key
ReferenceDocumentLogicalSystem I_ReceivablesPayablesItem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
FiscalPeriod I_ReceivablesPayablesItem FiscalPeriod Tax period
AccountingDocumentCategory I_ReceivablesPayablesItem AccountingDocumentCategory Journal Entry Category
PostingDate I_ReceivablesPayablesItem PostingDate Posting Date for GR
DocumentDate I_ReceivablesPayablesItem DocumentDate Journal Entry Date
TransactionCurrency I_ReceivablesPayablesItem TransactionCurrency Transaction Currency
AccountingDocumentType I_ReceivablesPayablesItem AccountingDocumentType Journal Entry Type
CompanyCodeCurrency I_ReceivablesPayablesItem CompanyCodeCurrency Local Currency
AdditionalCurrency1 I_ReceivablesPayablesItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_ReceivablesPayablesItem AdditionalCurrency2 Local curr. 3
NetDueDate I_ReceivablesPayablesItem NetDueDate Net Due Date
CashDiscount1DueDate I_ReceivablesPayablesItem CashDiscount1DueDate Cash Discount 1
CashDiscount2DueDate I_ReceivablesPayablesItem CashDiscount2DueDate Cash Discount 2
OffsettingAccount I_ReceivablesPayablesItem OffsettingAccount Offsetting Acct
OffsettingAccountType I_ReceivablesPayablesItem OffsettingAccountType Offset Acct Type
PartnerFund I_ReceivablesPayablesItem PartnerFund Receiver Fund
PartnerGrant I_ReceivablesPayablesItem PartnerGrant Receiver Grant
BudgetPeriod I_ReceivablesPayablesItem BudgetPeriod Budget Period
PartnerBudgetPeriod I_ReceivablesPayablesItem PartnerBudgetPeriod Partner Budget Period
BPBankAccountInternalID I_ReceivablesPayablesItem BPBankAccountInternalID BP Bank Account
Partner
AuthorizationGroup
CustomerFinsAuthorizationGrp
SupplierFinsAuthorizationGrp
CndnContrType I_RU_Contract CndnContrType Contract Type

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_RU_ExchDiff0.
-- 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: PRUEXCHDIFF0

CREATE VIEW P_RU_ExchDiff0 AS
SELECT
  RP.CompanyCode AS CompanyCode,
  RP.AccountingDocument AS AccountingDocument,
  RP.FiscalYear AS FiscalYear,
  RP.AccountingDocumentItem AS AccountingDocumentItem,
  RP.FiscalYearVariant AS FiscalYearVariant,
  RP.ClearingDate AS ClearingDate,
  RP.ClearingCreationDate AS ClearingCreationDate,
  RP.ClearingAccountingDocument AS ClearingAccountingDocument,
  RP.PostingKey AS PostingKey,
  RP.FinancialAccountType AS FinancialAccountType,
  RP.SpecialGLCode AS SpecialGLCode,
  RP.SpecialGLTransactionType AS SpecialGLTransactionType,
  RP.TargetSpecialGLCode AS TargetSpecialGLCode,
  RP.DebitCreditCode AS DebitCreditCode,
  RP.BusinessArea AS BusinessArea,
  RP.PartnerBusinessArea AS PartnerBusinessArea,
  RP.TaxCode AS TaxCode,
  RP.WithholdingTaxCode AS WithholdingTaxCode,
  RP.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  RP.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  RP.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  RP.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  RP.TaxAmountInCoCodeCrcy AS TaxAmountInCoCodeCrcy,
  RP.TaxAmount AS TaxAmount,
  RP.TaxBaseAmountInTransCrcy AS TaxBaseAmountInTransCrcy,
  RP.TaxBaseAmountInCoCodeCrcy AS TaxBaseAmountInCoCodeCrcy,
  RP.TaxType AS TaxType,
  RP.TaxItemGroup AS TaxItemGroup,
  RP.TransactionTypeDetermination AS TransactionTypeDetermination,
  RP.WithholdingTaxBaseAmount AS WithholdingTaxBaseAmount,
  RP.ValuationDiffAmtInCoCodeCrcy AS ValuationDiffAmtInCoCodeCrcy,
  RP.ValuationDiffAmtInAddlCrcy1 AS ValuationDiffAmtInAddlCrcy1,
  RP.ValueDate AS ValueDate,
  coalesce(_Contract.AssignmentReference,'') AS AssignmentReference,
  RP.DocumentItemText AS DocumentItemText,
  RP.PartnerCompany AS PartnerCompany,
  RP.FinancialTransactionType AS FinancialTransactionType,
  RP.CorporateGroupAccount AS CorporateGroupAccount,
  RP.PlanningLevel AS PlanningLevel,
  RP.PlannedAmtInTransactionCrcy AS PlannedAmtInTransactionCrcy,
  RP.ControllingArea AS ControllingArea,
  RP.CostCenter AS CostCenter,
  RP.WBSElementInternalID AS WBSElementInternalID,
  RP.OrderID AS OrderID,
  RP.BillingDocument AS BillingDocument,
  RP.SalesDocument AS SalesDocument,
  RP.SalesDocumentItem AS SalesDocumentItem,
  RP.ScheduleLine AS ScheduleLine,
  RP.MasterFixedAsset AS MasterFixedAsset,
  RP.FixedAsset AS FixedAsset,
  RP.AssetTransactionType AS AssetTransactionType,
  RP.Employee AS Employee,
  RP.IsSalesRelated AS IsSalesRelated,
  RP.LineItemDisplayIsEnabled AS LineItemDisplayIsEnabled,
  RP.IsOpenItemManaged AS IsOpenItemManaged,
  RP.AddressAndBankIsSetManually AS AddressAndBankIsSetManually,
  RP.IsAutomaticallyCreated AS IsAutomaticallyCreated,
  RP.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  RP.GLAccount AS GLAccount,
  RP.Debtor AS Debtor,
  RP.Creditor AS Creditor,
  RP.Branch AS Branch,
  RP.IsBalanceSheetAccount AS IsBalanceSheetAccount,
  RP.ProfitLossAccountType AS ProfitLossAccountType,
  RP.SpecialGLAccountAssignment AS SpecialGLAccountAssignment,
  RP.DueCalculationBaseDate AS DueCalculationBaseDate,
  RP.PaymentTerms AS PaymentTerms,
  RP.CashDiscount1Days AS CashDiscount1Days,
  RP.CashDiscount2Days AS CashDiscount2Days,
  RP.NetPaymentDays AS NetPaymentDays,
  RP.CashDiscount1Percent AS CashDiscount1Percent,
  RP.CashDiscount2Percent AS CashDiscount2Percent,
  RP.CashDiscountBaseAmount AS CashDiscountBaseAmount,
  RP.CashDiscountAmtInCoCodeCrcy AS CashDiscountAmtInCoCodeCrcy,
  RP.CashDiscountAmount AS CashDiscountAmount,
  RP.PaymentMethod AS PaymentMethod,
  RP.PaymentBlockingReason AS PaymentBlockingReason,
  RP.FixedCashDiscount AS FixedCashDiscount,
  RP.HouseBank AS HouseBank,
  RP.TaxDistributionCode1 AS TaxDistributionCode1,
  RP.TaxDistributionCode2 AS TaxDistributionCode2,
  RP.TaxDistributionCode3 AS TaxDistributionCode3,
  RP.InvoiceReference AS InvoiceReference,
  RP.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  RP.InvoiceItemReference AS InvoiceItemReference,
  RP.FollowOnDocumentType AS FollowOnDocumentType,
  RP.SupplyingCountry AS SupplyingCountry,
  RP.InvoiceList AS InvoiceList,
  RP.SettlementFiscalYearPeriod AS SettlementFiscalYearPeriod,
  RP.BillOfExchangeUsage AS BillOfExchangeUsage,
  RP.DunningKey AS DunningKey,
  RP.DunningBlockingReason AS DunningBlockingReason,
  RP.LastDunningDate AS LastDunningDate,
  RP.DunningLevel AS DunningLevel,
  RP.DunningArea AS DunningArea,
  RP.WithholdingTaxAmount AS WithholdingTaxAmount,
  RP.WithholdingTaxExemptionAmt AS WithholdingTaxExemptionAmt,
  RP.Material AS Material,
  RP.Plant AS Plant,
  RP.Quantity AS Quantity,
  RP.BaseUnit AS BaseUnit,
  RP.QuantityInEntryUnit AS QuantityInEntryUnit,
  RP.EntryUnit AS EntryUnit,
  RP.PurchaseOrderQty AS PurchaseOrderQty,
  RP.PurchaseOrderPriceUnit AS PurchaseOrderPriceUnit,
  RP.PurchasingDocument AS PurchasingDocument,
  RP.PurchasingDocumentItem AS PurchasingDocumentItem,
  RP.AccountAssignmentNumber AS AccountAssignmentNumber,
  RP.IsCompletelyDelivered AS IsCompletelyDelivered,
  RP.MaterialPriceControl AS MaterialPriceControl,
  RP.MaterialPriceUnitQty AS MaterialPriceUnitQty,
  RP.ValuationArea AS ValuationArea,
  RP.InventoryValuationType AS InventoryValuationType,
  RP.InvoiceAmtInCoCodeCrcy AS InvoiceAmtInCoCodeCrcy,
  RP.InvoiceAmountInFrgnCurrency AS InvoiceAmountInFrgnCurrency,
  RP.VATRegistration AS VATRegistration,
  RP.DelivOfGoodsDestCountry AS DelivOfGoodsDestCountry,
  RP.DelivOfGoodsOriginCountry AS DelivOfGoodsOriginCountry,
  RP.PaymentDifferenceReason AS PaymentDifferenceReason,
  RP.ProfitCenter AS ProfitCenter,
  RP.JointVenture AS JointVenture,
  RP.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  RP.JointVentureEquityGroup AS JointVentureEquityGroup,
  RP.TreasuryContractType AS TreasuryContractType,
  RP.AssetContract AS AssetContract,
  RP.CashFlowType AS CashFlowType,
  RP.TaxJurisdiction AS TaxJurisdiction,
  RP.RealEstateObject AS RealEstateObject,
  RP.SettlementReferenceDate AS SettlementReferenceDate,
  RP.CommitmentItem AS CommitmentItem,
  RP.CostObject AS CostObject,
  RP.ProjectNetwork AS ProjectNetwork,
  RP.WBSElement AS WBSElement,
  RP.ProfitabilitySegment AS ProfitabilitySegment,
  RP.JointVentureEquityType AS JointVentureEquityType,
  RP.IsEUTriangularDeal AS IsEUTriangularDeal,
  RP.CostOriginGroup AS CostOriginGroup,
  RP.AmountInAdditionalCurrency1 AS AmountInAdditionalCurrency1,
  RP.AmountInAdditionalCurrency2 AS AmountInAdditionalCurrency2,
  RP.ValuationDiffAmtInAddlCrcy2 AS ValuationDiffAmtInAddlCrcy2,
  RP.ClearingIsReversed AS ClearingIsReversed,
  RP.PaymentMethodSupplement AS PaymentMethodSupplement,
  RP.AlternativeGLAccount AS AlternativeGLAccount,
  RP.FundsCenter AS FundsCenter,
  RP.Fund AS Fund,
  RP.PartnerProfitCenter AS PartnerProfitCenter,
  RP.Reference1IDByBusinessPartner AS Reference1IDByBusinessPartner,
  RP.Reference2IDByBusinessPartner AS Reference2IDByBusinessPartner,
  RP.PaymentCardItem AS PaymentCardItem,
  RP.PaymentCardPaymentSettlement AS PaymentCardPaymentSettlement,
  RP.CreditControlArea AS CreditControlArea,
  RP.Reference3IDByBusinessPartner AS Reference3IDByBusinessPartner,
  RP.DataExchangeInstruction1 AS DataExchangeInstruction1,
  RP.DataExchangeInstruction2 AS DataExchangeInstruction2,
  RP.DataExchangeInstruction3 AS DataExchangeInstruction3,
  RP.DataExchangeInstruction4 AS DataExchangeInstruction4,
  RP.Region AS Region,
  RP.HasPaymentOrder AS HasPaymentOrder,
  RP.PaymentReference AS PaymentReference,
  RP.HedgedAmount AS HedgedAmount,
  RP.TaxDeterminationDate AS TaxDeterminationDate,
  RP.ClearingItem AS ClearingItem,
  RP.PaymentCurrency AS PaymentCurrency,
  RP.AmountInPaymentCurrency AS AmountInPaymentCurrency,
  RP.BusinessPlace AS BusinessPlace,
  RP.TaxSection AS TaxSection,
  RP.CostCtrActivityType AS CostCtrActivityType,
  RP.AccountsReceivableIsPledged AS AccountsReceivableIsPledged,
  RP.BusinessProcess AS BusinessProcess,
  RP.GrantID AS GrantID,
  RP.FunctionalArea AS FunctionalArea,
  RP.CustomerIsInExecution AS CustomerIsInExecution,
  RP.ClearingDocFiscalYear AS ClearingDocFiscalYear,
  RP.Segment AS Segment,
  RP.PartnerSegment AS PartnerSegment,
  RP.PartnerFunctionalArea AS PartnerFunctionalArea,
  RP.HouseBankAccount AS HouseBankAccount,
  RP.CostElement AS CostElement,
  RP.ReferenceDocumentType AS ReferenceDocumentType,
  RP.OriginalReferenceDocument AS OriginalReferenceDocument,
  RP.ReferenceDocumentLogicalSystem AS ReferenceDocumentLogicalSystem,
  RP.FiscalPeriod AS FiscalPeriod,
  RP.AccountingDocumentCategory AS AccountingDocumentCategory,
  RP.PostingDate AS PostingDate,
  RP.DocumentDate AS DocumentDate,
  RP.TransactionCurrency AS TransactionCurrency,
  RP.AccountingDocumentType AS AccountingDocumentType,
  RP.CompanyCodeCurrency AS CompanyCodeCurrency,
  RP.AdditionalCurrency1 AS AdditionalCurrency1,
  RP.AdditionalCurrency2 AS AdditionalCurrency2,
  RP.NetDueDate AS NetDueDate,
  RP.CashDiscount1DueDate AS CashDiscount1DueDate,
  RP.CashDiscount2DueDate AS CashDiscount2DueDate,
  RP.OffsettingAccount AS OffsettingAccount,
  RP.OffsettingAccountType AS OffsettingAccountType,
  RP.PartnerFund AS PartnerFund,
  RP.PartnerGrant AS PartnerGrant,
  RP.BudgetPeriod AS BudgetPeriod,
  RP.PartnerBudgetPeriod AS PartnerBudgetPeriod,
  RP.BPBankAccountInternalID AS BPBankAccountInternalID,
  coalesce(RP._Customer._CustomerToBusinessPartner._BusinessPartner.BusinessPartner,RP._Supplier._SupplierToBusinessPartner._BusinessPartner.BusinessPartner ) AS Partner,
  coalesce(RP._Customer._CustomerToBusinessPartner._BusinessPartner.AuthorizationGroup,RP._Supplier._SupplierToBusinessPartner._BusinessPartner.AuthorizationGroup ) AS AuthorizationGroup,
  RP._Customer.AuthorizationGroup AS CustomerFinsAuthorizationGrp,
  RP._Supplier.AuthorizationGroup AS SupplierFinsAuthorizationGrp,
  _Contract.CndnContrType AS CndnContrType
FROM I_ReceivablesPayablesItem AS RP
LEFT OUTER JOIN I_RU_Contract AS _Contract ON /* join condition not captured in parsed metadata */
;

Learn More