I_SDMassChgCkptSlsDocItemChg

DDL: I_SDMASSCHGCKPTSLSDOCITEMCHG Type: view BASIC
65 Fields 1 Data Sources 3 Associations

Mass Change of Sales Doc Item Change

I_SDMassChgCkptSlsDocItemChg is a Basic CDS View that provides data about "Mass Change of Sales Doc Item Change" in SAP S/4HANA. It reads from 1 data source (I_SDMassChgCkptSlsDocItmChgBsc) and exposes 65 fields with key field SlsDocMassChangeRequestUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SDMassChgCkptSlsDocItmChgBsc I_SDMassChgCkptSlsDocItmChgBsc from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_SDMassChgCkptChgSlsDoc _ChangeSalesDocument $projection.SlsDocMassChangeRequestUUID = _ChangeSalesDocument.SlsDocMassChangeRequestUUID
[1..1] I_SDMassChgCkptMassChgReqBsc _ChangeRequest $projection.SlsDocMassChangeRequestUUID = _ChangeRequest.SlsDocMassChangeRequestUUID
[0..1] E_SDMassChgCkptSlsDocItmChgBsc _Extension $projection.SlsDocMassChangeRequestUUID = _Extension.SlsDocMassChangeRequestUUID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISDMCCCHGITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Mass Change of Sales Doc Item Change view
VDM.viewType #BASIC view
ObjectModel.representativeKey SlsDocMassChangeRequestUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY SlsDocMassChangeRequestUUID SlsDocMassChangeRequestUUID Job ID
SlsDocMassChgActionCategory SlsDocMassChgActionCategory Action Category
SlsDocMassChgActionID SlsDocMassChgActionID Action
SalesDocumentItemCategory SalesDocumentItemCategory Item Category
Product Product Product Sold
SalesDocumentItemText SalesDocumentItemText Item Descr.
ProductHierarchyNode ProductHierarchyNode Prod. Hierarchy
Batch Batch Lot No.
Division Division Internal Division ID
DeliveryPriority DeliveryPriority Delivery Prior.
Plant Plant Valuation Area
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
UnloadingPointName UnloadingPointName Unloading Point Name
StorageLocation StorageLocation StorageLocation
ShippingPoint ShippingPoint Shipping Point
ShippingType ShippingType Shipping Type
Route Route Vehicle route
BillingDocumentDate BillingDocumentDate Billing Date
PricingDate PricingDate Pricing Date
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
ItemBillingBlockReason ItemBillingBlockReason Billing Block
SalesDocumentRjcnReason SalesDocumentRjcnReason RejectionReason
ExpdDelivQuantityChangeReason ExpdDelivQuantityChangeReason Return/Change Reason
ReturnReason ReturnReason Return Reason
CustRetItmFollowUpActivity CustRetItmFollowUpActivity Follow-Up Act.
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
IncotermsVersion IncotermsVersion Inco. Version
DeliveryBlockReason DeliveryBlockReason Delivery Block
WBSElementInternalID WBSElementInternalID WBS Internal ID
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
TransactionCurrency TransactionCurrency Transaction Currency
MaterialByCustomer MaterialByCustomer Customer Mat.
PricingType PricingType Pricing Type
ProfitCenter ProfitCenter Profit Center
WBSElementExternalID WBSElementExternalID WBS Element External ID
_ChangeSalesDocument _ChangeSalesDocument
_ChangeRequest _ChangeRequest
_ChangeActionCategory _ChangeActionCategory
_ChangeActionID _ChangeActionID
_ItemCategory _ItemCategory
_Product _Product
_ProductHierarchyNode _ProductHierarchyNode
_Batch _Batch
_Division _Division
_DeliveryPriority _DeliveryPriority
_Plant _Plant
_CustomerPaymentTerms _CustomerPaymentTerms
_IncotermsVersion _IncotermsVersion
_IncotermsClassification _IncotermsClassification
_StorageLocation _StorageLocation
_ShippingPoint _ShippingPoint
_ShippingType _ShippingType
_Route _Route
_ItemBillingBlockReason _ItemBillingBlockReason
_SalesDocumentRjcnReason _SalesDocumentRjcnReason
_ExpdDelivQtyChangeReason _ExpdDelivQtyChangeReason
_ReturnReason _ReturnReason
_DeliveryBlockReason _DeliveryBlockReason
_TransactionCurrency _TransactionCurrency
_PricingType _PricingType
_WBSElementExternalID _WBSElementExternalID

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_SDMassChgCkptSlsDocItemChg.
-- 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.

CREATE VIEW I_SDMassChgCkptSlsDocItemChg AS
SELECT
  SlsDocMassChangeRequestUUID,
  SlsDocMassChgActionCategory,
  SlsDocMassChgActionID,
  SalesDocumentItemCategory,
  Product,
  SalesDocumentItemText,
  ProductHierarchyNode,
  Batch,
  Division,
  DeliveryPriority,
  Plant,
  CustomerPaymentTerms,
  UnloadingPointName,
  StorageLocation,
  ShippingPoint,
  ShippingType,
  Route,
  BillingDocumentDate,
  PricingDate,
  RequestedDeliveryDate,
  ItemBillingBlockReason,
  SalesDocumentRjcnReason,
  ExpdDelivQuantityChangeReason,
  ReturnReason,
  CustRetItmFollowUpActivity,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  DeliveryBlockReason,
  WBSElementInternalID,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  TransactionCurrency,
  MaterialByCustomer,
  PricingType,
  ProfitCenter,
  WBSElementExternalID
FROM I_SDMassChgCkptSlsDocItmChgBsc
LEFT OUTER JOIN I_SDMassChgCkptChgSlsDoc AS _ChangeSalesDocument ON SlsDocMassChangeRequestUUID = _ChangeSalesDocument.SlsDocMassChangeRequestUUID  -- association [1..*]
LEFT OUTER JOIN I_SDMassChgCkptMassChgReqBsc AS _ChangeRequest ON SlsDocMassChangeRequestUUID = _ChangeRequest.SlsDocMassChangeRequestUUID  -- association [1..1]
LEFT OUTER JOIN E_SDMassChgCkptSlsDocItmChgBsc AS _Extension ON SlsDocMassChangeRequestUUID = _Extension.SlsDocMassChangeRequestUUID  -- association [0..1]
;

Learn More