C_PayablesFinancingOrderTP

DDL: C_PAYABLESFINANCINGORDERTP Type: view_entity CONSUMPTION Package: FPF_FINCG_ORDER

Payables Financing Order - TP

C_PayablesFinancingOrderTP is a Consumption CDS View that provides data about "Payables Financing Order - TP" in SAP S/4HANA. It reads from 1 data source (R_PayablesFinancingOrderTP) and exposes 57 fields with key field PayablesFinancingOrderUUID. It is exposed through 2 OData services (ASQL_F8343, UI_PAYABLESFINANCINGORDER). Part of development package FPF_FINCG_ORDER.

Data Sources (1)

SourceAliasJoin Type
R_PayablesFinancingOrderTP R_PayablesFinancingOrderTP projection

Annotations (11)

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

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F8343 ASQL_F8343 C2 NOT_RELEASED
UI_PAYABLESFINANCINGORDER UI_PAYABLESFINANCINGORDER_V4 V4 C1 NOT_RELEASED

Fields (57)

KeyFieldSource TableSource FieldDescription
KEY PayablesFinancingOrderUUID PayablesFinancingOrderUUID
PayablesFinancingOrder PayablesFinancingOrder
PayablesFinancingType PayablesFinancingType
PayablesFinancingSystem PayablesFinancingSystem
PayablesFinancingOrderStatus PayablesFinancingOrderStatus
PyblsFinancedAmtInFincgOrdCrcy PyblsFinancedAmtInFincgOrdCrcy
PayablesFinancingOrderCurrency PayablesFinancingOrderCurrency
PyblsFinancingOrderExternalID PyblsFinancingOrderExternalID
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
CreationDate CreationDate Time Stamp
PyblsFincgBizPrpsIsCmpltd PyblsFincgBizPrpsIsCmpltd
PayablesFinancingTypeName
PyblsFinancingOrderStatusName
PyblsFinancingDiscountTypeName
SupplierName _Supplier OrganizationBPName1 Name 1
CompanyCodeName _PayingCompanyCode CompanyCodeName Company Name
PayablesFinancingFunderName _Funder OrganizationBPName1 Name 1
PaymentMethodName _PaymentMethod PaymentMethodName Text
PaymentTermsName
CreatedByUserName _CreatedByContactCard FullName Name
LastChangedByUserName _LastChangedByContactCard FullName Name
virtualPaymentTermsIsHiddenabap_boolean
virtualPaymentMethodIsHiddenabap_boolean
virtualPyblsFincgOrdStsCritltyint1
_PayablesFinancingType _PayablesFinancingType
_PyblsFincgDiscountType _PyblsFincgDiscountType
_PayablesFinancingOrderStatus _PayablesFinancingOrderStatus
_PayingCompanyCode _PayingCompanyCode
_Currency _Currency
_Supplier _Supplier
_Funder _Funder
_PaymentTerms _PaymentTerms
_PaymentMethod _PaymentMethod
_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 C_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 C_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,
  CreationDate,
  PyblsFincgBizPrpsIsCmpltd,
  _PayablesFinancingType._PayablesFinancingTypeText[1: Language = $session.system_language].PayablesFinancingTypeName AS PayablesFinancingTypeName,
  _PayablesFinancingOrderStatus._PyblsFinancingOrderStatusTxt[1: Language = $session.system_language].PyblsFinancingOrderStatusName AS PyblsFinancingOrderStatusName,
  _PyblsFincgDiscountType._PyblsFincgDiscountTypeText[1: Language = $session.system_language].PyblsFinancingDiscountTypeName AS PyblsFinancingDiscountTypeName,
  _Supplier.OrganizationBPName1 AS SupplierName,
  _PayingCompanyCode.CompanyCodeName AS CompanyCodeName,
  _Funder.OrganizationBPName1 AS PayablesFinancingFunderName,
  _PaymentMethod.PaymentMethodName AS PaymentMethodName,
  _PaymentTerms._Text[1: Language = $session.system_language].PaymentTermsName AS PaymentTermsName,
  _CreatedByContactCard.FullName AS CreatedByUserName,
  _LastChangedByContactCard.FullName AS LastChangedByUserName,
  virtual PaymentTermsIsHidden :abap_boolean AS virtualPaymentTermsIsHiddenabap_boolean,
  virtual PaymentMethodIsHidden :abap_boolean AS virtualPaymentMethodIsHiddenabap_boolean,
  virtual PyblsFincgOrdStsCritlty :int1 AS virtualPyblsFincgOrdStsCritltyint1
FROM R_PayablesFinancingOrderTP
;