I_PREPAYMENTMATERIAL

CDS View

Material Data

I_PREPAYMENTMATERIAL is a CDS View in S/4HANA. Material Data. It contains 1 fields. 8 CDS views read from this table.

Used by 8 CDS view(s) 1 fields

CDS Views using this table (8)

ViewTypeJoinVDMDescription
P_PrepayBarterRefDocTotAmtTC view_entity inner COMPOSITE Prepayment Barter Document Total Amount
P_PrepaymentCMMContractAmount view inner COMPOSITE Prepayment Contract CMM Amount
P_PrepaymentCPEContractAmount view inner COMPOSITE Prepayment Contract CPE Amount
P_PrepaymentDocContractAmount view inner COMPOSITE Prepayment Contract Document Amount
P_PrepaymentRefDocTotalAmount view inner COMPOSITE Prepayment Document Total Amount
P_PrepaymentRefDocTotalAmtPO view_entity inner COMPOSITE Prepayment Document Total Amount
P_PrepaymentRefDocTotalAmtTC view_entity inner COMPOSITE Prepayment Document Total Amount
P_PrepaymentRefDocTotAmtSales view_entity inner COMPOSITE Prepayment Document Total Amt for Sales

Fields (1)

KeyField CDS FieldsUsed in Views
Commodity Commodity 7 
@AbapCatalog.sqlViewName                    : 'IPPMGMATERIAL'
@AbapCatalog.compiler.compareFilter         : true
@AbapCatalog.preserveKey                    : true
@AccessControl.authorizationCheck           : #CHECK
@EndUserText.label                          : 'Material Data'
@Analytics                                  : { dataCategory: #DIMENSION }
@VDM.viewType                               : #BASIC
@ObjectModel.representativeKey              : 'Material'
@ObjectModel.usageType.serviceQuality       : #A
@ObjectModel.usageType.sizeCategory         : #L
@ObjectModel.usageType.dataClass            : #MASTER
@ClientHandling.algorithm                   : #SESSION_VARIABLE
@Metadata.allowExtensions                   : true
@Metadata.ignorePropagatedAnnotations       : true
@Analytics.internalName                     : #LOCAL

define view I_PrepaymentMaterial as select from mara 
  association [0..*] to I_MaterialText  as _Text          on $projection.Material           = _Text.Material
  association [0..1] to I_MaterialType  as _MaterialType  on $projection.MaterialType       = _MaterialType.MaterialType
  association [0..1] to I_MaterialGroup as _MaterialGroup on $projection.MaterialGroup      = _MaterialGroup.MaterialGroup
  association [0..1] to I_UnitOfMeasure as _BaseUnit      on $projection.MaterialBaseUnit   = _BaseUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure as _WeightUnit    on $projection.MaterialWeightUnit = _WeightUnit.UnitOfMeasure
  association [0..*] to I_MaterialPlant as _MaterialPlant on $projection.Material           = _MaterialPlant.Material
  association [0..1] to I_Cmmdty        as _Commodity     on $projection.Commodity          = _Commodity.Commodity
{
  key mara.matnr                                                        as Material,

      mara.mtart                                                        as MaterialType,

      mara.matkl                                                        as MaterialGroup,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_BaseUnit'
      mara.meins                                                        as MaterialBaseUnit,

      @Semantics.quantity.unitOfMeasure: 'MaterialWeightUnit'
      @Analytics.hidden: true
      mara.brgew                                                        as MaterialGrossWeight,

      @Semantics.quantity.unitOfMeasure: 'MaterialWeightUnit'
      @Analytics.hidden: true
      mara.ntgew                                                        as MaterialNetWeight,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association: '_WeightUnit'
      mara.gewei                                                        as MaterialWeightUnit,

      @ObjectModel.foreignKey.association: '_Commodity'
      mara.commodity                                                    as Commodity,
      
      mara.mfrnr                                                        as MaterialManufacturerNumber,
      
      mara.mfrpn                                                        as MaterialManufacturerPartNumber,
      
      mara.begru                                                        as AuthorizationGroup,
      
      mara.xchpf                                                        as IsBatchManagementRequired,
      
//    Associations

      _Text,     
      _MaterialType, 
      _MaterialGroup,
      _BaseUnit,
      _WeightUnit,
      _MaterialPlant,
      _Commodity
}

Learn More