I_SalesPlanItemWithDraft

DDL: I_SALESPLANITEMWITHDRAFT SQL: ISDSPITEMWDRAFT Type: view COMPOSITE Package: VDM_SD_SP
50 Fields 1 Data Sources

Sales Plan With Draft

I_SalesPlanItemWithDraft is a Composite CDS View that provides data about "Sales Plan With Draft" in SAP S/4HANA. It reads from 1 data source (P_SalesPlanItemWithDraft) and exposes 50 fields with key field SalesPlanItemUUID. Part of development package VDM_SD_SP.

Data Sources (1)

SourceAliasJoin Type
P_SalesPlanItemWithDraft SPI from

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AbapCatalog.sqlViewName ISDSPITEMWDRAFT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Sales Plan With Draft view
VDM.viewType #COMPOSITE view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY SalesPlanItemUUID P_SalesPlanItemWithDraft SalesPlanItemUUID SP Item UUID
SalesPlanUUID P_SalesPlanItemWithDraft SalesPlanUUID Sales Plan UUID
SalesOrganization P_SalesPlanItemWithDraft SalesOrganization Sales Organization
DistributionChannel P_SalesPlanItemWithDraft DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision P_SalesPlanItemWithDraft OrganizationDivision Org. Division
SalesOffice P_SalesPlanItemWithDraft SalesOffice Sales Office
SalesGroup P_SalesPlanItemWithDraft SalesGroup Sales Group
SalesDistrict P_SalesPlanItemWithDraft SalesDistrict Sales District
CustomerGroup P_SalesPlanItemWithDraft CustomerGroup Customer Group
Customer P_SalesPlanItemWithDraft Customer Sold-to Party
ShipToParty P_SalesPlanItemWithDraft ShipToParty Ship-To Party (obsolete)
BillToParty P_SalesPlanItemWithDraft BillToParty Inv. Recipient
PayerParty P_SalesPlanItemWithDraft PayerParty Payer
AdditionalCustomerGroup1 P_SalesPlanItemWithDraft AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 P_SalesPlanItemWithDraft AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 P_SalesPlanItemWithDraft AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 P_SalesPlanItemWithDraft AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 P_SalesPlanItemWithDraft AdditionalCustomerGroup5 Customer Grp 5
Division P_SalesPlanItemWithDraft Division Internal Division ID
MaterialGroup P_SalesPlanItemWithDraft MaterialGroup Product Group
Material P_SalesPlanItemWithDraft Material Vehicle Model
AdditionalMaterialGroup1 P_SalesPlanItemWithDraft AdditionalMaterialGroup1 MaterialGroup 1
AdditionalMaterialGroup2 P_SalesPlanItemWithDraft AdditionalMaterialGroup2 MaterialGroup 2
AdditionalMaterialGroup3 P_SalesPlanItemWithDraft AdditionalMaterialGroup3 MaterialGroup 3
AdditionalMaterialGroup4 P_SalesPlanItemWithDraft AdditionalMaterialGroup4 MaterialGroup 4
AdditionalMaterialGroup5 P_SalesPlanItemWithDraft AdditionalMaterialGroup5 MaterialGroup 5
SalesEmployee P_SalesPlanItemWithDraft SalesEmployee Sales Employee
Plant P_SalesPlanItemWithDraft Plant Valuation Area
ShippingType P_SalesPlanItemWithDraft ShippingType Shipping Type
ProfitCenter P_SalesPlanItemWithDraft ProfitCenter Profit Center
CostCenter P_SalesPlanItemWithDraft CostCenter Cost Center
CompanyCode P_SalesPlanItemWithDraft CompanyCode Receiver Company Code
ControllingArea P_SalesPlanItemWithDraft ControllingArea Controlling Area
BusinessArea P_SalesPlanItemWithDraft BusinessArea Business Area
Country P_SalesPlanItemWithDraft Country Venue: Ctry/Reg
BillToPartyCountry P_SalesPlanItemWithDraft BillToPartyCountry Dst.CtryRg.Ord.
Region P_SalesPlanItemWithDraft Region Venue Region
BillToPartyRegion P_SalesPlanItemWithDraft BillToPartyRegion Region Order
SalesPlanPeriod P_SalesPlanItemWithDraft SalesPlanPeriod Sales Plan period
SalesPlanAmount P_SalesPlanItemWithDraft SalesPlanAmount Sales Plan amount
SalesPlanCurrency P_SalesPlanItemWithDraft SalesPlanCurrency Currency
_SalesOrganization P_SalesPlanItemWithDraft _SalesOrganization
_DistributionChannel P_SalesPlanItemWithDraft _DistributionChannel
_Division P_SalesPlanItemWithDraft _Division
_CustomerGroup P_SalesPlanItemWithDraft _CustomerGroup
_Customer P_SalesPlanItemWithDraft _Customer
_MaterialGroup P_SalesPlanItemWithDraft _MaterialGroup
_Material P_SalesPlanItemWithDraft _Material
_SalesEmployee_2 P_SalesPlanItemWithDraft _SalesEmployee_2
_SalesPlanCurrency P_SalesPlanItemWithDraft _SalesPlanCurrency

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 I_SalesPlanItemWithDraft.
-- 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.
-- SQL view name: ISDSPITEMWDRAFT

