C_PayablesFinancingOrderItemTP

DDL: C_PAYABLESFINANCINGORDERITEMTP Type: view_entity CONSUMPTION
42 Fields 1 Data Sources

Payables Financing Order Item - TP

C_PayablesFinancingOrderItemTP is a Consumption CDS View that provides data about "Payables Financing Order Item - TP" in SAP S/4HANA. It reads from 1 data source (R_PayablesFinancingOrderItemTP) and exposes 42 fields with key fields PayablesFinancingOrderUUID, PayablesFinancingOrderItemUUID.

Data Sources (1)

SourceAliasJoin Type
R_PayablesFinancingOrderItemTP R_PayablesFinancingOrderItemTP projection

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Payables Financing Order Item - TP view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.sapObjectNodeType.name PayablesFinancingOrderItem view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
Metadata.allowExtensions true view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY PayablesFinancingOrderUUID PayablesFinancingOrderUUID
KEY PayablesFinancingOrderItemUUID PayablesFinancingOrderItemUUID
PayablesFinancingOrder PayablesFinancingOrder
PayablesFinancingOrderItemType PayablesFinancingOrderItemType
PyblsFinancedAmtInFincgOrdCrcy PyblsFinancedAmtInFincgOrdCrcy
PayablesFinancingOrderCurrency PayablesFinancingOrderCurrency
CompanyCode CompanyCode Receiver Company Code
FiscalYear FiscalYear G/L Fiscal Year
AccountingDocument AccountingDocument Journal Entry
AccountingDocumentItem AccountingDocumentItem Posting View Item
OriginalPayeeBankHash OriginalPayeeBankHash
OriginalPayee OriginalPayee
OriglBPBkAcctIntID OriglBPBkAcctIntID
OriginalPaymentTerms OriginalPaymentTerms
OriginalDueCalculationBaseDate OriginalDueCalculationBaseDate
OriginalCashDiscountAmount OriginalCashDiscountAmount
OriginalCashDiscount1Days OriginalCashDiscount1Days
OriginalCashDiscount2Days OriginalCashDiscount2Days
OriginalNetPaymentDays OriginalNetPaymentDays
OriginalCashDiscount1Percent OriginalCashDiscount1Percent
OriginalCashDiscount2Percent OriginalCashDiscount2Percent
OriginalPaymentMethod OriginalPaymentMethod
ClearingStatus ClearingStatus Clearing status
IsReversed IsReversed Reversed?
DocumentReferenceID DocumentReferenceID Reference
InvoiceReference InvoiceReference Invoice Reference
DocumentItemText DocumentItemText Text
AssignmentReference AssignmentReference Assignment Reference
ClearingJournalEntry ClearingJournalEntry Clrng doc.
PyblsFinancingOrderItmTypeName
CompanyCodeName _CompanyCode CompanyCodeName Company Name
ClearingStatusName
virtualPaymentTermsIsHiddenabap_boolean
virtualPaymentMethodIsHiddenabap_boolean
virtualClearingStatusCriticalityint1
_OperationalAcctgDocItem _OperationalAcctgDocItem
_FinancingOrderCurrency _FinancingOrderCurrency
_PyblsFinancingOrderItemType _PyblsFinancingOrderItemType
_CompanyCode _CompanyCode
_OriginalPayee _OriginalPayee
_OplAcctgDocItemClrgStatus _OplAcctgDocItemClrgStatus
_OriginalPaymentTerms _OriginalPaymentTerms

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 C_PayablesFinancingOrderItemTP.
-- 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 C_PayablesFinancingOrderItemTP AS
SELECT
  PayablesFinancingOrderUUID,
  PayablesFinancingOrderItemUUID,
  PayablesFinancingOrder,
  PayablesFinancingOrderItemType,
  PyblsFinancedAmtInFincgOrdCrcy,
  PayablesFinancingOrderCurrency,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  OriginalPayeeBankHash,
  OriginalPayee,
  OriglBPBkAcctIntID,
  OriginalPaymentTerms,
  OriginalDueCalculationBaseDate,
  OriginalCashDiscountAmount,
  OriginalCashDiscount1Days,
  OriginalCashDiscount2Days,
  OriginalNetPaymentDays,
  OriginalCashDiscount1Percent,
  OriginalCashDiscount2Percent,
  OriginalPaymentMethod,
  ClearingStatus,
  IsReversed,
  DocumentReferenceID,
  InvoiceReference,
  DocumentItemText,
  AssignmentReference,
  ClearingJournalEntry,
  _PyblsFinancingOrderItemType._PyblsFincgOrdItemTypeText[1: Language = $session.system_language].PyblsFinancingOrderItmTypeName AS PyblsFinancingOrderItmTypeName,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _OplAcctgDocItemClrgStatus._Text[1: Language = $session.system_language].ClearingStatusName AS ClearingStatusName,
  virtual PaymentTermsIsHidden :abap_boolean AS virtualPaymentTermsIsHiddenabap_boolean,
  virtual PaymentMethodIsHidden :abap_boolean AS virtualPaymentMethodIsHiddenabap_boolean,
  virtual ClearingStatusCriticality :int1 AS virtualClearingStatusCriticalityint1
FROM R_PayablesFinancingOrderItemTP
;

Learn More