I_PREPAYMENTMATERIAL

CDS View

Material Data

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

Used by 11 CDS view(s) 1 fields

CDS Views using this table (11)

ViewTypeJoinVDMDescription
I_PrepayBarterProposedLinks view inner COMPOSITE PPMT Proposed Linkages Barter
I_PrepayBarterProposedLinksSD view inner COMPOSITE PPMT SD Proposed Linkages Barter
I_PrepayBarterProposedLinksSo view inner COMPOSITE PPMT SO Proposed Linkages Barter
I_PrepaymentProposedLinkages view inner COMPOSITE Prepayment Agreement Proposed Linkages
I_PrepaymentProposedLinkagesPO view inner COMPOSITE Prepayment Agreement Proposed PO Linkage
P_PpaytPrpsdLnkgCMMContrAmt view inner COMPOSITE Prepayment Proposed CMM Contract Amount
P_PpaytPrpsdLnkgCPEContrAmt view inner COMPOSITE Prepayment Proposed CPE Contract Amount
P_PpaytPrpsdLnkgDocContrAmt view inner COMPOSITE Prepayment Proposed Document Contract Amount
P_PrepaymentCMMContractAmount view inner COMPOSITE Prepayment Contract CMM Amount
P_PrepaymentCPEContractAmount view inner COMPOSITE Prepayment Contract CPE Amount
P_PrepaymentRefDocTotalAmount view inner COMPOSITE Prepayment Document Total Amount

Fields (1)

KeyField CDS FieldsUsed in Views
Commodity Commodity 8 
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MARA"
],
"ASSOCIATED":
[
"I_CMMDTY",
"I_MATERIALGROUP",
"I_MATERIALPLANT",
"I_MATERIALTEXT",
"I_MATERIALTYPE",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More