P_ReceivablesItem

DDL: P_RECEIVABLESITEM SQL: PFIRECITEM Type: view COMPOSITE Package: FINS_FIS_APAR
234 Fields 1 Data Sources 1 Associations

Receivables Item with credit segment

P_ReceivablesItem is a Composite CDS View that provides data about "Receivables Item with credit segment" in SAP S/4HANA. It reads from 1 data source (P_ReceivablesItem1) and exposes 234 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 1 association to related views. Part of development package FINS_FIS_APAR.

Data Sources (1)

SourceAliasJoin Type
P_ReceivablesItem1 P_ReceivablesItem1 from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CreditControlArea _CreditControlArea $projection.CreditControlArea = _CreditControlArea.CreditControlArea

Annotations (7)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName PFIRECITEM view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (234)

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

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_ReceivablesItem.
-- 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: PFIRECITEM

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

Learn More