A_EquipMatlSrlNmbrPartner

DDL: A_EQUIPMATLSRLNMBRPARTNER Type: view_entity COMPOSITE Package: VDM_EAM_EQUIPMENT
27 Fields 1 Data Sources 3 OData Services

Partner for Material Serial Number

A_EquipMatlSrlNmbrPartner is a Composite CDS View that provides data about "Partner for Material Serial Number" in SAP S/4HANA. It reads from 1 data source (R_EquipMatlSrlNmbrPrtnTP) and exposes 27 fields with key fields Material, SerialNumber, Equipment, PartnerFunction, EquipmentPartnerObjectNmbr. It is exposed through 3 OData services (API_MATERIALSERIALNUMBER, ASQL_F6973, ASQL_F8474). Part of development package VDM_EAM_EQUIPMENT.

Data Sources (1)

SourceAliasJoin Type
R_EquipMatlSrlNmbrPrtnTP R_EquipMatlSrlNmbrPrtnTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Partner for Material Serial Number view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
OData.entityType.name MaterialSerialNumberPartner_Type view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

OData Services (3)

ServiceBindingVersionContractRelease
API_MATERIALSERIALNUMBER API_MATERIALSERIALNUMBER V4 C2 C1
ASQL_F6973 ASQL_F6973 C2 NOT_RELEASED
ASQL_F8474 ASQL_F8474 C2 NOT_RELEASED

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY SerialNumber SerialNumber Serial Number
KEY Equipment Equipment Equipment check
KEY PartnerFunction PartnerFunction Partner Functn
KEY EquipmentPartnerObjectNmbr EquipmentPartnerObjectNmbr Counter
PartnerFunctionType PartnerFunctionType Partner Type
EquipmentPartner EquipmentPartner With Partner
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
CreationTime CreationTime Time of Change
LastChangedByUser LastChangedByUser User Name
LastChangeTime LastChangeTime Time changed
LastChangeDate LastChangeDate Time Stamp
MaintObjectInternalID MaintObjectInternalID Object number
CntctPersnIsBusPrpsCompleted CntctPersnIsBusPrpsCompleted
CntctPersnCustomerAccountGroup CntctPersnCustomerAccountGroup
CntctPersnCustomerAuthznGroup CntctPersnCustomerAuthznGroup
CntctPersnSupplierAccountGroup CntctPersnSupplierAccountGroup
CntctPersnSupplierAuthznGroup CntctPersnSupplierAuthznGroup
CustomerIsBusPrpsCmpltd CustomerIsBusPrpsCmpltd
CustomerAccountGroup CustomerAccountGroup Account group
CustomerAuthznGrp CustomerAuthznGrp
EmployeeIsBusPrpsCmpltd EmployeeIsBusPrpsCmpltd
EmployeeAuthznGroup EmployeeAuthznGroup
SupplierIsBusPrpsCmpltd SupplierIsBusPrpsCmpltd
SupplierAccountGroup SupplierAccountGroup Account group
SupplierAuthznGrp SupplierAuthznGrp Authorization

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 A_EquipMatlSrlNmbrPartner.
-- 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 A_EquipMatlSrlNmbrPartner AS
SELECT
  Material,
  SerialNumber,
  Equipment,
  PartnerFunction,
  EquipmentPartnerObjectNmbr,
  PartnerFunctionType,
  EquipmentPartner,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeTime,
  LastChangeDate,
  MaintObjectInternalID,
  CntctPersnIsBusPrpsCompleted,
  CntctPersnCustomerAccountGroup,
  CntctPersnCustomerAuthznGroup,
  CntctPersnSupplierAccountGroup,
  CntctPersnSupplierAuthznGroup,
  CustomerIsBusPrpsCmpltd,
  CustomerAccountGroup,
  CustomerAuthznGrp,
  EmployeeIsBusPrpsCmpltd,
  EmployeeAuthznGroup,
  SupplierIsBusPrpsCmpltd,
  SupplierAccountGroup,
  SupplierAuthznGrp
FROM R_EquipMatlSrlNmbrPrtnTP
;

Learn More