I_SalesContractItemAnalytics
Sales Contract Item Analytics
I_SalesContractItemAnalytics is a Composite CDS View that provides data about "Sales Contract Item Analytics" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItem) and exposes 323 fields with key fields SalesDocument, SalesDocumentItem. It has 5 associations to related views.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_SalesDocumentItem | SDI | from |
Associations (5)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_Product | _Product | $projection.Product = _Product.Product |
| [0..1] | I_ProductGroup_2 | _ProductGroup | $projection.ProductGroup = _ProductGroup.ProductGroup |
| [0..1] | I_Currency | _StatisticsCurrency | $projection.StatisticsCurrency = _StatisticsCurrency.Currency |
| [0..1] | I_CostCenter | _CostCenter | $projection.costcenter = _CostCenter.CostCenter and $projection.ControllingArea = _CostCenter.ControllingArea and _CostCenter.ValidityEndDate >= $projection.salesdocumentdate and _CostCenter.ValidityStartDate <= $projection.salesdocumentdate |
| [0..1] | E_SalesDocumentItemBasic | _Extension | $projection.SalesDocument = _Extension.SalesDocument and $projection.SalesDocumentItem = _Extension.SalesDocumentItem |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| EndUserText.label | Sales Contract Item Analytics | view | |
| VDM.viewType | #COMPOSITE | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AbapCatalog.sqlViewName | ISDSLSCONTITMANA | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (323)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | SalesDocument | I_SalesDocumentItem | SalesDocument | SD Document |
| _SalesDocument | I_SalesDocumentItem | _SalesDocument | ||
| KEY | SalesDocumentItem | I_SalesDocumentItem | SalesDocumentItem | Sales Document Item |
| SalesDocumentItemUUID | I_SalesDocumentItem | SalesDocumentItemUUID | TS handle | |
| _ScheduleLine | I_SalesDocumentItem | _ScheduleLine | ||
| SoldToParty | I_SalesDocumentItem | SoldToParty | Sold-to Party | |
| _SoldToParty | I_SalesDocumentItem | _SoldToParty | ||
| ShipToParty | I_SalesDocumentItem | ShipToParty | Ship-To Party (obsolete) | |
| _ShipToParty | I_SalesDocumentItem | _ShipToParty | ||
| 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 | |
| IsReturnsItem | I_SalesDocumentItem | IsReturnsItem | Returns Item | |
| CompletionRule | I_SalesDocumentItem | CompletionRule | Completion Rule | |
| 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 | ||
| Product | ||||
| _Product | _Product | |||
| OriginallyRequestedMaterial | I_SalesDocumentItem | OriginallyRequestedMaterial | MaterialEntered | |
| _OriginallyRequestedMaterial | I_SalesDocumentItem | _OriginallyRequestedMaterial | ||
| MaterialByCustomer | I_SalesDocumentItem | MaterialByCustomer | Customer Mat. | |
| InternationalArticleNumber | I_SalesDocumentItem | InternationalArticleNumber | EAN/UPC | |
| ProductCatalog | I_SalesDocumentItem | ProductCatalog | Catalog | |
| MaterialSubstitutionReason | I_SalesDocumentItem | MaterialSubstitutionReason | Reason | |
| _MaterialSubstitutionReason | I_SalesDocumentItem | _MaterialSubstitutionReason | ||
| MaterialGroup | I_SalesDocumentItem | MaterialGroup | Product Group | |
| _MaterialGroup | I_SalesDocumentItem | _MaterialGroup | ||
| ProductGroup | ||||
| _ProductGroup | _ProductGroup | |||
| AdditionalMaterialGroup1 | I_SalesDocumentItem | AdditionalMaterialGroup1 | MaterialGroup 1 | |
| _AdditionalMaterialGroup1 | I_SalesDocumentItem | _AdditionalMaterialGroup1 | ||
| AdditionalMaterialGroup2 | I_SalesDocumentItem | AdditionalMaterialGroup2 | MaterialGroup 2 | |
| _AdditionalMaterialGroup2 | I_SalesDocumentItem | _AdditionalMaterialGroup2 | ||
| AdditionalMaterialGroup3 | I_SalesDocumentItem | AdditionalMaterialGroup3 | MaterialGroup 3 | |
| _AdditionalMaterialGroup3 | I_SalesDocumentItem | _AdditionalMaterialGroup3 | ||
| AdditionalMaterialGroup4 | I_SalesDocumentItem | AdditionalMaterialGroup4 | MaterialGroup 4 | |
| _AdditionalMaterialGroup4 | I_SalesDocumentItem | _AdditionalMaterialGroup4 | ||
| AdditionalMaterialGroup5 | I_SalesDocumentItem | AdditionalMaterialGroup5 | MaterialGroup 5 | |
| _AdditionalMaterialGroup5 | I_SalesDocumentItem | _AdditionalMaterialGroup5 | ||
| Plant | I_SalesDocumentItem | Plant | Valuation Area | |
| _Plant | I_SalesDocumentItem | _Plant | ||
| StorageLocation | I_SalesDocumentItem | StorageLocation | StorageLocation | |
| _StorageLocation | I_SalesDocumentItem | _StorageLocation | ||
| BillOfMaterial | ||||
| MainItemPricingRefProduct | I_SalesDocumentItem | MainItemPricingRefProduct | ||
| PropagatePrftbltySgmt2BOM | ||||
| CostDeterminationIsRequired | ||||
| SDDocumentReason | I_SalesDocumentItem | SDDocumentReason | Order Reason | |
| _SDDocumentReason | I_SalesDocumentItem | _SDDocumentReason | ||
| SalesDocumentItemText | I_SalesDocumentItem | SalesDocumentItemText | Item Descr. | |
| SalesDocumentDate | ||||
| AdditionalCustomerGroup1 | I_SalesDocumentItem | AdditionalCustomerGroup1 | Customer Grp 1 | |
| _AdditionalCustomerGroup1 | I_SalesDocumentItem | _AdditionalCustomerGroup1 | ||
| AdditionalCustomerGroup2 | I_SalesDocumentItem | AdditionalCustomerGroup2 | Customer Grp 2 | |
| _AdditionalCustomerGroup2 | I_SalesDocumentItem | _AdditionalCustomerGroup2 | ||
| AdditionalCustomerGroup3 | I_SalesDocumentItem | AdditionalCustomerGroup3 | Customer Grp 3 | |
| _AdditionalCustomerGroup3 | I_SalesDocumentItem | _AdditionalCustomerGroup3 | ||
| AdditionalCustomerGroup4 | I_SalesDocumentItem | AdditionalCustomerGroup4 | Customer Grp 4 | |
| _AdditionalCustomerGroup4 | I_SalesDocumentItem | _AdditionalCustomerGroup4 | ||
| AdditionalCustomerGroup5 | I_SalesDocumentItem | AdditionalCustomerGroup5 | Customer Grp 5 | |
| _AdditionalCustomerGroup5 | I_SalesDocumentItem | _AdditionalCustomerGroup5 | ||
| CreditControlArea | ||||
| _CreditControlArea | ||||
| CustomerPurchaseOrderType | ||||
| _CustomerPurchaseOrderType | ||||
| CustomerPurchaseOrderDate | I_SalesDocumentItem | CustomerPurchaseOrderDate | Purchase Order Date | |
| PurchaseOrderByCustomer | I_SalesDocumentItem | PurchaseOrderByCustomer | Purchase Order Number | |
| SalesPromotion | I_SalesDocumentItem | SalesPromotion | Promotion | |
| RetailPromotion | I_SalesDocumentItem | RetailPromotion | Promotion | |
| CustomerGroup | I_SalesDocumentItem | CustomerGroup | Customer Group | |
| _CustomerGroup | I_SalesDocumentItem | _CustomerGroup | ||
| SalesDocumentRjcnReason | I_SalesDocumentItem | SalesDocumentRjcnReason | RejectionReason | |
| _SalesDocumentRjcnReason | I_SalesDocumentItem | _SalesDocumentRjcnReason | ||
| OrderQuantityUnit | I_SalesDocumentItem | OrderQuantityUnit | Sales Unit | |
| _OrderQuantityUnit | I_SalesDocumentItem | _OrderQuantityUnit | ||
| OrderQuantity | I_SalesDocumentItem | OrderQuantity | Quantity | |
| ConfdDelivQtyInOrderQtyUnit | I_SalesDocumentItem | ConfdDelivQtyInOrderQtyUnit | Confd Quantity | |
| TargetDelivQtyInOrderQtyUnit | I_SalesDocumentItem | TargetDelivQtyInOrderQtyUnit | Subitem Qty | |
| BaseUnit | I_SalesDocumentItem | BaseUnit | Unit of Measure | |
| _BaseUnit | I_SalesDocumentItem | _BaseUnit | ||
| RequestedQuantityInBaseUnit | I_SalesDocumentItem | RequestedQuantityInBaseUnit | Requested Qty | |
| ConfdDeliveryQtyInBaseUnit | I_SalesDocumentItem | ConfdDeliveryQtyInBaseUnit | CumltvConfdQty | |
| OrderToBaseQuantityDnmntr | I_SalesDocumentItem | OrderToBaseQuantityDnmntr | Denominator | |
| OrderToBaseQuantityNmrtr | I_SalesDocumentItem | OrderToBaseQuantityNmrtr | Numerator | |
| TargetQuantityUnit | I_SalesDocumentItem | TargetQuantityUnit | Target Qty UoM | |
| _TargetQuantityUnit | I_SalesDocumentItem | _TargetQuantityUnit | ||
| TargetQuantity | I_SalesDocumentItem | TargetQuantity | Target Quantity | |
| TargetToBaseQuantityDnmntr | I_SalesDocumentItem | TargetToBaseQuantityDnmntr | Convers.Factor | |
| TargetToBaseQuantityNmrtr | I_SalesDocumentItem | TargetToBaseQuantityNmrtr | Convers.Factor | |
| CommittedDelivQtyInOrdQtyUnit | I_SalesDocumentItem | CommittedDelivQtyInOrdQtyUnit | ||
| CommittedDeliveryDate | I_SalesDocumentItem | CommittedDeliveryDate | ||
| CommittedDelivCreationDate | I_SalesDocumentItem | CommittedDelivCreationDate | ||
| 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 | |
| ReturnReason | I_SalesDocumentItem | ReturnReason | Return Reason | |
| _ReturnReason | I_SalesDocumentItem | _ReturnReason | ||
| ReturnsRefundExtent | I_SalesDocumentItem | ReturnsRefundExtent | Refund Code | |
| _ReturnsRefundExtent | I_SalesDocumentItem | _ReturnsRefundExtent | ||
| RetsMgmtProcessingBlock | I_SalesDocumentItem | RetsMgmtProcessingBlock | Approval | |
| QuantityIsFixed | I_SalesDocumentItem | QuantityIsFixed | Qty. is fixed | |
| OutlineAgreementTargetAmount | I_SalesDocumentItem | OutlineAgreementTargetAmount | Target Value | |
| AgrmtValdtyStartDate | ||||
| AgrmtValdtyEndDate | ||||
| SalesContractCanclnParty | I_SalesDocumentItem | SalesContractCanclnParty | ||
| _SalesContractCanclnParty | I_SalesDocumentItem | _SalesContractCanclnParty | ||
| SalesContractCanclnReason | I_SalesDocumentItem | SalesContractCanclnReason | ||
| _SalesContractCanclnReason | I_SalesDocumentItem | _SalesContractCanclnReason | ||
| SalesContractFollowUpAction | ||||
| _SalesContractFollowUpAction | ||||
| ContractPartnerCanclnDocDate | I_SalesDocumentItem | ContractPartnerCanclnDocDate | ||
| PricingDate | I_SalesDocumentItem | PricingDate | Pricing Date | |
| TransactionCurrency | I_SalesDocumentItem | TransactionCurrency | Transaction Currency | |
| _TransactionCurrency | I_SalesDocumentItem | _TransactionCurrency | ||
| StatisticsCurrency | ||||
| TotalNetAmount | ||||
| 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 | |
| RequestedDeliveryDate | I_SalesDocumentItem | RequestedDeliveryDate | Requested Delivery Date | |
| ShippingCondition | I_SalesDocumentItem | ShippingCondition | Shipping Conditions | |
| _ShippingCondition | I_SalesDocumentItem | _ShippingCondition | ||
| CompleteDeliveryIsDefined | ||||
| DeliveryBlockReason | ||||
| _DeliveryBlockReason | ||||
| ShippingPoint | I_SalesDocumentItem | ShippingPoint | Shipping Point | |
| _ShippingPoint | I_SalesDocumentItem | _ShippingPoint | ||
| ShippingType | I_SalesDocumentItem | ShippingType | Shipping Type | |
| _ShippingType | I_SalesDocumentItem | _ShippingType | ||
| InventorySpecialStockType | I_SalesDocumentItem | InventorySpecialStockType | Special Stock Type | |
| DeliveryPriority | I_SalesDocumentItem | DeliveryPriority | Delivery Prior. | |
| _DeliveryPriority | I_SalesDocumentItem | _DeliveryPriority | ||
| Route | I_SalesDocumentItem | Route | Vehicle route | |
| _Route | I_SalesDocumentItem | _Route | ||
| DeliveryDateQuantityIsFixed | I_SalesDocumentItem | DeliveryDateQuantityIsFixed | Fixed Date | |
| PartialDeliveryIsAllowed | I_SalesDocumentItem | PartialDeliveryIsAllowed | Partial Deliv. | |
| _PartialDeliveryItem | I_SalesDocumentItem | _PartialDeliveryItem | ||
| MaxNmbrOfPartialDelivery | I_SalesDocumentItem | MaxNmbrOfPartialDelivery | Max.Part.Deliv. | |
| UnlimitedOverdeliveryIsAllowed | I_SalesDocumentItem | UnlimitedOverdeliveryIsAllowed | Unlimited Tol. | |
| OverdelivTolrtdLmtRatioInPct | I_SalesDocumentItem | OverdelivTolrtdLmtRatioInPct | Overdeliv. Tol. | |
| UnderdelivTolrtdLmtRatioInPct | I_SalesDocumentItem | UnderdelivTolrtdLmtRatioInPct | Underdel. Tol. | |
| MinDeliveryQtyInBaseUnit | I_SalesDocumentItem | MinDeliveryQtyInBaseUnit | Min. Dely Qty | |
| OpenDeliveryLeadingUnitCode | I_SalesDocumentItem | OpenDeliveryLeadingUnitCode | Units meas. use | |
| ItemIsDeliveryRelevant | I_SalesDocumentItem | ItemIsDeliveryRelevant | Item rel.f.dlv. | |
| IncotermsClassification | I_SalesDocumentItem | IncotermsClassification | Incoterms | |
| _IncotermsClassification | I_SalesDocumentItem | _IncotermsClassification | ||
| IncotermsTransferLocation | I_SalesDocumentItem | IncotermsTransferLocation | Incoterms 2 | |
| IncotermsLocation1 | I_SalesDocumentItem | IncotermsLocation1 | Inco. Location1 | |
| IncotermsLocation2 | I_SalesDocumentItem | IncotermsLocation2 | Inco. Location2 | |
| IncotermsVersion | I_SalesDocumentItem | IncotermsVersion | Inco. Version | |
| _IncotermsVersion | I_SalesDocumentItem | _IncotermsVersion | ||
| BillingCompanyCode | ||||
| _BillingCompanyCode | ||||
| HeaderBillingBlockReason | ||||
| _HeaderBillingBlockReason | ||||
| ItemIsBillingRelevant | I_SalesDocumentItem | ItemIsBillingRelevant | Relev.for Bill. | |
| _ItemIsBillingRelevant | I_SalesDocumentItem | _ItemIsBillingRelevant | ||
| ItemBillingBlockReason | I_SalesDocumentItem | ItemBillingBlockReason | Billing Block | |
| _ItemBillingBlockReason | I_SalesDocumentItem | _ItemBillingBlockReason | ||
| BillingDocumentDate | I_SalesDocumentItem | BillingDocumentDate | Billing Date | |
| CustomerPaymentTerms | I_SalesDocumentItem | CustomerPaymentTerms | Pyt Terms | |
| _CustomerPaymentTerms | I_SalesDocumentItem | _CustomerPaymentTerms | ||
| PaymentMethod | I_SalesDocumentItem | PaymentMethod | Pymt Meth. | |
| FixedValueDate | I_SalesDocumentItem | FixedValueDate | Fixed Val. Date | |
| AdditionalValueDays | I_SalesDocumentItem | AdditionalValueDays | Add. Value Days | |
| CostCenterBusinessArea | ||||
| _CostCenterBusinessArea | ||||
| CostCenter | ||||
| _CostCenter | _CostCenter | |||
| ControllingArea | I_SalesDocumentItem | ControllingArea | Controlling Area | |
| _ControllingArea | I_SalesDocumentItem | _ControllingArea | ||
| FiscalYear | I_SalesDocumentItem | FiscalYear | G/L Fiscal Year | |
| FiscalPeriod | I_SalesDocumentItem | FiscalPeriod | Tax period | |
| CustomerAccountAssignmentGroup | I_SalesDocumentItem | CustomerAccountAssignmentGroup | AccAssmtGrpCust | |
| _CustomerAccountAssgmtGroup | I_SalesDocumentItem | _CustomerAccountAssgmtGroup | ||
| BusinessArea | I_SalesDocumentItem | BusinessArea | Business Area | |
| _BusinessArea | I_SalesDocumentItem | _BusinessArea | ||
| ProfitCenter | I_SalesDocumentItem | ProfitCenter | Profit Center | |
| _ProfitCenter | I_SalesDocumentItem | _ProfitCenter | ||
| WBSElement | I_SalesDocumentItem | WBSElement | WBS Internal ID | |
| WBSElementInternalID | I_SalesDocumentItem | WBSElementInternalID | WBS Internal ID | |
| _WBSElementBasicData_2 | I_SalesDocumentItem | _WBSElementBasicData_2 | ||
| ControllingObject | I_SalesDocumentItem | ControllingObject | Object number | |
| ProfitabilitySegment | I_SalesDocumentItem | ProfitabilitySegment | Profitability Segment | |
| ProfitabilitySegment_2 | 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 | |
| ValueContract | I_SalesDocumentItem | ValueContract | Value Contract No. | |
| ValueContractItem | I_SalesDocumentItem | ValueContractItem | Val. Cont.Item | |
| DeliveryGroup | I_SalesDocumentItem | DeliveryGroup | Delivery Group | |
| 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 | Purg Conf. Sts | |
| _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 I_SalesContractItemAnalytics.
-- 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_SalesContractItemAnalytics AS
SELECT
SDI.SalesDocument AS SalesDocument,
SDI._SalesDocument AS _SalesDocument,
SDI.SalesDocumentItem AS SalesDocumentItem,
SDI.SalesDocumentItemUUID AS SalesDocumentItemUUID,
SDI._ScheduleLine AS _ScheduleLine,
SDI.SoldToParty AS SoldToParty,
SDI._SoldToParty AS _SoldToParty,
SDI.ShipToParty AS ShipToParty,
SDI._ShipToParty AS _ShipToParty,
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.IsReturnsItem AS IsReturnsItem,
SDI.CompletionRule AS CompletionRule,
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,
cast( SDI.Material as productnumber preserving type ) AS Product,
SDI.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
SDI._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
SDI.MaterialByCustomer AS MaterialByCustomer,
SDI.InternationalArticleNumber AS InternationalArticleNumber,
SDI.ProductCatalog AS ProductCatalog,
SDI.MaterialSubstitutionReason AS MaterialSubstitutionReason,
SDI._MaterialSubstitutionReason AS _MaterialSubstitutionReason,
SDI.MaterialGroup AS MaterialGroup,
SDI._MaterialGroup AS _MaterialGroup,
cast (SDI.MaterialGroup as productgroup preserving type) AS ProductGroup,
SDI.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
SDI._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
SDI.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
SDI._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
SDI.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
SDI._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
SDI.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
SDI._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
SDI.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
SDI._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
SDI.Plant AS Plant,
SDI._Plant AS _Plant,
SDI.StorageLocation AS StorageLocation,
SDI._StorageLocation AS _StorageLocation,
cast (SDI.BillOfMaterial as bill_of_matrl) AS BillOfMaterial,
SDI.MainItemPricingRefProduct AS MainItemPricingRefProduct,
SDI._ItemCategory.PropagatePrftbltySgmt2BOM AS PropagatePrftbltySgmt2BOM,
SDI._ItemCategory.CostDeterminationIsRequired AS CostDeterminationIsRequired,
SDI.SDDocumentReason AS SDDocumentReason,
SDI._SDDocumentReason AS _SDDocumentReason,
SDI.SalesDocumentItemText AS SalesDocumentItemText,
SDI._SalesDocument.SalesDocumentDate AS SalesDocumentDate,
SDI.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
SDI._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
SDI.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
SDI._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
SDI.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
SDI._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
SDI.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
SDI._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
SDI.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
SDI._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
SDI._SalesDocument.CreditControlArea AS CreditControlArea,
SDI._SalesDocument._CreditControlArea AS _CreditControlArea,
SDI._SalesDocument.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
SDI._SalesDocument._CustomerPurchaseOrderType AS _CustomerPurchaseOrderType,
SDI.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
SDI.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
SDI.SalesPromotion AS SalesPromotion,
SDI.RetailPromotion AS RetailPromotion,
SDI.CustomerGroup AS CustomerGroup,
SDI._CustomerGroup AS _CustomerGroup,
SDI.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
SDI._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
SDI.OrderQuantityUnit AS OrderQuantityUnit,
SDI._OrderQuantityUnit AS _OrderQuantityUnit,
SDI.OrderQuantity AS OrderQuantity,
SDI.ConfdDelivQtyInOrderQtyUnit AS ConfdDelivQtyInOrderQtyUnit,
SDI.TargetDelivQtyInOrderQtyUnit AS TargetDelivQtyInOrderQtyUnit,
SDI.BaseUnit AS BaseUnit,
SDI._BaseUnit AS _BaseUnit,
SDI.RequestedQuantityInBaseUnit AS RequestedQuantityInBaseUnit,
SDI.ConfdDeliveryQtyInBaseUnit AS ConfdDeliveryQtyInBaseUnit,
SDI.OrderToBaseQuantityDnmntr AS OrderToBaseQuantityDnmntr,
SDI.OrderToBaseQuantityNmrtr AS OrderToBaseQuantityNmrtr,
SDI.TargetQuantityUnit AS TargetQuantityUnit,
SDI._TargetQuantityUnit AS _TargetQuantityUnit,
SDI.TargetQuantity AS TargetQuantity,
SDI.TargetToBaseQuantityDnmntr AS TargetToBaseQuantityDnmntr,
SDI.TargetToBaseQuantityNmrtr AS TargetToBaseQuantityNmrtr,
SDI.CommittedDelivQtyInOrdQtyUnit AS CommittedDelivQtyInOrdQtyUnit,
SDI.CommittedDeliveryDate AS CommittedDeliveryDate,
SDI.CommittedDelivCreationDate AS CommittedDelivCreationDate,
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.ReturnReason AS ReturnReason,
SDI._ReturnReason AS _ReturnReason,
SDI.ReturnsRefundExtent AS ReturnsRefundExtent,
SDI._ReturnsRefundExtent AS _ReturnsRefundExtent,
SDI.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
SDI.QuantityIsFixed AS QuantityIsFixed,
SDI.OutlineAgreementTargetAmount AS OutlineAgreementTargetAmount,
SDI._SalesDocument.AgrmtValdtyStartDate AS AgrmtValdtyStartDate,
SDI._SalesDocument.AgrmtValdtyEndDate AS AgrmtValdtyEndDate,
SDI.SalesContractCanclnParty AS SalesContractCanclnParty,
SDI._SalesContractCanclnParty AS _SalesContractCanclnParty,
SDI.SalesContractCanclnReason AS SalesContractCanclnReason,
SDI._SalesContractCanclnReason AS _SalesContractCanclnReason,
SDI._SalesDocument.SalesContractFollowUpAction AS SalesContractFollowUpAction,
SDI._SalesDocument._SalesContractFollowUpAction AS _SalesContractFollowUpAction,
SDI.ContractPartnerCanclnDocDate AS ContractPartnerCanclnDocDate,
SDI.PricingDate AS PricingDate,
SDI.TransactionCurrency AS TransactionCurrency,
SDI._TransactionCurrency AS _TransactionCurrency,
SDI._SalesOrganization.SalesOrganizationCurrency AS StatisticsCurrency,
cast( SDI._SalesDocument.TotalNetAmount as slsord_totalnetamount ) AS TotalNetAmount,
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.RequestedDeliveryDate AS RequestedDeliveryDate,
SDI.ShippingCondition AS ShippingCondition,
SDI._ShippingCondition AS _ShippingCondition,
SDI._SalesDocument.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
SDI._SalesDocument.DeliveryBlockReason AS DeliveryBlockReason,
SDI._SalesDocument._DeliveryBlockReason AS _DeliveryBlockReason,
SDI.ShippingPoint AS ShippingPoint,
SDI._ShippingPoint AS _ShippingPoint,
SDI.ShippingType AS ShippingType,
SDI._ShippingType AS _ShippingType,
SDI.InventorySpecialStockType AS InventorySpecialStockType,
SDI.DeliveryPriority AS DeliveryPriority,
SDI._DeliveryPriority AS _DeliveryPriority,
SDI.Route AS Route,
SDI._Route AS _Route,
SDI.DeliveryDateQuantityIsFixed AS DeliveryDateQuantityIsFixed,
SDI.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
SDI._PartialDeliveryItem AS _PartialDeliveryItem,
SDI.MaxNmbrOfPartialDelivery AS MaxNmbrOfPartialDelivery,
SDI.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
SDI.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
SDI.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
SDI.MinDeliveryQtyInBaseUnit AS MinDeliveryQtyInBaseUnit,
SDI.OpenDeliveryLeadingUnitCode AS OpenDeliveryLeadingUnitCode,
SDI.ItemIsDeliveryRelevant AS ItemIsDeliveryRelevant,
SDI.IncotermsClassification AS IncotermsClassification,
SDI._IncotermsClassification AS _IncotermsClassification,
SDI.IncotermsTransferLocation AS IncotermsTransferLocation,
SDI.IncotermsLocation1 AS IncotermsLocation1,
SDI.IncotermsLocation2 AS IncotermsLocation2,
SDI.IncotermsVersion AS IncotermsVersion,
SDI._IncotermsVersion AS _IncotermsVersion,
SDI._SalesDocument.BillingCompanyCode AS BillingCompanyCode,
SDI._SalesDocument._BillingCompanyCode AS _BillingCompanyCode,
SDI._SalesDocument.HeaderBillingBlockReason AS HeaderBillingBlockReason,
SDI._SalesDocument._HeaderBillingBlockReason AS _HeaderBillingBlockReason,
SDI.ItemIsBillingRelevant AS ItemIsBillingRelevant,
SDI._ItemIsBillingRelevant AS _ItemIsBillingRelevant,
SDI.ItemBillingBlockReason AS ItemBillingBlockReason,
SDI._ItemBillingBlockReason AS _ItemBillingBlockReason,
SDI.BillingDocumentDate AS BillingDocumentDate,
SDI.CustomerPaymentTerms AS CustomerPaymentTerms,
SDI._CustomerPaymentTerms AS _CustomerPaymentTerms,
SDI.PaymentMethod AS PaymentMethod,
SDI.FixedValueDate AS FixedValueDate,
SDI.AdditionalValueDays AS AdditionalValueDays,
SDI._SalesDocument.CostCenterBusinessArea AS CostCenterBusinessArea,
SDI._SalesDocument._CostCenterBusinessArea AS _CostCenterBusinessArea,
SDI._SalesDocument.CostCenter AS CostCenter,
SDI.ControllingArea AS ControllingArea,
SDI._ControllingArea AS _ControllingArea,
SDI.FiscalYear AS FiscalYear,
SDI.FiscalPeriod AS FiscalPeriod,
SDI.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
SDI._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup,
SDI.BusinessArea AS BusinessArea,
SDI._BusinessArea AS _BusinessArea,
SDI.ProfitCenter AS ProfitCenter,
SDI._ProfitCenter AS _ProfitCenter,
SDI.WBSElement AS WBSElement,
SDI.WBSElementInternalID AS WBSElementInternalID,
SDI._WBSElementBasicData_2 AS _WBSElementBasicData_2,
SDI.ControllingObject AS ControllingObject,
SDI.ProfitabilitySegment AS ProfitabilitySegment,
SDI.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
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.ValueContract AS ValueContract,
SDI.ValueContractItem AS ValueContractItem,
SDI.DeliveryGroup AS DeliveryGroup,
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
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup -- association [0..1]
LEFT OUTER JOIN I_Currency AS _StatisticsCurrency ON StatisticsCurrency = _StatisticsCurrency.Currency -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON costcenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND _CostCenter.ValidityEndDate >= salesdocumentdate AND _CostCenter.ValidityStartDate <= salesdocumentdate -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesDocument = _Extension.SalesDocument AND SalesDocumentItem = _Extension.SalesDocumentItem -- association [0..1]
;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