P_SLSDOCITMBSCDATA
Sales Document Item Analytics
P_SLSDOCITMBSCDATA is a Composite CDS View that provides data about "Sales Document Item Analytics" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItem) and exposes 184 fields with key fields SalesDocument, SalesDocumentItem. Part of development package VDM_SD_ANALYTICS.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SalesDocumentItem | SDI | from |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | PSLSDOCITMBSC | view | |
| AbapCatalog.preserveKey | true | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view |
Fields (184)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesDocument | I_SalesDocumentItem | SalesDocument | SD Document |
| _SalesDocument | _SalesDocument | |||
| KEY | SalesDocumentItem | I_SalesDocumentItem | SalesDocumentItem | Sales Document Item |
| SoldToParty | I_SalesDocumentItem | SoldToParty | Sold-to Party | |
| _SoldToParty | I_SalesDocumentItem | _SoldToParty | ||
| ShipToParty | I_SalesDocumentItem | ShipToParty | Ship-To Party (obsolete) | |
| _ShipToParty | I_SalesDocumentItem | _ShipToParty | ||
| PayerParty | I_SalesDocumentItem | PayerParty | Payer | |
| _PayerParty | I_SalesDocumentItem | _PayerParty | ||
| BillToParty | I_SalesDocumentItem | BillToParty | Inv. Recipient | |
| _BillToParty | I_SalesDocumentItem | _BillToParty | ||
| SalesEmployee | I_SalesDocumentItem | SalesEmployee | Sales Employee | |
| _SalesEmployee | I_SalesDocumentItem | _SalesEmployee | ||
| ResponsibleEmployee | I_SalesDocumentItem | ResponsibleEmployee | Employee Resp. | |
| _ResponsibleEmployee | I_SalesDocumentItem | _ResponsibleEmployee | ||
| SDDocumentCategory | I_SalesDocumentItem | SDDocumentCategory | Document Cat. | |
| _SDDocumentCategory | I_SalesDocumentItem | _SDDocumentCategory | ||
| SalesDocumentType | I_SalesDocumentItem | SalesDocumentType | Sales Doc. Type | |
| _SalesDocumentType | I_SalesDocumentItem | _SalesDocumentType | ||
| SalesDocumentItemCategory | I_SalesDocumentItem | SalesDocumentItemCategory | Item Category | |
| _ItemCategory | I_SalesDocumentItem | _ItemCategory | ||
| SalesDocumentItemType | I_SalesDocumentItem | SalesDocumentItemType | Item Type | |
| CreatedByUser | I_SalesDocumentItem | CreatedByUser | User Name | |
| _CreatedByUser | I_SalesDocumentItem | _CreatedByUser | ||
| CreationDate | I_SalesDocumentItem | CreationDate | Time Stamp | |
| CreationTime | I_SalesDocumentItem | CreationTime | Time of Change | |
| LastChangeDate | I_SalesDocumentItem | LastChangeDate | Time Stamp | |
| SalesOrganization | I_SalesDocumentItem | SalesOrganization | Sales Organization | |
| _SalesOrganization | I_SalesDocumentItem | _SalesOrganization | ||
| DistributionChannel | I_SalesDocumentItem | DistributionChannel | RefDistCh-Cust/Mat. | |
| _DistributionChannel | I_SalesDocumentItem | _DistributionChannel | ||
| OrganizationDivision | I_SalesDocumentItem | OrganizationDivision | Org. Division | |
| _OrganizationDivision | I_SalesDocumentItem | _OrganizationDivision | ||
| SalesOffice | I_SalesDocumentItem | SalesOffice | Sales Office | |
| _SalesOffice | I_SalesDocumentItem | _SalesOffice | ||
| SalesGroup | I_SalesDocumentItem | SalesGroup | Sales Group | |
| _SalesGroup | I_SalesDocumentItem | _SalesGroup | ||
| SalesDistrict | I_SalesDocumentItem | SalesDistrict | Sales District | |
| _SalesDistrict | I_SalesDocumentItem | _SalesDistrict | ||
| Division | I_SalesDocumentItem | Division | Internal Division ID | |
| _Division | I_SalesDocumentItem | _Division | ||
| Material | I_SalesDocumentItem | Material | Vehicle Model | |
| _Material | I_SalesDocumentItem | _Material | ||
| _MaterialText | I_SalesDocumentItem | _MaterialText | ||
| OriginallyRequestedMaterial | I_SalesDocumentItem | OriginallyRequestedMaterial | MaterialEntered | |
| _OriginallyRequestedMaterial | I_SalesDocumentItem | _OriginallyRequestedMaterial | ||
| MaterialGroup | I_SalesDocumentItem | MaterialGroup | Product Group | |
| _MaterialGroup | I_SalesDocumentItem | _MaterialGroup | ||
| SDDocumentReason | I_SalesDocumentItem | SDDocumentReason | Order Reason | |
| _SDDocumentReason | I_SalesDocumentItem | _SDDocumentReason | ||
| SalesDocumentItemText | I_SalesDocumentItem | SalesDocumentItemText | Item Descr. | |
| SalesDocumentDate | I_SalesDocumentItem | SalesDocumentDate | Document Date | |
| SalesDocumentRjcnReason | I_SalesDocumentItem | SalesDocumentRjcnReason | RejectionReason | |
| _SalesDocumentRjcnReason | I_SalesDocumentItem | _SalesDocumentRjcnReason | ||
| OrderQuantityUnit | I_SalesDocumentItem | OrderQuantityUnit | Sales Unit | |
| _OrderQuantityUnit | I_SalesDocumentItem | _OrderQuantityUnit | ||
| BaseUnit | I_SalesDocumentItem | BaseUnit | Unit of Measure | |
| _BaseUnit | I_SalesDocumentItem | _BaseUnit | ||
| ItemWeightUnit | I_SalesDocumentItem | ItemWeightUnit | Unit of Weight | |
| _ItemWeightUnit | I_SalesDocumentItem | _ItemWeightUnit | ||
| ItemGrossWeight | I_SalesDocumentItem | ItemGrossWeight | Gross Weight | |
| ItemNetWeight | I_SalesDocumentItem | ItemNetWeight | Net Weight | |
| ItemVolumeUnit | I_SalesDocumentItem | ItemVolumeUnit | Volume Unit | |
| _ItemVolumeUnit | I_SalesDocumentItem | _ItemVolumeUnit | ||
| ItemVolume | I_SalesDocumentItem | ItemVolume | Volume | |
| QuantityIsFixed | I_SalesDocumentItem | QuantityIsFixed | Qty. is fixed | |
| BindingPeriodValidityStartDate | ||||
| BindingPeriodValidityEndDate | ||||
| OutlineAgreementTargetAmount | I_SalesDocumentItem | OutlineAgreementTargetAmount | Target Value | |
| TransactionCurrency | I_SalesDocumentItem | TransactionCurrency | Transaction Currency | |
| _TransactionCurrency | I_SalesDocumentItem | _TransactionCurrency | ||
| NetAmount | ||||
| NetPriceAmount | I_SalesDocumentItem | NetPriceAmount | Net Price | |
| NetPriceQuantity | I_SalesDocumentItem | NetPriceQuantity | Price Unit | |
| NetPriceQuantityUnit | I_SalesDocumentItem | NetPriceQuantityUnit | SettlmtPrcUnit | |
| _NetPriceQuantityUnit | I_SalesDocumentItem | _NetPriceQuantityUnit | ||
| StatisticalValueControl | I_SalesDocumentItem | StatisticalValueControl | Stat. Value | |
| _StatisticalValueControl | I_SalesDocumentItem | _StatisticalValueControl | ||
| TaxAmount | I_SalesDocumentItem | TaxAmount | Tax Amt in Rptg Crcy | |
| CostAmount | I_SalesDocumentItem | CostAmount | Cost | |
| Subtotal1Amount | I_SalesDocumentItem | Subtotal1Amount | Subtotal 1 Amount | |
| Subtotal2Amount | I_SalesDocumentItem | Subtotal2Amount | Subtotal 2 Amount | |
| Subtotal3Amount | I_SalesDocumentItem | Subtotal3Amount | Subtotal 3 Amount | |
| Subtotal4Amount | I_SalesDocumentItem | Subtotal4Amount | Subtotal 4 Amount | |
| Subtotal5Amount | I_SalesDocumentItem | Subtotal5Amount | Subtotal 5 Amount | |
| Subtotal6Amount | I_SalesDocumentItem | Subtotal6Amount | Subtotal 6 Amount | |
| InventorySpecialStockType | I_SalesDocumentItem | InventorySpecialStockType | Special Stock Type | |
| DeliveryDateQuantityIsFixed | I_SalesDocumentItem | DeliveryDateQuantityIsFixed | Fixed Date | |
| ProfitCenter | I_SalesDocumentItem | ProfitCenter | Profit Center | |
| WBSElement | I_SalesDocumentItem | WBSElement | WBS Internal ID | |
| ControllingObject | I_SalesDocumentItem | ControllingObject | Object number | |
| ProfitabilitySegment | I_SalesDocumentItem | ProfitabilitySegment_2 | Profit. segment | |
| OriginSDDocument | I_SalesDocumentItem | OriginSDDocument | Originating Doc | |
| OriginSDDocumentItem | I_SalesDocumentItem | OriginSDDocumentItem | Origin. Item | |
| ReferenceSDDocument | I_SalesDocumentItem | ReferenceSDDocument | Reference Doc. | |
| _ReferenceSDDocument | I_SalesDocumentItem | _ReferenceSDDocument | ||
| ReferenceSDDocumentItem | I_SalesDocumentItem | ReferenceSDDocumentItem | Reference Item | |
| _ReferenceSDDocumentItem | I_SalesDocumentItem | _ReferenceSDDocumentItem | ||
| ReferenceSDDocumentCategory | I_SalesDocumentItem | ReferenceSDDocumentCategory | Prec.Doc.Categ. | |
| _ReferenceSDDocumentCategory | I_SalesDocumentItem | _ReferenceSDDocumentCategory | ||
| HigherLevelItem | I_SalesDocumentItem | HigherLevelItem | Higher-Lev.Item | |
| OverallSDProcessStatus | ||||
| _OverallSDProcessStatus | ||||
| OverallPurchaseConfStatus | ||||
| _OverallPurchaseConfStatus | ||||
| OverallSDDocumentRejectionSts | ||||
| _OverallSDDocumentRejectionSts | ||||
| OverallSDDocReferenceStatus | ||||
| _OverallSDDocReferenceStatus | ||||
| TotalBlockStatus | ||||
| _TotalBlockStatus | ||||
| OverallDelivConfStatus | ||||
| _OverallDelivConfStatus | ||||
| OverallTotalDeliveryStatus | ||||
| _OverallTotalDeliveryStatus | ||||
| OverallDeliveryStatus | ||||
| _OverallDeliveryStatus | ||||
| OverallDeliveryBlockStatus | ||||
| _OverallDeliveryBlockStatus | ||||
| OverallOrdReltdBillgStatus | ||||
| _OverallOrdReltdBillgStatus | ||||
| OverallBillingBlockStatus | ||||
| _OverallBillingBlockStatus | ||||
| OverallTotalSDDocRefStatus | ||||
| _OverallTotalSDDocRefStatus | ||||
| TotalCreditCheckStatus | ||||
| _TotalCreditCheckStatus | ||||
| MaxDocValueCreditCheckStatus | ||||
| _MaxDocValueCreditCheckStatus | ||||
| PaymentTermCreditCheckStatus | ||||
| _PaymentTermCreditCheckStatus | ||||
| FinDocCreditCheckStatus | ||||
| _FinDocCreditCheckStatus | ||||
| ExprtInsurCreditCheckStatus | ||||
| _ExprtInsurCreditCheckStatus | ||||
| PaytAuthsnCreditCheckSts | ||||
| _PaytAuthsnCreditCheckSts | ||||
| CentralCreditCheckStatus | ||||
| _CentralCreditCheckStatus | ||||
| CentralCreditChkTechErrSts | ||||
| _CentralCreditChkTechErrSts | ||||
| HdrGeneralIncompletionStatus | ||||
| _HdrGeneralIncompletionStatus | ||||
| OverallPricingIncompletionSts | ||||
| _OverallPricingIncompletionSts | ||||
| HeaderDelivIncompletionStatus | ||||
| _HeaderDelivIncompletionStatus | ||||
| HeaderBillgIncompletionStatus | ||||
| _HeaderBillgIncompletionStatus | ||||
| OvrlItmGeneralIncompletionSts | ||||
| _OvrlItmGeneralIncompletionSts | ||||
| OvrlItmBillingIncompletionSts | ||||
| _OvrlItmBillingIncompletionSts | ||||
| OvrlItmDelivIncompletionSts | ||||
| _OvrlItmDelivIncompletionSts | ||||
| SDProcessStatus | I_SalesDocumentItem | SDProcessStatus | Overall Status | |
| _SDProcessStatus | I_SalesDocumentItem | _SDProcessStatus | ||
| DeliveryConfirmationStatus | I_SalesDocumentItem | DeliveryConfirmationStatus | Project stock | |
| _DeliveryConfirmationStatus | I_SalesDocumentItem | _DeliveryConfirmationStatus | ||
| PurchaseConfirmationStatus | I_SalesDocumentItem | PurchaseConfirmationStatus | ||
| _PurchaseConfirmationStatus | I_SalesDocumentItem | _PurchaseConfirmationStatus | ||
| TotalDeliveryStatus | I_SalesDocumentItem | TotalDeliveryStatus | Ovrl Deliv. Sts | |
| _TotalDeliveryStatus | I_SalesDocumentItem | _TotalDeliveryStatus | ||
| DeliveryStatus | I_SalesDocumentItem | DeliveryStatus | Delivery Status | |
| _DeliveryStatus | I_SalesDocumentItem | _DeliveryStatus | ||
| DeliveryBlockStatus | I_SalesDocumentItem | DeliveryBlockStatus | ||
| _DeliveryBlockStatus | I_SalesDocumentItem | _DeliveryBlockStatus | ||
| OrderRelatedBillingStatus | I_SalesDocumentItem | OrderRelatedBillingStatus | ||
| _OrderRelatedBillingStatus | I_SalesDocumentItem | _OrderRelatedBillingStatus | ||
| BillingBlockStatus | I_SalesDocumentItem | BillingBlockStatus | Billg Block Sts | |
| _BillingBlockStatus | I_SalesDocumentItem | _BillingBlockStatus | ||
| ItemGeneralIncompletionStatus | I_SalesDocumentItem | ItemGeneralIncompletionStatus | ||
| _ItemGeneralIncompletionStatus | I_SalesDocumentItem | _ItemGeneralIncompletionStatus | ||
| ItemBillingIncompletionStatus | I_SalesDocumentItem | ItemBillingIncompletionStatus | Billing Doc. | |
| _ItemBillingIncompletionStatus | I_SalesDocumentItem | _ItemBillingIncompletionStatus | ||
| PricingIncompletionStatus | I_SalesDocumentItem | PricingIncompletionStatus | Pricing – Item | |
| _PricingIncompletionStatus | I_SalesDocumentItem | _PricingIncompletionStatus | ||
| ItemDeliveryIncompletionStatus | I_SalesDocumentItem | ItemDeliveryIncompletionStatus | Delivery – Item | |
| _ItemDelivIncompletionSts | I_SalesDocumentItem | _ItemDelivIncompletionSts | ||
| SDDocumentRejectionStatus | I_SalesDocumentItem | SDDocumentRejectionStatus | Rejection Sts | |
| _SDDocumentRejectionStatus | I_SalesDocumentItem | _SDDocumentRejectionStatus | ||
| TotalSDDocReferenceStatus | I_SalesDocumentItem | TotalSDDocReferenceStatus | Ovrl Ref. Sts | |
| _TotalSDDocReferenceStatus | I_SalesDocumentItem | _TotalSDDocReferenceStatus | ||
| SDDocReferenceStatus | I_SalesDocumentItem | SDDocReferenceStatus | Reference Sts |
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 P_SLSDOCITMBSCDATA.
-- 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: PSLSDOCITMBSC
CREATE VIEW P_SLSDOCITMBSCDATA AS
SELECT
SDI.SalesDocument AS SalesDocument,
SDI.SalesDocumentItem AS SalesDocumentItem,
SDI.SoldToParty AS SoldToParty,
SDI._SoldToParty AS _SoldToParty,
SDI.ShipToParty AS ShipToParty,
SDI._ShipToParty AS _ShipToParty,
SDI.PayerParty AS PayerParty,
SDI._PayerParty AS _PayerParty,
SDI.BillToParty AS BillToParty,
SDI._BillToParty AS _BillToParty,
SDI.SalesEmployee AS SalesEmployee,
SDI._SalesEmployee AS _SalesEmployee,
SDI.ResponsibleEmployee AS ResponsibleEmployee,
SDI._ResponsibleEmployee AS _ResponsibleEmployee,
SDI.SDDocumentCategory AS SDDocumentCategory,
SDI._SDDocumentCategory AS _SDDocumentCategory,
SDI.SalesDocumentType AS SalesDocumentType,
SDI._SalesDocumentType AS _SalesDocumentType,
SDI.SalesDocumentItemCategory AS SalesDocumentItemCategory,
SDI._ItemCategory AS _ItemCategory,
SDI.SalesDocumentItemType AS SalesDocumentItemType,
SDI.CreatedByUser AS CreatedByUser,
SDI._CreatedByUser AS _CreatedByUser,
SDI.CreationDate AS CreationDate,
SDI.CreationTime AS CreationTime,
SDI.LastChangeDate AS LastChangeDate,
SDI.SalesOrganization AS SalesOrganization,
SDI._SalesOrganization AS _SalesOrganization,
SDI.DistributionChannel AS DistributionChannel,
SDI._DistributionChannel AS _DistributionChannel,
SDI.OrganizationDivision AS OrganizationDivision,
SDI._OrganizationDivision AS _OrganizationDivision,
SDI.SalesOffice AS SalesOffice,
SDI._SalesOffice AS _SalesOffice,
SDI.SalesGroup AS SalesGroup,
SDI._SalesGroup AS _SalesGroup,
SDI.SalesDistrict AS SalesDistrict,
SDI._SalesDistrict AS _SalesDistrict,
SDI.Division AS Division,
SDI._Division AS _Division,
SDI.Material AS Material,
SDI._Material AS _Material,
SDI._MaterialText AS _MaterialText,
SDI.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
SDI._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
SDI.MaterialGroup AS MaterialGroup,
SDI._MaterialGroup AS _MaterialGroup,
SDI.SDDocumentReason AS SDDocumentReason,
SDI._SDDocumentReason AS _SDDocumentReason,
SDI.SalesDocumentItemText AS SalesDocumentItemText,
SDI.SalesDocumentDate AS SalesDocumentDate,
SDI.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
SDI._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
SDI.OrderQuantityUnit AS OrderQuantityUnit,
SDI._OrderQuantityUnit AS _OrderQuantityUnit,
SDI.BaseUnit AS BaseUnit,
SDI._BaseUnit AS _BaseUnit,
SDI.ItemWeightUnit AS ItemWeightUnit,
SDI._ItemWeightUnit AS _ItemWeightUnit,
SDI.ItemGrossWeight AS ItemGrossWeight,
SDI.ItemNetWeight AS ItemNetWeight,
SDI.ItemVolumeUnit AS ItemVolumeUnit,
SDI._ItemVolumeUnit AS _ItemVolumeUnit,
SDI.ItemVolume AS ItemVolume,
SDI.QuantityIsFixed AS QuantityIsFixed,
SDI._SalesDocument.BindingPeriodValidityStartDate AS BindingPeriodValidityStartDate,
SDI._SalesDocument.BindingPeriodValidityEndDate AS BindingPeriodValidityEndDate,
SDI.OutlineAgreementTargetAmount AS OutlineAgreementTargetAmount,
SDI.TransactionCurrency AS TransactionCurrency,
SDI._TransactionCurrency AS _TransactionCurrency,
cast( SDI.NetAmount as slsorditm_netamount ) AS NetAmount,
SDI.NetPriceAmount AS NetPriceAmount,
SDI.NetPriceQuantity AS NetPriceQuantity,
SDI.NetPriceQuantityUnit AS NetPriceQuantityUnit,
SDI._NetPriceQuantityUnit AS _NetPriceQuantityUnit,
SDI.StatisticalValueControl AS StatisticalValueControl,
SDI._StatisticalValueControl AS _StatisticalValueControl,
SDI.TaxAmount AS TaxAmount,
SDI.CostAmount AS CostAmount,
SDI.Subtotal1Amount AS Subtotal1Amount,
SDI.Subtotal2Amount AS Subtotal2Amount,
SDI.Subtotal3Amount AS Subtotal3Amount,
SDI.Subtotal4Amount AS Subtotal4Amount,
SDI.Subtotal5Amount AS Subtotal5Amount,
SDI.Subtotal6Amount AS Subtotal6Amount,
SDI.InventorySpecialStockType AS InventorySpecialStockType,
SDI.DeliveryDateQuantityIsFixed AS DeliveryDateQuantityIsFixed,
SDI.ProfitCenter AS ProfitCenter,
SDI.WBSElement AS WBSElement,
SDI.ControllingObject AS ControllingObject,
SDI.ProfitabilitySegment_2 AS ProfitabilitySegment,
SDI.OriginSDDocument AS OriginSDDocument,
SDI.OriginSDDocumentItem AS OriginSDDocumentItem,
SDI.ReferenceSDDocument AS ReferenceSDDocument,
SDI._ReferenceSDDocument AS _ReferenceSDDocument,
SDI.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
SDI._ReferenceSDDocumentItem AS _ReferenceSDDocumentItem,
SDI.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
SDI._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
SDI.HigherLevelItem AS HigherLevelItem,
SDI._SalesDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
SDI._SalesDocument._OverallSDProcessStatus AS _OverallSDProcessStatus,
SDI._SalesDocument.OverallPurchaseConfStatus AS OverallPurchaseConfStatus,
SDI._SalesDocument._OverallPurchaseConfStatus AS _OverallPurchaseConfStatus,
SDI._SalesDocument.OverallSDDocumentRejectionSts AS OverallSDDocumentRejectionSts,
SDI._SalesDocument._OverallSDDocumentRejectionSts AS _OverallSDDocumentRejectionSts,
SDI._SalesDocument.OverallSDDocReferenceStatus AS OverallSDDocReferenceStatus,
SDI._SalesDocument._OverallSDDocReferenceStatus AS _OverallSDDocReferenceStatus,
SDI._SalesDocument.TotalBlockStatus AS TotalBlockStatus,
SDI._SalesDocument._TotalBlockStatus AS _TotalBlockStatus,
SDI._SalesDocument.OverallDelivConfStatus AS OverallDelivConfStatus,
SDI._SalesDocument._OverallDelivConfStatus AS _OverallDelivConfStatus,
SDI._SalesDocument.OverallTotalDeliveryStatus AS OverallTotalDeliveryStatus,
SDI._SalesDocument._OverallTotalDeliveryStatus AS _OverallTotalDeliveryStatus,
SDI._SalesDocument.OverallDeliveryStatus AS OverallDeliveryStatus,
SDI._SalesDocument._OverallDeliveryStatus AS _OverallDeliveryStatus,
SDI._SalesDocument.OverallDeliveryBlockStatus AS OverallDeliveryBlockStatus,
SDI._SalesDocument._OverallDeliveryBlockStatus AS _OverallDeliveryBlockStatus,
SDI._SalesDocument.OverallOrdReltdBillgStatus AS OverallOrdReltdBillgStatus,
SDI._SalesDocument._OverallOrdReltdBillgStatus AS _OverallOrdReltdBillgStatus,
SDI._SalesDocument.OverallBillingBlockStatus AS OverallBillingBlockStatus,
SDI._SalesDocument._OverallBillingBlockStatus AS _OverallBillingBlockStatus,
SDI._SalesDocument.OverallTotalSDDocRefStatus AS OverallTotalSDDocRefStatus,
SDI._SalesDocument._OverallTotalSDDocRefStatus AS _OverallTotalSDDocRefStatus,
SDI._SalesDocument.TotalCreditCheckStatus AS TotalCreditCheckStatus,
SDI._SalesDocument._TotalCreditCheckStatus AS _TotalCreditCheckStatus,
SDI._SalesDocument.MaxDocValueCreditCheckStatus AS MaxDocValueCreditCheckStatus,
SDI._SalesDocument._MaxDocValueCreditCheckStatus AS _MaxDocValueCreditCheckStatus,
SDI._SalesDocument.PaymentTermCreditCheckStatus AS PaymentTermCreditCheckStatus,
SDI._SalesDocument._PaymentTermCreditCheckStatus AS _PaymentTermCreditCheckStatus,
SDI._SalesDocument.FinDocCreditCheckStatus AS FinDocCreditCheckStatus,
SDI._SalesDocument._FinDocCreditCheckStatus AS _FinDocCreditCheckStatus,
SDI._SalesDocument.ExprtInsurCreditCheckStatus AS ExprtInsurCreditCheckStatus,
SDI._SalesDocument._ExprtInsurCreditCheckStatus AS _ExprtInsurCreditCheckStatus,
SDI._SalesDocument.PaytAuthsnCreditCheckSts AS PaytAuthsnCreditCheckSts,
SDI._SalesDocument._PaytAuthsnCreditCheckSts AS _PaytAuthsnCreditCheckSts,
SDI._SalesDocument.CentralCreditCheckStatus AS CentralCreditCheckStatus,
SDI._SalesDocument._CentralCreditCheckStatus AS _CentralCreditCheckStatus,
SDI._SalesDocument.CentralCreditChkTechErrSts AS CentralCreditChkTechErrSts,
SDI._SalesDocument._CentralCreditChkTechErrSts AS _CentralCreditChkTechErrSts,
SDI._SalesDocument.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
SDI._SalesDocument._HdrGeneralIncompletionStatus AS _HdrGeneralIncompletionStatus,
SDI._SalesDocument.OverallPricingIncompletionSts AS OverallPricingIncompletionSts,
SDI._SalesDocument._OverallPricingIncompletionSts AS _OverallPricingIncompletionSts,
SDI._SalesDocument.HeaderDelivIncompletionStatus AS HeaderDelivIncompletionStatus,
SDI._SalesDocument._HeaderDelivIncompletionStatus AS _HeaderDelivIncompletionStatus,
SDI._SalesDocument.HeaderBillgIncompletionStatus AS HeaderBillgIncompletionStatus,
SDI._SalesDocument._HeaderBillgIncompletionStatus AS _HeaderBillgIncompletionStatus,
SDI._SalesDocument.OvrlItmGeneralIncompletionSts AS OvrlItmGeneralIncompletionSts,
SDI._SalesDocument._OvrlItmGeneralIncompletionSts AS _OvrlItmGeneralIncompletionSts,
SDI._SalesDocument.OvrlItmBillingIncompletionSts AS OvrlItmBillingIncompletionSts,
SDI._SalesDocument._OvrlItmBillingIncompletionSts AS _OvrlItmBillingIncompletionSts,
SDI._SalesDocument.OvrlItmDelivIncompletionSts AS OvrlItmDelivIncompletionSts,
SDI._SalesDocument._OvrlItmDelivIncompletionSts AS _OvrlItmDelivIncompletionSts,
SDI.SDProcessStatus AS SDProcessStatus,
SDI._SDProcessStatus AS _SDProcessStatus,
SDI.DeliveryConfirmationStatus AS DeliveryConfirmationStatus,
SDI._DeliveryConfirmationStatus AS _DeliveryConfirmationStatus,
SDI.PurchaseConfirmationStatus AS PurchaseConfirmationStatus,
SDI._PurchaseConfirmationStatus AS _PurchaseConfirmationStatus,
SDI.TotalDeliveryStatus AS TotalDeliveryStatus,
SDI._TotalDeliveryStatus AS _TotalDeliveryStatus,
SDI.DeliveryStatus AS DeliveryStatus,
SDI._DeliveryStatus AS _DeliveryStatus,
SDI.DeliveryBlockStatus AS DeliveryBlockStatus,
SDI._DeliveryBlockStatus AS _DeliveryBlockStatus,
SDI.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
SDI._OrderRelatedBillingStatus AS _OrderRelatedBillingStatus,
SDI.BillingBlockStatus AS BillingBlockStatus,
SDI._BillingBlockStatus AS _BillingBlockStatus,
SDI.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
SDI._ItemGeneralIncompletionStatus AS _ItemGeneralIncompletionStatus,
SDI.ItemBillingIncompletionStatus AS ItemBillingIncompletionStatus,
SDI._ItemBillingIncompletionStatus AS _ItemBillingIncompletionStatus,
SDI.PricingIncompletionStatus AS PricingIncompletionStatus,
SDI._PricingIncompletionStatus AS _PricingIncompletionStatus,
SDI.ItemDeliveryIncompletionStatus AS ItemDeliveryIncompletionStatus,
SDI._ItemDelivIncompletionSts AS _ItemDelivIncompletionSts,
SDI.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
SDI._SDDocumentRejectionStatus AS _SDDocumentRejectionStatus,
SDI.TotalSDDocReferenceStatus AS TotalSDDocReferenceStatus,
SDI._TotalSDDocReferenceStatus AS _TotalSDDocReferenceStatus,
SDI.SDDocReferenceStatus AS SDDocReferenceStatus
FROM I_SalesDocumentItem AS SDI
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA