I_ReceivablePayableItem

DDL: I_RECEIVABLEPAYABLEITEM Type: view_entity COMPOSITE
111 Fields 1 Data Sources

Receivable Payable Item

I_ReceivablePayableItem is a Composite CDS View that provides data about "Receivable Payable Item" in SAP S/4HANA. It reads from 1 data source (I_RblPyblTransactionItem) and exposes 111 fields with key fields ReceivablePayableApplication, ReceivablePayableDocument, ReceivablePayableDocumentItem, RblPyblDocumentSubitem.

Data Sources (1)

SourceAliasJoin Type
I_RblPyblTransactionItem I_RblPyblTransactionItem from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Receivable Payable Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view

Fields (111)

KeyFieldSource TableSource FieldDescription
KEY ReceivablePayableApplication ReceivablePayableApplication UI Application
KEY ReceivablePayableDocument ReceivablePayableDocument Reference Doc Number
KEY ReceivablePayableDocumentItem ReceivablePayableDocumentItem Item Number
KEY RblPyblDocumentSubitem RblPyblDocumentSubitem
RblPyblTransactionItemUUID RblPyblTransactionItemUUID
RblPyblTransactionUUID RblPyblTransactionUUID UUID
RblPyblPreviousTransactionUUID RblPyblPreviousTransactionUUID
ReceivablePayableItemOID ReceivablePayableItemOID UUID
AccountingDocument AccountingDocument Journal Entry
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
DocumentDate DocumentDate Journal Entry Date
PostingDate PostingDate Posting Date for GR
NetDueDate NetDueDate Net Due Date
RblPyblAccountType RblPyblAccountType SI Account type
RblPyblTransactionType RblPyblTransactionType Transactn Type
Supplier Supplier Supplier
Customer Customer Sold-to Party
BusinessPartner BusinessPartner Issuing Authority
ContractAccount ContractAccount Contract Acct
CAContract CAContract Contract
CASubApplication CASubApplication Subapplication
AmountInTransactionCurrency AmountInTransactionCurrency Pt Crcy Amt
TransactionCurrency TransactionCurrency Transaction Currency
PaytMethRblPyblCodeOrigin PaytMethRblPyblCodeOrigin
RblPyblPaymentMethod RblPyblPaymentMethod Pymt Meth.
CashDiscountBaseAmount CashDiscountBaseAmount Cash Dscnt Base Amt
CashDiscount1DueDate CashDiscount1DueDate Cash Discount 1
CashDiscount2DueDate CashDiscount2DueDate Cash Discount 2
CashDiscount1Percent CashDiscount1Percent Disc. Percent 1
CashDiscount2Percent CashDiscount2Percent Disc. Percent 2
RblPyblItemIsCleared RblPyblItemIsCleared
ClearingDate ClearingDate Clearing Date
ClearingRblPyblDocument ClearingRblPyblDocument
RblPyblClearingReason RblPyblClearingReason
ClearingTransactionCurrency ClearingTransactionCurrency
ClrgBaseAmountInClrgTransCrcy ClrgBaseAmountInClrgTransCrcy
ClearingAmountInClrgTransCrcy ClearingAmountInClrgTransCrcy
CashDiscountAmtInClrgTransCrcy CashDiscountAmtInClrgTransCrcy
DeductionAmountInClrgTransCrcy DeductionAmountInClrgTransCrcy Amount
ResidualAmountInClrgTransCrcy ResidualAmountInClrgTransCrcy
PostgClassfctnRblPyblCodeOrign PostgClassfctnRblPyblCodeOrign
PostingClassification PostingClassification
PostgSubclfnRblPyblCodeOrigin PostgSubclfnRblPyblCodeOrigin
PostingSubclassification PostingSubclassification
PayingCompanyCode PayingCompanyCode Paying Company Code
HasPaymentOrder HasPaymentOrder Payment Sent
ReceivableFinancingStatus ReceivableFinancingStatus
IsUsedInPaymentTransaction IsUsedInPaymentTransaction Is Used In Payment Transaction
ReceivablePayableItemText ReceivablePayableItemText User Group
BranchAccount BranchAccount Branch Account No.
IsSalesRelated IsSalesRelated Is Sales Related
RblPyblItemIsBlockedForDunning RblPyblItemIsBlockedForDunning
DunningBlockStartDate DunningBlockStartDate
DunningBlockEndDate DunningBlockEndDate
RblPyblItemIsBlockedForPayment RblPyblItemIsBlockedForPayment
PaymentBlockStartDate PaymentBlockStartDate
PaymentBlockEndDate PaymentBlockEndDate
ReferenceDocumentLogicalSystem ReferenceDocumentLogicalSystem Ref. Doc. Lgcl Syst.
ReferenceDocumentType ReferenceDocumentType Reference Document Type
OriginalReferenceDocument OriginalReferenceDocument Reference Key
OriginalRblPyblDocument OriginalRblPyblDocument
OriginalRblPyblDocumentItem OriginalRblPyblDocumentItem
OriginalRblPyblDocumentSubitem OriginalRblPyblDocumentSubitem
OriglRblPyblItmAmtInOrigItmTC OriglRblPyblItmAmtInOrigItmTC
OriglItemTransactionCurrency OriglItemTransactionCurrency
RblPyblItemHasRelations RblPyblItemHasRelations
RelatedRblPyblDocument RelatedRblPyblDocument
RelatedRblPyblDocumentItem RelatedRblPyblDocumentItem
RelatedRblPyblDocumentSubitem RelatedRblPyblDocumentSubitem
RblPyblDocumentRelationType RblPyblDocumentRelationType RIB Relshp Type
RblPyblDocumentReference RblPyblDocumentReference
RblPyblAltvDocumentReference RblPyblAltvDocumentReference
AssignmentReference AssignmentReference Assignment Reference
FirstRblPyblAddlReference FirstRblPyblAddlReference
SecondRblPyblAddlReference SecondRblPyblAddlReference
ThirdRblPyblAddlReference ThirdRblPyblAddlReference
RblPyblDocCreatedByUser RblPyblDocCreatedByUser
RblPyblDocCreationDate RblPyblDocCreationDate
RblPyblDocCreationTime RblPyblDocCreationTime
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
LogicalSystem LogicalSystem Logical System
ReceivablePayableLoadID ReceivablePayableLoadID
RsdlItmPredecessorDocument RsdlItmPredecessorDocument
RsdlItmPredecessorDocumentItem RsdlItmPredecessorDocumentItem
RblPyblDocumentIsReversal RblPyblDocumentIsReversal Reversal
RblPyblDocumentIsReversed RblPyblDocumentIsReversed Reversed
ReversalRblPyblDocument ReversalRblPyblDocument
ReversedRblPyblDocument ReversedRblPyblDocument
RblPyblItmSilentDtaMigrtnVers RblPyblItmSilentDtaMigrtnVers status value done
_AccountingDocument _AccountingDocument
_BusinessPartner _BusinessPartner
_CASubApplication _CASubApplication
_ClearingTransactionCurrency _ClearingTransactionCurrency
_CompanyCode _CompanyCode
_ContractAccount _ContractAccount
_ContractAccountPartner _ContractAccountPartner
_Customer _Customer
_CustomerCompany _CustomerCompany
_FiscalYear _FiscalYear
_LogicalSystem _LogicalSystem
_OriglItemTransactionCurrency _OriglItemTransactionCurrency
_PayingCompanyCode _PayingCompanyCode
_ProviderContract _ProviderContract
_RblPyblDocCreatedByUser _RblPyblDocCreatedByUser
_RefDocumentLogicalSystem _RefDocumentLogicalSystem
_ReferenceDocumentType _ReferenceDocumentType
_Supplier _Supplier
_SupplierCompany _SupplierCompany
_TransactionCurrency _TransactionCurrency

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 I_ReceivablePayableItem.
-- 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.

CREATE VIEW I_ReceivablePayableItem AS
SELECT
  ReceivablePayableApplication,
  ReceivablePayableDocument,
  ReceivablePayableDocumentItem,
  RblPyblDocumentSubitem,
  RblPyblTransactionItemUUID,
  RblPyblTransactionUUID,
  RblPyblPreviousTransactionUUID,
  ReceivablePayableItemOID,
  AccountingDocument,
  CompanyCode,
  FiscalYear,
  DocumentDate,
  PostingDate,
  NetDueDate,
  RblPyblAccountType,
  RblPyblTransactionType,
  Supplier,
  Customer,
  BusinessPartner,
  ContractAccount,
  CAContract,
  CASubApplication,
  AmountInTransactionCurrency,
  TransactionCurrency,
  PaytMethRblPyblCodeOrigin,
  RblPyblPaymentMethod,
  CashDiscountBaseAmount,
  CashDiscount1DueDate,
  CashDiscount2DueDate,
  CashDiscount1Percent,
  CashDiscount2Percent,
  RblPyblItemIsCleared,
  ClearingDate,
  ClearingRblPyblDocument,
  RblPyblClearingReason,
  ClearingTransactionCurrency,
  ClrgBaseAmountInClrgTransCrcy,
  ClearingAmountInClrgTransCrcy,
  CashDiscountAmtInClrgTransCrcy,
  DeductionAmountInClrgTransCrcy,
  ResidualAmountInClrgTransCrcy,
  PostgClassfctnRblPyblCodeOrign,
  PostingClassification,
  PostgSubclfnRblPyblCodeOrigin,
  PostingSubclassification,
  PayingCompanyCode,
  HasPaymentOrder,
  ReceivableFinancingStatus,
  IsUsedInPaymentTransaction,
  ReceivablePayableItemText,
  BranchAccount,
  IsSalesRelated,
  RblPyblItemIsBlockedForDunning,
  DunningBlockStartDate,
  DunningBlockEndDate,
  RblPyblItemIsBlockedForPayment,
  PaymentBlockStartDate,
  PaymentBlockEndDate,
  ReferenceDocumentLogicalSystem,
  ReferenceDocumentType,
  OriginalReferenceDocument,
  OriginalRblPyblDocument,
  OriginalRblPyblDocumentItem,
  OriginalRblPyblDocumentSubitem,
  OriglRblPyblItmAmtInOrigItmTC,
  OriglItemTransactionCurrency,
  RblPyblItemHasRelations,
  RelatedRblPyblDocument,
  RelatedRblPyblDocumentItem,
  RelatedRblPyblDocumentSubitem,
  RblPyblDocumentRelationType,
  RblPyblDocumentReference,
  RblPyblAltvDocumentReference,
  AssignmentReference,
  FirstRblPyblAddlReference,
  SecondRblPyblAddlReference,
  ThirdRblPyblAddlReference,
  RblPyblDocCreatedByUser,
  RblPyblDocCreationDate,
  RblPyblDocCreationTime,
  CreationDateTime,
  LastChangeDateTime,
  LogicalSystem,
  ReceivablePayableLoadID,
  RsdlItmPredecessorDocument,
  RsdlItmPredecessorDocumentItem,
  RblPyblDocumentIsReversal,
  RblPyblDocumentIsReversed,
  ReversalRblPyblDocument,
  ReversedRblPyblDocument,
  RblPyblItmSilentDtaMigrtnVers
FROM I_RblPyblTransactionItem
;

Learn More