R_SuplrListPrpsdCompanyCodeD

DDL: R_SUPLRLISTPRPSDCOMPANYCODED Type: view_entity BASIC Package: RAP_MM_PUR_SUPLRLIST
17 Fields 1 Data Sources 1 Associations

Prpsd Company Code for SuplrList - Draft

R_SuplrListPrpsdCompanyCodeD is a Basic CDS View that provides data about "Prpsd Company Code for SuplrList - Draft" in SAP S/4HANA. It reads from 1 data source (mmsuplrlprpcc_d) and exposes 17 fields with key field SuplrListPrpsdCompanyCodeUUID. It has 1 association to related views. Part of development package RAP_MM_PUR_SUPLRLIST.

Data Sources (1)

SourceAliasJoin Type
mmsuplrlprpcc_d mmsuplrlprpcc_d from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_SupplierListD _SupplierListD $projection.SupplierListUUID = _SupplierListD.SupplierListUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Prpsd Company Code for SuplrList - Draft view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY SuplrListPrpsdCompanyCodeUUID suplrlistprpsdcompanycodeuuid Proposed Company Code UUID
CompanyCode companycode Receiver Company Code
SupplierListUUID supplierlistuuid Supplier List UUID
IsDeleted isdeleted TRUE
SuplrListCoCodeProposedByUser suplrlistcocodeproposedbyuser Created By
SuplrListCoCodePrpsdDateTime suplrlistcocodeprpsddatetime Proposed On
SuplrListCoCodeProposalText suplrlistcocodeproposaltext Proposal Comments
SuplrListCoCodeApprovalText suplrlistcocodeapprovaltext Approval Comments
SuplrListCoCodeProposalStatus suplrlistcocodeproposalstatus Proposed status
SuplrListCoCodeProposalAction suplrlistcocodeproposalaction Company Code Proposal Action
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
_SupplierListD _SupplierListD

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_SuplrListPrpsdCompanyCodeD.
-- 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_SuplrListPrpsdCompanyCodeD AS
SELECT
  SuplrListPrpsdCompanyCodeUUID,
  CompanyCode,
  SupplierListUUID,
  IsDeleted,
  SuplrListCoCodeProposedByUser,
  SuplrListCoCodePrpsdDateTime,
  SuplrListCoCodeProposalText,
  SuplrListCoCodeApprovalText,
  SuplrListCoCodeProposalStatus,
  SuplrListCoCodeProposalAction,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM mmsuplrlprpcc_d
LEFT OUTER JOIN R_SupplierListD AS _SupplierListD ON SupplierListUUID = _SupplierListD.SupplierListUUID  -- association [1..1]
;

Learn More