I_SUPDMNDOVWPLANT

CDS View

Basic view for Plant

I_SUPDMNDOVWPLANT is a CDS View in S/4HANA. Basic view for Plant. It contains 11 fields. 57 CDS views read from this table.

CDS Views using this table (57)

ViewTypeJoinVDMDescription
I_SupDmndAllDoc3rdPtyOrdAssgC view inner COMPOSITE Cube View for Third Party Orders Assignment Details
I_SupDmndAllDoc3rdPtyOrdCube view inner COMPOSITE Cube View for Third Party Orders
I_SupDmndAllDocAssgmt view left_outer COMPOSITE View for Assignment for all Modes
I_SupDmndAllDocBatStkAssgC view inner COMPOSITE Cube View for Batch Stock Assignment Details
I_SupDmndAllDocBatStkC view inner COMPOSITE Cube View for Batch Stock Details
I_SupDmndAllDocCnsmpnCube view inner COMPOSITE Cube View for Planned Independent Requirement Consumption
I_SupDmndAllDocConfAssgC view inner COMPOSITE Cube View for Supplier Confirmations Assignment Details
I_SupDmndAllDocConfCube view inner COMPOSITE Cube View for Supplier Confirmations Details
I_SupDmndAllDocContrAssgC view inner COMPOSITE Cube View for Contract Assignment Details
I_SupDmndAllDocContrCube view inner COMPOSITE Cube View for Contract Details
I_SupDmndAllDocGdsIssdDelivC view inner COMPOSITE Cube View for Goods Issued Deliveries
I_SupDmndAllDocMakeToOrdAssgC view inner COMPOSITE Cube View for Make To Order Assignment Details
I_SupDmndAllDocMakeToOrdCube view inner COMPOSITE Cube View for Make To Order Details
I_SupDmndAllDocNonBatStkAssgC view inner COMPOSITE Cube View for Non Batch Stock Assignment Details
I_SupDmndAllDocNonBatStkC view inner COMPOSITE Cube View for Non Batch Stock Details
I_SupDmndAllDocOpenDelivC view inner COMPOSITE Cube View for Open Delivery Details
I_SupDmndAllDocPlndIndepRqmt1C view inner COMPOSITE Cube View for Planned Independent Requirement Assignments
I_SupDmndAllDocPlndIndepRqmtC view inner COMPOSITE Cube View for Planned Independent Requirement Details
I_SupDmndAllDocPlndOrdAssgC view inner COMPOSITE Cube View for Planned Order Assignment Details
I_SupDmndAllDocPlndOrdComp1C view inner COMPOSITE Cube View for Planned Order Components Assignment Details
I_SupDmndAllDocPlndOrdCompC view inner COMPOSITE Cube View for Planned Order Components
I_SupDmndAllDocPlndOrdCube view inner COMPOSITE Cube View for Planned Order Details
I_SupDmndAllDocPOAssgC view inner COMPOSITE Cube View for Purchase Order Assignment Details
I_SupDmndAllDocPOCube view inner COMPOSITE Cube View for Purchase Order Details
I_SupDmndAllDocProdnOrdAssgC view inner COMPOSITE Cube View for Production Order Assignment Details
I_SupDmndAllDocProdnOrdC view inner COMPOSITE Cube View for Production Order Details
I_SupDmndAllDocProdnOrdComp1C view inner COMPOSITE Cube View for Production Order Components Assignment Details
I_SupDmndAllDocProdnOrdCompC view inner COMPOSITE Cube View for Production Order Components
I_SupDmndAllDocPurgContrAssgC view left_outer COMPOSITE Cube View for Purchasing Contract Assignment Details
I_SupDmndAllDocPurgContrC view left_outer COMPOSITE Cube View for Purchasing Contract Details
I_SupDmndAllDocPurgContrRefC view left_outer COMPOSITE Cube View for Purchasing Contract Reference Details
I_SupDmndAllDocPurOrdComp1C view inner COMPOSITE Cube View for Sub Contracting PO Components Assignments
I_SupDmndAllDocPurOrdCompC view inner COMPOSITE Cube View for Sub Contracting Purchase Order Components
I_SupDmndAllDocPurReqnAssgC view inner COMPOSITE Cube View for Purchase Requisition Assignment Details
I_SupDmndAllDocPurReqnComp1C view inner COMPOSITE Cube View for Sub Contracting PR Components Assignments
I_SupDmndAllDocPurReqnCompC view inner COMPOSITE Cube View for Sub Contracting Purchase Requisition Component
I_SupDmndAllDocPurReqnCube view inner COMPOSITE Cube View for Purchase Requisition Details
I_SupDmndAllDocPurToOrdAssgC view inner COMPOSITE Cube View for Purchase To Order Assignment Details
I_SupDmndAllDocPurToOrdCube view inner COMPOSITE Cube View for Purchase To Order Details
I_SupDmndAllDocRetDelivAssgC view inner COMPOSITE Cube View for Return Deliveries Assignment Details
I_SupDmndAllDocRetDelivC view inner COMPOSITE Cube View for Return Deliveries Details
I_SupDmndAllDocRetSlsOrdAssgC view inner COMPOSITE Cube View for Return Sales Orders Assignment Details
I_SupDmndAllDocRetSlsOrdC view inner COMPOSITE Cube View for Return Sales Orders Details
I_SupDmndAllDocRetsSupAssgC view inner COMPOSITE Cube View for Returns from PO/STO Assignment Details
I_SupDmndAllDocRetsSupC view inner COMPOSITE Cube View for Returns from PO/STO
I_SupDmndAllDocSlsOrdAssgC view inner COMPOSITE Cube View for Sales Order Assignment Details
I_SupDmndAllDocSlsOrdCube view inner COMPOSITE Cube View for Sales Order Details
I_SupDmndAllDocStkTransptReq1C view inner COMPOSITE Cube View for Stock Transport Requisition Assignment Details
I_SupDmndAllDocStkTransptReqnC view inner COMPOSITE Cube View for Stock Transport Requisition Details
I_SupDmndAllDocSTOAssgC view inner COMPOSITE Cube View for Stock Transport Order Assignment Details
I_SupDmndAllDocSTOCube view inner COMPOSITE Cube View for Stock Transport Order Details
I_SupDmndAllDocSupProt1C view inner COMPOSITE Supply Protection Assignment Details
I_SupDmndAllDocSupProtC view inner COMPOSITE Supply Protection relevant for Supply Assignment
I_SupDmndAllDocSupProtCnsmpnC view inner COMPOSITE Suppy Protection Consumption Details
I_SupDmndAllDocTotDmnd view inner COMPOSITE View for Total Demand of All Document Types
I_SupDmndAllDocTotSup view left_outer COMPOSITE View for Total Supply of All Document Types
I_SupDmndOvwTotalSupply view inner COMPOSITE Basic View for Supply Overview

