I_SDMassChgCkptSlsDocHdrChg

DDL: I_SDMASSCHGCKPTSLSDOCHDRCHG Type: view BASIC
47 Fields 1 Data Sources 3 Associations

Mass Chg of Sls Doc Header Change

I_SDMassChgCkptSlsDocHdrChg is a Basic CDS View that provides data about "Mass Chg of Sls Doc Header Change" in SAP S/4HANA. It reads from 1 data source (I_SDMassChgCkptSlsDocHdrChgBsc) and exposes 47 fields with key field SlsDocMassChangeRequestUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SDMassChgCkptSlsDocHdrChgBsc _HeaderChange from

Associations (3)

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

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISDMCCCHGHDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Mass Chg of Sls Doc Header 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 (47)

KeyFieldSource TableSource FieldDescription
KEY SlsDocMassChangeRequestUUID I_SDMassChgCkptSlsDocHdrChgBsc SlsDocMassChangeRequestUUID Job ID
SlsDocMassChgActionCategory SlsDocMassChgActionCategory Action Category
SlsDocMassChgActionID SlsDocMassChgActionID Action
SDDocumentReason SDDocumentReason Order Reason
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesDistrict SalesDistrict Sales District
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
ShippingCondition ShippingCondition Shipping Conditions
ShippingType ShippingType Shipping Type
ReceivingPoint ReceivingPoint Recv. Point
CustomerPaymentTerms CustomerPaymentTerms Pyt Terms
PaymentMethod PaymentMethod Pymt Meth.
TransactionCurrency TransactionCurrency Transaction Currency
PricingDate PricingDate Pricing Date
BillingDocumentDate BillingDocumentDate Billing Date
SalesDocumentDate SalesDocumentDate Document Date
IncotermsClassification IncotermsClassification Incoterms
IncotermsTransferLocation IncotermsTransferLocation Incoterms 2
IncotermsLocation1 IncotermsLocation1 Inco. Location1
IncotermsLocation2 IncotermsLocation2 Inco. Location2
IncotermsVersion IncotermsVersion Inco. Version
DeliveryBlockReason DeliveryBlockReason Delivery Block
HeaderBillingBlockReason HeaderBillingBlockReason Billing Block
SalesDocumentRjcnReason SalesDocumentRjcnReason RejectionReason
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
CustomerPurchaseOrderDate CustomerPurchaseOrderDate Purchase Order Date
CompleteDeliveryIsDefined CompleteDeliveryIsDefined Complete Dlv.
PricingType PricingType Pricing Type
_ChangeSalesDocument _ChangeSalesDocument
_ChangeRequest _ChangeRequest
_ChangeActionCategory _ChangeActionCategory
_ChangeActionID _ChangeActionID
_SalesGroup _SalesGroup
_SalesOffice _SalesOffice
_SDDocumentReason _SDDocumentReason
_SalesDistrict _SalesDistrict
_ShippingType _ShippingType
_ShippingCondition _ShippingCondition
_IncotermsClassification _IncotermsClassification
_IncotermsVersion _IncotermsVersion
_CustomerPaymentTerms _CustomerPaymentTerms
_TransactionCurrency _TransactionCurrency
_DeliveryBlockReason _DeliveryBlockReason
_HeaderBillingBlockReason _HeaderBillingBlockReason
_SalesDocumentRjcnReason _SalesDocumentRjcnReason
_PricingType _PricingType

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_SDMassChgCkptSlsDocHdrChg.
-- 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_SDMassChgCkptSlsDocHdrChg AS
SELECT
  _HeaderChange.SlsDocMassChangeRequestUUID AS SlsDocMassChangeRequestUUID,
  SlsDocMassChgActionCategory,
  SlsDocMassChgActionID,
  SDDocumentReason,
  SalesOffice,
  SalesGroup,
  SalesDistrict,
  RequestedDeliveryDate,
  ShippingCondition,
  ShippingType,
  ReceivingPoint,
  CustomerPaymentTerms,
  PaymentMethod,
  TransactionCurrency,
  PricingDate,
  BillingDocumentDate,
  SalesDocumentDate,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  DeliveryBlockReason,
  HeaderBillingBlockReason,
  SalesDocumentRjcnReason,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderDate,
  CompleteDeliveryIsDefined,
  PricingType
FROM I_SDMassChgCkptSlsDocHdrChgBsc AS _HeaderChange
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_SDMassChgCkptSlsDocHdrChgBsc AS _Extension ON SlsDocMassChangeRequestUUID = _Extension.SlsDocMassChangeRequestUUID  -- association [0..1]
;

Learn More