P_SLSDOCITMBSCDATA

DDL: P_SLSDOCITMBSCDATA SQL: PSLSDOCITMBSC Type: view COMPOSITE Package: VDM_SD_ANALYTICS

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)

SourceAliasJoin Type
I_SalesDocumentItem SDI from

Annotations (10)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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
;