Fields (11)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 24
Country PlantCountry 1
DistributionChannel DistributionChannel 39
Division Division 37
PlantCustomer Customer,PlantCustomer 18
PlantSupplier PlantSupplier 1
PurchasingOrganization PurchasingOrganization 8
Region PlantRegion 1
SalesDistrict SalesDistrict 37
SalesOrganization SalesOrganization 37
ShippingPoint ShippingPoint 1
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Basic view for Plant'
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@AbapCatalog: {
  sqlViewName: 'ISUPDMNDOVWP',
  compiler.compareFilter: true
 }
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #X,
     sizeCategory:   #XXL
   }
}
define view I_SupDmndOvwPlant
  as select from    t001w as Plant
    left outer join t001k as PlantArea on  Plant.mandt = PlantArea.mandt
                                       and Plant.werks = PlantArea.bwkey

{
  Plant.vkorg        as    SalesOrganization,
  Plant.vtweg        as    DistributionChannel,
  Plant.kunnr        as    PlantCustomer,
  Plant.lifnr        as    PlantSupplier,
  Plant.spart        as    Division,
  Plant.werks        as    Plant,
  Plant.vstel        as    ShippingPoint,
  Plant.bzirk        as    SalesDistrict,
  PlantArea.bukrs    as    CompanyCode,
  Plant.ekorg        as    PurchasingOrganization,
  Plant.land1        as    Country,
  Plant.regio        as    Region
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001K",
"T001W"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/