I_SUPDMNDOVWPLANT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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":""
}
}*/