C_FinManageARClrgPrpslSetTP

DDL: C_FINMANAGEARCLRGPRPSLSETTP Type: view_entity CONSUMPTION Package: FIN_MANAGE_AR_CLRG_PROPOSAL
18 Fields 1 Data Sources 2 OData Services

Manage AR Clearing Proposal Set

C_FinManageARClrgPrpslSetTP is a Consumption CDS View that provides data about "Manage AR 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_F9287, UI_MANAGE_AR_CLEARING_PROPOSAL). Part of development package FIN_MANAGE_AR_CLRG_PROPOSAL.

Data Sources (1)

SourceAliasJoin Type
R_FinAPARClearingProposalSetTP R_FinAPARClearingProposalSetTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Manage AR Clearing Proposal Set view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION 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

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F9287 ASQL_F9287 C2 NOT_RELEASED
UI_MANAGE_AR_CLEARING_PROPOSAL UI_MANAGE_AR_CLRG_PRPSL_V4 V4 C1 NOT_RELEASED

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY FinAPARClearingProposalSetUUID FinAPARClearingProposalSetUUID
CompanyCode CompanyCode Receiver Company Code
Customer Customer Sold-to Party
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
CustomerName _Customer CustomerName Name of Customer
CreatedByUserName _CreatedByContactCard FullName Name
_CompanyCode _CompanyCode
_Customer _Customer
_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_FinManageARClrgPrpslSetTP.
-- 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_FinManageARClrgPrpslSetTP AS
SELECT
  FinAPARClearingProposalSetUUID,
  CompanyCode,
  Customer,
  FinancialAccountType,
  TransactionCurrency,
  OpenAmountInTransCrcy,
  NumberOfAPARClearingProposal,
  NumberOfOpenItems,
  FinAPARClrgPrpslSetStatus,
  _ClrgPrpslSetStatus._Text.FinAPARClrgPrpslSetStatusName : localized AS FinAPARClrgPrpslSetStatusNamelocalized,
  CreatedByUser,
  CreatedAtDateTime,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _Customer.CustomerName AS CustomerName,
  _CreatedByContactCard.FullName AS CreatedByUserName
FROM R_FinAPARClearingProposalSetTP
;

Learn More