CREATE VIEW I_SalesPlanItemWithDraft AS
SELECT
  SPI.SalesPlanItemUUID AS SalesPlanItemUUID,
  SPI.SalesPlanUUID AS SalesPlanUUID,
  SPI.SalesOrganization AS SalesOrganization,
  SPI.DistributionChannel AS DistributionChannel,
  SPI.OrganizationDivision AS OrganizationDivision,
  SPI.SalesOffice AS SalesOffice,
  SPI.SalesGroup AS SalesGroup,
  SPI.SalesDistrict AS SalesDistrict,
  SPI.CustomerGroup AS CustomerGroup,
  SPI.Customer AS Customer,
  SPI.ShipToParty AS ShipToParty,
  SPI.BillToParty AS BillToParty,
  SPI.PayerParty AS PayerParty,
  SPI.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SPI.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SPI.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SPI.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SPI.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SPI.Division AS Division,
  SPI.MaterialGroup AS MaterialGroup,
  SPI.Material AS Material,
  SPI.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  SPI.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  SPI.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  SPI.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  SPI.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  SPI.SalesEmployee AS SalesEmployee,
  SPI.Plant AS Plant,
  SPI.ShippingType AS ShippingType,
  SPI.ProfitCenter AS ProfitCenter,
  SPI.CostCenter AS CostCenter,
  SPI.CompanyCode AS CompanyCode,
  SPI.ControllingArea AS ControllingArea,
  SPI.BusinessArea AS BusinessArea,
  SPI.Country AS Country,
  SPI.BillToPartyCountry AS BillToPartyCountry,
  SPI.Region AS Region,
  SPI.BillToPartyRegion AS BillToPartyRegion,
  SPI.SalesPlanPeriod AS SalesPlanPeriod,
  SPI.SalesPlanAmount AS SalesPlanAmount,
  SPI.SalesPlanCurrency AS SalesPlanCurrency,
  SPI._SalesOrganization AS _SalesOrganization,
  SPI._DistributionChannel AS _DistributionChannel,
  SPI._Division AS _Division,
  SPI._CustomerGroup AS _CustomerGroup,
  SPI._Customer AS _Customer,
  SPI._MaterialGroup AS _MaterialGroup,
  SPI._Material AS _Material,
  SPI._SalesEmployee_2 AS _SalesEmployee_2,
  SPI._SalesPlanCurrency AS _SalesPlanCurrency
FROM P_SalesPlanItemWithDraft AS SPI
;

Learn More