R_PayablesFinancingOrderTP

DDL: R_PAYABLESFINANCINGORDERTP Type: view_entity TRANSACTIONAL Package: FPF_FINCG_ORDER
45 Fields 1 Data Sources 1 Associations

Payables Financing Order - TP

R_PayablesFinancingOrderTP is a Transactional CDS View that provides data about "Payables Financing Order - TP" in SAP S/4HANA. It reads from 1 data source (I_PayablesFinancingOrder) and exposes 45 fields with key field PayablesFinancingOrderUUID. It has 1 association to related views. Part of development package FPF_FINCG_ORDER.

Data Sources (1)

SourceAliasJoin Type
I_PayablesFinancingOrder I_PayablesFinancingOrder from

Associations (1)

CardinalityTargetAliasCondition
[1..*] R_PayablesFinancingOrderItemTP _PayablesFinancingOrderItem

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Payables Financing Order - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name PayablesFinancingOrder view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
Search.searchable true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY PayablesFinancingOrderUUID PayablesFinancingOrderUUID
PayablesFinancingOrder PayablesFinancingOrder
PayablesFinancingType PayablesFinancingType
PayablesFinancingSystem PayablesFinancingSystem
PayablesFinancingOrderStatus PayablesFinancingOrderStatus
PyblsFinancedAmtInFincgOrdCrcy PyblsFinancedAmtInFincgOrdCrcy
PayablesFinancingOrderCurrency PayablesFinancingOrderCurrency
PyblsFinancingOrderExternalID PyblsFinancingOrderExternalID WEBGUI External ID
PyblsFincgOrdIsCrdtNoteNetting PyblsFincgOrdIsCrdtNoteNetting
Supplier Supplier Supplier
PayingCompanyCode PayingCompanyCode Paying Company Code
CompanyCodeCountry CompanyCodeCountry Reporting Ctry/Reg.
NetDueDate NetDueDate Net Due Date
PayablesFinancingFunder PayablesFinancingFunder
PayablesFinancingFunderBkType PayablesFinancingFunderBkType
PayablesFinancingFunderBkHash PayablesFinancingFunderBkHash
PayablesFinancingDiscountType PayablesFinancingDiscountType
PaymentTerms PaymentTerms Pyt Terms
PyblsFincgOrdCshDiscAmt PyblsFincgOrdCshDiscAmt
DueCalculationBaseDate DueCalculationBaseDate Due Calculation Base Date
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
DocumentReferenceID DocumentReferenceID Reference
PaymentMethod PaymentMethod Pymt Meth.
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
PyblsFincgBizPrpsIsCmpltd PyblsFincgBizPrpsIsCmpltd Purpose Completed
_PayablesFinancingOrderItem _PayablesFinancingOrderItem
_PayablesFinancingOrderStatus _PayablesFinancingOrderStatus
_PayablesFinancingType _PayablesFinancingType
_PyblsFincgDiscountType _PyblsFincgDiscountType
_PayingCompanyCode _PayingCompanyCode
_Currency _Currency
_Supplier _Supplier
_Funder _Funder
_PaymentTerms _PaymentTerms
_PaymentMethod _PaymentMethod
_FunderBankDetails _FunderBankDetails
_CreatedByContactCard _CreatedByContactCard
_LastChangedByContactCard _LastChangedByContactCard

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 R_PayablesFinancingOrderTP.
-- 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 R_PayablesFinancingOrderTP AS
SELECT
  PayablesFinancingOrderUUID,
  PayablesFinancingOrder,
  PayablesFinancingType,
  PayablesFinancingSystem,
  PayablesFinancingOrderStatus,
  PyblsFinancedAmtInFincgOrdCrcy,
  PayablesFinancingOrderCurrency,
  PyblsFinancingOrderExternalID,
  PyblsFincgOrdIsCrdtNoteNetting,
  Supplier,
  PayingCompanyCode,
  CompanyCodeCountry,
  NetDueDate,
  PayablesFinancingFunder,
  PayablesFinancingFunderBkType,
  PayablesFinancingFunderBkHash,
  PayablesFinancingDiscountType,
  PaymentTerms,
  PyblsFincgOrdCshDiscAmt,
  DueCalculationBaseDate,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  DocumentReferenceID,
  PaymentMethod,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  PyblsFincgBizPrpsIsCmpltd
FROM I_PayablesFinancingOrder
LEFT OUTER JOIN R_PayablesFinancingOrderItemTP AS _PayablesFinancingOrderItem ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More