C_SuplrListPrpsdCompanyCodeTP

DDL: C_SUPLRLISTPRPSDCOMPANYCODETP Type: view_entity CONSUMPTION
14 Fields 1 Data Sources

Prpsd Company Code for Suplr List - TP

C_SuplrListPrpsdCompanyCodeTP is a Consumption CDS View that provides data about "Prpsd Company Code for Suplr List - TP" in SAP S/4HANA. It reads from 1 data source (R_SuplrListPrpsdCompanyCodeTP) and exposes 14 fields with key field SuplrListPrpsdCompanyCodeUUID.

Data Sources (1)

SourceAliasJoin Type
R_SuplrListPrpsdCompanyCodeTP R_SuplrListPrpsdCompanyCodeTP projection

Annotations (10)

NameValueLevelField
VDM.viewType #CONSUMPTION view
EndUserText.label Prpsd Company Code for Suplr List - TP view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey SuplrListPrpsdCompanyCodeUUID view
Search.searchable false view
Metadata.ignorePropagatedAnnotations true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SuplrListPrpsdCompanyCodeUUID _SuplrListPrpsdCompanyCodeTP SuplrListPrpsdCompanyCodeUUID Proposed Company Code UUID
CompanyCode _SuplrListPrpsdCompanyCodeTP CompanyCode Receiver Company Code
SupplierListUUID _SuplrListPrpsdCompanyCodeTP SupplierListUUID Supplier List UUID
IsDeleted _SuplrListPrpsdCompanyCodeTP IsDeleted TRUE
CompanyCodeName _CompanyCode CompanyCodeName Company Name
SuplrListCoCodeProposedByUser _SuplrListPrpsdCompanyCodeTP SuplrListCoCodeProposedByUser Created By
SuplrListCoCodePrpsdDateTime _SuplrListPrpsdCompanyCodeTP SuplrListCoCodePrpsdDateTime Proposed On
SuplrListCoCodeProposalText _SuplrListPrpsdCompanyCodeTP SuplrListCoCodeProposalText Proposal Comments
SuplrListCoCodeApprovalText _SuplrListPrpsdCompanyCodeTP SuplrListCoCodeApprovalText Approval Comments
SuplrListCoCodeProposalStatus _SuplrListPrpsdCompanyCodeTP SuplrListCoCodeProposalStatus Proposed status
SuplrListCoCodeProposalAction _SuplrListPrpsdCompanyCodeTP SuplrListCoCodeProposalAction Company Code Proposal Action
FullName _ProposedByUser FullName Name
_CompanyCode _CompanyCode
_ProposedByUser _ProposedByUser

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_SuplrListPrpsdCompanyCodeTP.
-- 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_SuplrListPrpsdCompanyCodeTP AS
SELECT
  _SuplrListPrpsdCompanyCodeTP.SuplrListPrpsdCompanyCodeUUID AS SuplrListPrpsdCompanyCodeUUID,
  _SuplrListPrpsdCompanyCodeTP.CompanyCode AS CompanyCode,
  _SuplrListPrpsdCompanyCodeTP.SupplierListUUID AS SupplierListUUID,
  _SuplrListPrpsdCompanyCodeTP.IsDeleted AS IsDeleted,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _SuplrListPrpsdCompanyCodeTP.SuplrListCoCodeProposedByUser AS SuplrListCoCodeProposedByUser,
  _SuplrListPrpsdCompanyCodeTP.SuplrListCoCodePrpsdDateTime AS SuplrListCoCodePrpsdDateTime,
  _SuplrListPrpsdCompanyCodeTP.SuplrListCoCodeProposalText AS SuplrListCoCodeProposalText,
  _SuplrListPrpsdCompanyCodeTP.SuplrListCoCodeApprovalText AS SuplrListCoCodeApprovalText,
  _SuplrListPrpsdCompanyCodeTP.SuplrListCoCodeProposalStatus AS SuplrListCoCodeProposalStatus,
  _SuplrListPrpsdCompanyCodeTP.SuplrListCoCodeProposalAction AS SuplrListCoCodeProposalAction,
  _ProposedByUser.FullName AS FullName
FROM R_SuplrListPrpsdCompanyCodeTP
;

Learn More