C_FinManageAPClrgPrpslSetTP

DDL: C_FINMANAGEAPCLRGPRPSLSETTP Type: view_entity CONSUMPTION Package: FIN_MANAGE_AP_CLRG_PROPOSAL
18 Fields 1 Data Sources 2 OData Services

Manage AP Clearing Proposal Set

C_FinManageAPClrgPrpslSetTP is a Consumption CDS View that provides data about "Manage AP Clearing Proposal Set" in SAP S/4HANA. It reads from 1 data source (R_FinAPARClearingProposalSetTP) and exposes 18 fields with key field FinAPARClearingProposalSetUUID. It is exposed through 2 OData services (ASQL_F9300, UI_MANAGE_AP_CLEARING_PROPOSAL). Part of development package FIN_MANAGE_AP_CLRG_PROPOSAL.

Data Sources (1)

SourceAliasJoin Type
R_FinAPARClearingProposalSetTP R_FinAPARClearingProposalSetTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Manage AP Clearing Proposal Set view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name ProposalSet_Type view
Metadata.allowExtensions true view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F9300 ASQL_F9300 C2 NOT_RELEASED
UI_MANAGE_AP_CLEARING_PROPOSAL UI_MANAGE_AP_CLRG_PRPSL_V4 V4 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY FinAPARClearingProposalSetUUID FinAPARClearingProposalSetUUID
CompanyCode CompanyCode Receiver Company Code
Supplier Supplier Supplier
FinancialAccountType FinancialAccountType Fin. Account Type
TransactionCurrency TransactionCurrency Transaction Currency
OpenAmountInTransCrcy OpenAmountInTransCrcy Open Amt Trans Crcy
NumberOfAPARClearingProposal NumberOfAPARClearingProposal
NumberOfOpenItems NumberOfOpenItems
FinAPARClrgPrpslSetStatus FinAPARClrgPrpslSetStatus
FinAPARClrgPrpslSetStatusNamelocalized
CreatedByUser CreatedByUser User Name
CreatedAtDateTime CreatedAtDateTime Created On/At
CompanyCodeName _CompanyCode CompanyCodeName Company Name
SupplierName _Supplier SupplierName Supplier Name
CreatedByUserName _CreatedByContactCard FullName Name
_CompanyCode _CompanyCode
_Supplier _Supplier
_CreatedByContactCard _CreatedByContactCard

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_FinManageAPClrgPrpslSetTP.
-- 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_FinManageAPClrgPrpslSetTP AS
SELECT
  FinAPARClearingProposalSetUUID,
  CompanyCode,
  Supplier,
  FinancialAccountType,
  TransactionCurrency,
  OpenAmountInTransCrcy,
  NumberOfAPARClearingProposal,
  NumberOfOpenItems,
  FinAPARClrgPrpslSetStatus,
  _ClrgPrpslSetStatus._Text.FinAPARClrgPrpslSetStatusName : localized AS FinAPARClrgPrpslSetStatusNamelocalized,
  CreatedByUser,
  CreatedAtDateTime,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Supplier.SupplierName AS SupplierName,
  _CreatedByContactCard.FullName AS CreatedByUserName
FROM R_FinAPARClearingProposalSetTP
;

Learn More