I_SALESDOCUMENTITEM

CDS View
317 Fields 149 CDS Views

Sales Document Item

I_SALESDOCUMENTITEM is a CDS View in S/4HANA. Sales Document Item. It contains 317 fields. 149 CDS views read from this table.

CDS Views using this table (149)

ViewTypeJoinVDMDescription
A_SlsDocItmVarConfign view_entity from CONSUMPTION Sales Item Variant Configuration Data
C_BSOrdItmProcFlwSalesOrder view from CONSUMPTION Sales Order Item Attrib for BSOrd Prgrs
C_CustExpdPriceCondition view inner CONSUMPTION Sales Doc w. Cust-Expd Price Prcg Elmnt
C_DuplicateSalesDocumentItem view from CONSUMPTION Item of Duplicate Sales Document
C_EBRRSalesOrderMonitorItem view from CONSUMPTION EBRR Sales Order Monitor Item
C_ESJIQuotationItemQuery view from CONSUMPTION Quotation Item
C_ESJISalesOrderItemQuery view from CONSUMPTION Sales Order Item
C_EvtBsdRevnRecgnSalesOrdWlItm view left_outer CONSUMPTION Worklist Rev. Rec. Issues - Sales Orders
C_IntactvABOPAltvBsdConfHN view_entity from CONSUMPTION Hierarchy for ABC
C_IntactvABOPBillOfMaterialHN view_entity inner CONSUMPTION Hierarchy Node For BOM
C_MaintCnsmpnPostgSlsDocItmVH view_entity from CONSUMPTION MaintConsumptionPostingSalesDocumentItem
C_MassChangeSalesContractItem view from CONSUMPTION Mass Change of Sales Contract Item
C_MassChangeSalesDocumentItem view from CONSUMPTION Mass Change of Sales Document Item
C_MassChangeSalesOrderItem view from CONSUMPTION Mass Change of Sales Order Item
C_MassChangeSalesQuotationItem view from CONSUMPTION Mass Change of Sales Quotation Item
C_MassChangeSlsSchedgAgrmtItem view from CONSUMPTION Mass Change of Sls Scheduling Agreement Item
C_MassChgCreditMemoReqItem view from CONSUMPTION Mass Change of Credit Memo Request Item
C_MassChgCustomerReturnItem view from CONSUMPTION Mass Change of Customer Return Item
C_MassChgDebitMemoReqItem view from CONSUMPTION Mass Change of Debit Memo Request Item
C_MassChgSalesDocumentItemWl view from CONSUMPTION Item attributes search for Mass Change
C_MassChgSlsOrdWthoutChrgItem view from CONSUMPTION Mass Change of Sls Ord Without Charge Item
C_PL_SAFTDownPaytCnsldtnItem view inner CONSUMPTION SAF-T PL: Down Payment Consolidation Item
C_RetsRefDocItemAttribute view_entity from CONSUMPTION Returns Document Item Attribute Search
C_RetsRefSlsOrdWthoutChrgItem view_entity from CONSUMPTION Returns Refer Sls Order Without Chrg Itm
C_ReturnedSalesOrderItems view from CONSUMPTION Customer Returns
C_ReturnRefDocItem_F1708 view from CONSUMPTION Return Reference Document Item
C_ReturnsReferenceDocumentItem view from CONSUMPTION Return Reference Document Item
C_SalesDocItemDownPayt view from CONSUMPTION Sales Document Down payment item
C_SalesDocItmPrcgElmntDEX view inner CONSUMPTION Data Extraction for Sales Document Item Pricing Element
C_SalesDocItmPrcgElmntDEX_1 view inner CONSUMPTION Data Extraction for Sales Doc Item Pricing Elements
C_SalesDocumentItemDEX view from CONSUMPTION Data Extraction for Sales Document Item
C_SalesDocumentItemDEX_1 view from CONSUMPTION Data Extraction for Sales Document Item
C_SalesDocumentItemWl view from CONSUMPTION View for item attribute search in sales document worklists
C_SalesDocumentSchedLineDEX view inner CONSUMPTION Data Extraction for Sales Document Schedule Lines
C_SalesDocumentSchedLineDEX_1 view inner CONSUMPTION Data Extraction for Sales Document Schedule Lines
C_SalesDocWithCustExpdPrice view from CONSUMPTION Sales Doc. w. Customer-Expected Price
C_SlsDocFlfmtSlsDocItem view from CONSUMPTION Sales Doc Fulfillment: Sales Doc Item
C_SlsDocItemBillingBlkd view from CONSUMPTION Sales Doc Item Billing Blocked
C_SlsDocItemDeliveryBlkd view from CONSUMPTION Sales Doc Item Delivery Blocked
C_SlsDocItemIncomplete view from CONSUMPTION Sales Doc Item Incomplete Data
C_SlsDocItemOverdueDeliv view from CONSUMPTION Sales Doc Item Delivery Issue
C_SlsDocItemPrdtdDelivDelay view from CONSUMPTION Predicted Delivery Delay
C_SlsDocItemTradeCmplncIssue view from CONSUMPTION Sales Doc Item Trade Compliance Issue
C_SlsDocItemUnconfdQty view from CONSUMPTION Sales Doc Item With Unconf. Quantity
FAC_AUDIT_Z3_SALESHDRITM view from Sales Document Header & Items
finoc_hard_dependency_soi view_entity inner Orgl Change: SOI Hard Dependencies
FINOC_RT_SOI_FILL view inner Orgl Change: Fill Runtime for Sales Doc
FINOC_RT_SOI_OBJ_STATUS view from Orgl Chg: SDocItms with object status
I_ACMSalesOrderItem view from COMPOSITE Acm Sales Order Item
I_ARunAnlytsSalesReturns view from COMPOSITE Return Sales Order
I_ARunAnlytsSlsOrdRejection view from COMPOSITE Sales Order Rejection
I_BillingPlanDueDateAnalytics view from COMPOSITE Billing Plan Due Date Analytics
I_CFinSalesDocumentItem view union_all COMPOSITE Central Finance Sales Document: Item
I_CmplRqVersMntrgListSlsFact view from COMPOSITE Fact Monitoring List Sales Analytics
I_CreditMemoRequestItem view from BASIC Credit Memo Request Item
I_CustomerReturnItem view from BASIC Returns Order Item
I_CustomerReturnRateAnalytics view from COMPOSITE Customer Return Rate Analytics
I_DebitMemoRequestItem view from BASIC Debit Memo Request Item
I_DeliveryDocItemAnalytics view inner COMPOSITE Delivery Document Item Analytics
I_DeliveryDocumentItemAmount view inner COMPOSITE Delivery Document Item Amount
I_DigitalVehicleQuotationItem view_entity from COMPOSITE Quotation
I_DigitalVehicleSalesOrderItem view_entity from COMPOSITE Vehicle Sales Order
I_ExcessRqmtQtyAcctAssgdItm view from COMPOSITE Excess Requirement Quantity per Acct Assigned Sales Doc Item
I_ExcessRqmtQtySDDocItm view from COMPOSITE Excess Requirement Quantity per Sales Document Item
I_ExcessRqmtQtySDMainDocItm view from COMPOSITE Excess Requirement Quantity per Main MSO Item
I_ExcessRqmtQtySlsContrItm view from COMPOSITE Excess Requirement Quantity per Sales Contract Item
I_NonFerrousMatSlsDocItemCalc view_entity inner COMPOSITE NFM Sales Document Calculation
I_Order2CashSalesOrderItem view from BASIC Sales Order Item
I_PL_SAFTGetDownPayAll view_entity inner COMPOSITE SAFT PL FA DonwPaymentAll
I_PL_SAFTGetDownPaymentHeader view_entity inner COMPOSITE SAF T PL Down Payment Header
I_ProdCmplncLicRlvtSalesDocs view from COMPOSITE License Relevant Sales Document Items
I_PurchaseOrderItemPurgIssue view inner COMPOSITE SOFM Purchase Order Item Purchasing Issue
I_SalesContractItem view from BASIC Sales Contract Item
I_SalesContractItemAnalytics view from COMPOSITE Sales Contract Item Analytics
I_SalesDocItemBillingPlan view_entity inner COMPOSITE Billing Plan of Sales Document Item
I_SalesDocItemBillingPlanItem view_entity inner COMPOSITE Billing Plan Item of Sales Document Item
I_SalesDocumentItemAnalytics view from COMPOSITE Sales Document Item Core Analytics
I_SalesDocumentItemStdVH view from COMPOSITE Sales Document Item
I_SalesInquiryItem view from BASIC Sales Inquiry Item
I_SalesItemProposalItem view from BASIC Items in Item Proposal
I_SalesOrderItem view from BASIC Sales Order Item
I_SalesOrderItemBillingBlkd view from COMPOSITE SOFM Sales Order Item Billing Blocked
I_SalesOrderItemDeliveryBlkd view from COMPOSITE SOFM Sales Order Item Delivery Blocked
I_SalesOrderItemIncomplete view inner COMPOSITE SOFM Incomplete Sales Order Item
I_SalesOrderItemOverdueDeliv view from COMPOSITE SOFM Sales Order Item With Overdue Delivery
I_SalesOrderItemUnconfdQty view from COMPOSITE SOFM Sales Order Item With Unconfirmed Quantity
I_SalesOrderWithoutChargeItem view from BASIC Item for Sales Order Without Charge
I_SalesQuotationItem view from BASIC Sales Quotation Item
I_SalesQuotationItemAnalytics view from COMPOSITE Sales Quotation Item Analytics
I_SalesSchedgAgrmtItem view from BASIC Sales Scheduling Agreement Item
I_SlsDocItemEnhancedFields view from COMPOSITE Sales Document Item Enhanced Fields
I_SlsDocItmCommlAttribDetn view_entity from COMPOSITE Sales Item Commercial Attributes for IPR
I_SlsDocProfitCenterDerivation view_entity from COMPOSITE Sales document item for profit center derivation
I_SupAssgmtBlkdSlsOrdItms view inner COMPOSITE Supply Assignment Blocked Sales Order Item Details
I_SupAssgmtSitnOrdItemDet view from COMPOSITE View at Order item details for situation
P_AllocatedRevenueTot view inner COMPOSITE Allocated Revenue Totals (private view)
P_ARUNDMNDITEM view from COMPOSITE
P_Cust360SoldProductWithPrice view_entity from CONSUMPTION Customer 360 Products and Prices
P_Cust360SoldProductWithPrice view_entity union_all CONSUMPTION Customer 360 Products and Prices
P_DMVCSalesDocumentItemVH view from CONSUMPTION DMVC: Sales Document Item Value Help
P_EngmntProjSalesOrder view inner COMPOSITE
P_EvtBsdRevnRecgnSlsOrdIssDet view inner CONSUMPTION Event based rev. rec. project iss detail
P_EvtBsdRevnRecSalesOrderIss view inner CONSUMPTION Event based rev. rec. sales order issue
P_ExpectedOrderNetAmountItem view from COMPOSITE
P_IncomingSalesOrder view from COMPOSITE
P_IntactvABOPDepdntRlvtCheck view_entity from COMPOSITE Private View for Dependents Relevant Chk
P_LogcDocSalesItem view_entity from CONSUMPTION
P_MassChgSlsDocItemReadRequest view_entity from CONSUMPTION Mass chg of Sales Doc Item Read Req
P_Mpwbs view left_outer COMPOSITE
P_OpenSalesOrdersAnlyts view from COMPOSITE
P_PL_SAFTDownPaymentItem view inner CONSUMPTION
P_PrdtdDelivProcgDlyApplyData view from CONSUMPTION
P_PrdtdDelivProcgDlyTrngData view from COMPOSITE
P_PrepaymentRefDocTotalAmount view inner COMPOSITE Prepayment Document Total Amount
P_PrepaymentRefDocTotAmtSales view_entity inner COMPOSITE
P_ProductProposalSlsOrderItem view from COMPOSITE
P_ProjBillingElmntAllBillDate view_entity inner COMPOSITE Project Billing Element Date = 99991231
P_ProjBillingElmntAllBillDate2 view_entity inner COMPOSITE Proj. Billg Element Date = 99991231 (2)
P_RAIntegEBRRSalesDocument view inner COMPOSITE RAR integration EBRR Sales Document
P_ReleasedSalesContractItem view_entity from COMPOSITE
P_ReturnedSalesOrderItems view from CONSUMPTION Returned Sales Order Date Calculation
P_RevenueRecgnSalesOrderVH view inner COMPOSITE
P_RevnRecgnSalesOrderItemVH view from COMPOSITE
P_RevRecgnSalesOrderItemVH view from CONSUMPTION
P_RevRecgnSalesOrderVH view inner CONSUMPTION
P_RFM_SlsOrdIssueItmSitn view union_all COMPOSITE
P_RFM_SlsOrdItmIssueCancelDate view from COMPOSITE
P_RRBProposal view inner CONSUMPTION Billing Proposal Details
P_SalesContractAmtCrcyCnvrsn view from CONSUMPTION Sales Contract Amount Conversion
P_SalesDocItem view from COMPOSITE
P_SalesDocItemInheritedPartner view from COMPOSITE
P_SalesDocumentByObjectStatus view union CONSUMPTION Sales Documents and Items by Object Status
P_SalesDocumentItemAnlyts view from COMPOSITE
P_SalesDocumentItemFulfillmnt3 view from COMPOSITE
P_SalesDocumentsForProjects view from COMPOSITE
P_SalesQuotationAmountCnvrsn view from COMPOSITE
P_SDDocItemPartnerComplete view left_outer CONSUMPTION
P_SlsDocItemPrdtvApplyData view from CONSUMPTION
P_SlsDocItemPrdtvTrngData view from COMPOSITE
P_SLSDOCITMBSCDATA view from COMPOSITE
P_SlsOrdBillingPlanDueDate view inner COMPOSITE
P_SlsOrdConfAnalytics view inner COMPOSITE
P_SlsOrdItmBillgPlanDueDte view from COMPOSITE
P_SlsOrdItmOrdReltdBillgDue view from COMPOSITE
P_SlsOrdOrdReltdBillgDueDte view inner COMPOSITE
P_SupAssgmtDmndOvw view from COMPOSITE
P_VarConfignSalesByNetValBase view from COMPOSITE
R_EBRRSalesOrderMonitor view_entity from TRANSACTIONAL EBRR Sales Document Monitor Root
RFM_SCC_SALESDOCUMENTS view from Manage Completenss Data Selection for SO

Fields (317)

KeyField CDS FieldsUsed in Views
KEY BillingPlan BillingPlan 5
KEY Product Material,Product 20
KEY ProductConfiguration ConfigurationNumber,ProductConfiguration 9
KEY ReferenceSDDocument ReferenceSDDocument,SalesContract 13
KEY ReferenceSDDocumentItem ReferenceSDDocumentItem,SalesContractItem 12
KEY SalesDocument kdauf,ReferenceDocument,RequirementDocumentNumber,ReturnsReferenceDocument,SalesDocument,SalesOrder,SDDocument 63
KEY SalesDocumentItem CreditMemoRequestItem,CustomerReturnItem,DebitMemoRequestItem,kdpos,ReferenceDocumentItem,RequirementDocumentItem,ReturnsReferenceDocumentItem,SalesContractItem,SalesDocumentItem,SalesOrderItem,SalesOrderWithoutChargeItem,SalesQuotationItem,SalesSchedulingAgreementItem,SDDocumentItem 65
KEY SoldToParty Customer,SoldToParty 13
KEY TradingContractItem DocumentItemNumber 1
KEY WBSElementInternalID WBSElement,WBSElementInternalID 9
_AdditionalCustomerGroup1 _AdditionalCustomerGroup1 5
_AdditionalCustomerGroup2 _AdditionalCustomerGroup2 5
_AdditionalCustomerGroup3 _AdditionalCustomerGroup3 5
_AdditionalCustomerGroup4 _AdditionalCustomerGroup4 5
_AdditionalCustomerGroup5 _AdditionalCustomerGroup5 5
_AdditionalMaterialGroup1 _AdditionalMaterialGroup1 6
_AdditionalMaterialGroup2 _AdditionalMaterialGroup2 6
_AdditionalMaterialGroup3 _AdditionalMaterialGroup3 6
_AdditionalMaterialGroup4 _AdditionalMaterialGroup4 6
_AdditionalMaterialGroup5 _AdditionalMaterialGroup5 6
_BaseUnit _BaseUnit 6
_Batch _Batch 1
_BillingBlockStatus _BillingBlockStatus 5
_BillToParty _BillToParty 4
_BusinessArea _BusinessArea 5
_BusinessAreaText _BusinessAreaText 1
_ChmlCmplncStatus _ChmlCmplncStatus 3
_ControllingArea _ControllingArea 5
_CreatedByUser _CreatedByUser 6
_CustomerAccountAssgmtGroup _CustomerAccountAssgmtGroup 4
_CustomerGroup _CustomerGroup 5
_CustomerPaymentTerms _CustomerPaymentTerms 4
_DangerousGoodsStatus _DangerousGoodsStatus 3
_DeliveryBlockStatus _DeliveryBlockStatus 5
_DeliveryConfirmationStatus _DeliveryConfirmationStatus 4
_DeliveryPriority _DeliveryPriority 4
_DeliveryStatus _DeliveryStatus 6
_DistributionChannel _DistributionChannel 8
_Division _Division 7
_IncotermsClassification _IncotermsClassification 4
_IncotermsVersion _IncotermsVersion 4
_ItemBillingBlockReason _ItemBillingBlockReason 4
_ItemBillingIncompletionStatus _ItemBillingIncompletionStatus 5
_ItemCategory _ItemCategory 8
_ItemDelivIncompletionSts _ItemDelivIncompletionSts 5
_ItemGeneralIncompletionStatus _ItemGeneralIncompletionStatus 5
_ItemIsBillingRelevant _ItemIsBillingRelevant 3
_ItemVolumeUnit _ItemVolumeUnit 5
_ItemWeightUnit _ItemWeightUnit 5
_Material _Material 6
_MaterialGroup _MaterialGroup 9
_MaterialSubstitutionReason _MaterialSubstitutionReason 3
_MaterialText _MaterialText 2
_MatlAccountAssignmentGroup _MatlAccountAssignmentGroup 1
_NetPriceQuantityUnit _NetPriceQuantityUnit 5
_OrderQuantityUnit _OrderQuantityUnit 9
_OrderRelatedBillingStatus _OrderRelatedBillingStatus 7
_OrganizationDivision _OrganizationDivision 7
_OriginallyRequestedMaterial _OriginallyRequestedMaterial 7
_OrigMaterialText _OrigMaterialText 1
_OvrlTrdCmplncLegalCtrlChkSts _OvrlTrdCmplncLegalCtrlChkSts 3
_PartialDeliveryItem _PartialDeliveryItem 2
_Partner _Partner 1
_PayerParty _PayerParty 4
_Plant _Plant 8
_PricingIncompletionStatus _PricingIncompletionStatus 5
_Product _Product 3
_ProductGroup _ProductGroup 3
_ProductHierarchyNode _ProductHierarchyNode 3
_ProductText _ProductText 2
_ProfitCenter _ProfitCenter 4
_PurchaseConfirmationStatus _PurchaseConfirmationStatus 4
_ReferenceSDDocument _ReferenceSDDocument 6
_ReferenceSDDocumentCategory _ReferenceSDDocumentCategory 6
_ReferenceSDDocumentItem _ReferenceSDDocumentItem 6
_RequestedQuantityUnit _RequestedQuantityUnit 3
_ResponsibleEmployee _ResponsibleEmployee 4
_ReturnReason _ReturnReason 4
_ReturnsRefundExtent _ReturnsRefundExtent 3
_Route _Route 4
_SafetyDataSheetStatus _SafetyDataSheetStatus 3
_SalesContractCanclnParty _SalesContractCanclnParty 1
_SalesContractCanclnReason _SalesContractCanclnReason 1
_SalesDeal _SalesDeal 2
_SalesDistrict _SalesDistrict 6
_SalesDocument _SalesDocument 10
_SalesDocumentRjcnReason _SalesDocumentRjcnReason 6
_SalesDocumentType _SalesDocumentType 6
_SalesEmployee _SalesEmployee 4
_SalesGroup _SalesGroup 6
_SalesOffice _SalesOffice 6
_SalesOrganization _SalesOrganization 7
_ScheduleLine _ScheduleLine 5
_SDDocumentCategory _SDDocumentCategory 11
_SDDocumentReason _SDDocumentReason 5
_SDDocumentRejectionStatus _SDDocumentRejectionStatus 5
_SDProcessStatus _SDProcessStatus 7
_ShippingCondition _ShippingCondition 4
_ShippingPoint _ShippingPoint 4
_ShippingPointText _ShippingPointText 1
_ShippingType _ShippingType 6
_ShipToParty _ShipToParty 6
_SoldToParty _SoldToParty 6
_StatisticalValueControl _StatisticalValueControl 5
_StorageLocation _StorageLocation 7
_TargetQuantityUnit _TargetQuantityUnit 3
_TotalDeliveryStatus _TotalDeliveryStatus 5
_TotalSDDocReferenceStatus _TotalSDDocReferenceStatus 5
_TransactionCurrency _TransactionCurrency 12
_TrdCmplncEmbargoSts _TrdCmplncEmbargoSts 3
_TrdCmplncSnctndListChkSts _TrdCmplncSnctndListChkSts 3
_WBSElementBasicData_2 _WBSElementBasicData_2 3
AdditionalCustomerGroup1 AdditionalCustomerGroup1 7
AdditionalCustomerGroup2 AdditionalCustomerGroup2 7
AdditionalCustomerGroup3 AdditionalCustomerGroup3 7
AdditionalCustomerGroup4 AdditionalCustomerGroup4 7
AdditionalCustomerGroup5 AdditionalCustomerGroup5 7
AdditionalMaterialGroup1 AdditionalMaterialGroup1 18
AdditionalMaterialGroup2 AdditionalMaterialGroup2 18
AdditionalMaterialGroup3 AdditionalMaterialGroup3 18
AdditionalMaterialGroup4 AdditionalMaterialGroup4 18
AdditionalMaterialGroup5 AdditionalMaterialGroup5 18
AdditionalValueDays AdditionalValueDays 3
BaseUnit BaseUnit 23
Batch Batch 25
BillingBlockStatus BillingBlockStatus 9
BillingDocumentDate BillingDocumentDate 11
BillOfMaterial BillOfMaterial 6
BillToParty BillToParty 12
BOMExplosionDate BOMExplosionDate 2
BusinessArea BusinessArea 13
BusinessSolutionOrder BusinessSolutionOrder 3
CappedNetAmount CappedNetAmount 1
CommittedDelivCreationDate CommittedDelivCreationDate 3
CommittedDeliveryDate CommittedDeliveryDate,RequestedDeliveryDate 5
CommittedDelivQtyInOrdQtyUnit CommittedDelivQtyInOrdQtyUnit 3
CompletionRule CompletionRule 7
ConfdDeliveryQtyInBaseUnit ConfdDeliveryQtyInBaseUnit 10
ConfdDelivQtyInOrderQtyUnit ConfdDelivQtyInOrderQtyUnit 17
ContractPartnerCanclnDocDate ContractPartnerCanclnDocDate 1
ControllingArea ControllingArea 5
ControllingObject ControllingObject,ObjectNumber,objnr 8
CostAmount CostAmount 9
CreatedByUser CreatedByUser,ItemCreatedByUser 9
CreationDate CreationDate,DocumentDate,ItemCreationDate 26
CreationTime CreationTime,ItemCreationTime 16
CustomerAccountAssignmentGroup CustomerAccountAssignmentGroup 8
CustomerGroup CustomerGroup 14
CustomerPaymentTerms CustomerPaymentTerms,PaymentTerms 14
CustomerPurchaseOrderDate CustomerPurchaseOrderDate 3
DeliveryBlockStatus DeliveryBlockReason,DeliveryBlockStatus 7
DeliveryConfirmationStatus DeliveryConfirmationStatus 6
DeliveryDateQuantityIsFixed DeliveryDateQuantityIsFixed 8
DeliveryGroup DeliveryGroup 6
DeliveryPriority DeliveryPriority 11
DeliveryStatus DeliveryStatus 15
DistributionChannel DistributionChannel 19
Division Division,OrganizationDivision 24
ExchangeRateDate ExchangeRateDate 7
FashionCancelDate FashionCancelDate 4
FiscalPeriod FiscalPeriod 10
FiscalYear FiscalYear 9
FixedValueDate FixedValueDate 3
HigherLevelItem HigherLevelItem 11
IncotermsClassification IncotermsClassification 15
IncotermsLocation1 IncotermsLocation1 11
IncotermsLocation2 IncotermsLocation2 11
IncotermsTransferLocation IncotermsTransferLocation 14
IncotermsVersion IncotermsVersion 10
InternationalArticleNumber InternationalArticleNumber 15
InventorySpecialStockType InventorySpecialStockType 10
IsReturnsItem IsReturnsItem 8
ItemBillingBlockReason ItemBillingBlockReason 14
ItemBillingIncompletionStatus ItemBillingIncompletionStatus 9
ItemDeliveryIncompletionStatus ItemDeliveryIncompletionStatus 9
ItemGeneralIncompletionStatus ItemGeneralIncompletionStatus 9
ItemGrossWeight ItemGrossWeight 9
ItemIsBillingRelevant ItemIsBillingRelevant 8
ItemIsDeliveryRelevant ItemIsDeliveryRelevant 3
ItemNetWeight ItemNetWeight 11
ItemOrderProbabilityInPercent ItemOrderProbabilityInPercent 6
ItemVolume ItemVolume 11
ItemVolumeUnit ItemVolumeUnit 13
ItemWeightUnit ItemWeightUnit 13
LastChangeDate ItemLastChangeDate,LastChangeDate 16
MainItemPricingRefProduct MainItemPricingRefProduct 2
Material Material,Product 26
MaterialByCustomer MaterialByCustomer 19
MaterialGroup MaterialGroup,ProductGroup 23
MaterialPricingGroup MaterialPricingGroup 4
MaterialSubstitutionReason MaterialSubstitutionReason 11
MatlAccountAssignmentGroup MatlAccountAssignmentGroup 1
MaxNmbrOfPartialDelivery MaxNmbrOfPartialDelivery 7
MinDeliveryQtyInBaseUnit MinDeliveryQtyInBaseUnit 9
MRPArea MRPArea 6
NetAmount BillAmtInProjCrcy,NetAmount 26
NetPriceAmount NetPriceAmount 21
NetPriceQuantity NetPriceQuantity 13
NetPriceQuantityUnit NetPriceQuantityUnit 14
OpenDeliveryLeadingUnitCode OpenDeliveryLeadingUnitCode 6
OrderCombinationIsAllowed OrderCombinationIsAllowed 1
OrderID OrderID 8
OrderQuantity OrderQuantity,ReturnedQuantity 22
OrderQuantityUnit OrderQuantityUnit,ReturnQuantityUnit,SalesUnit 34
OrderRelatedBillingStatus OrderRelatedBillingStatus 17
OrderToBaseQuantityDnmntr OrderToBaseQuantityDnmntr 9
OrderToBaseQuantityNmrtr OrderToBaseQuantityNmrtr 9
OrganizationDivision OrganizationDivision 16
OriginallyRequestedMaterial OriginallyRequestedMaterial 17
OriginSDDocument OriginSDDocument 7
OriginSDDocumentItem OriginSDDocumentItem 7
OutlineAgreementTargetAmount OutlineAgreementTargetAmount 3
OverdelivTolrtdLmtRatioInPct OverdelivTolrtdLmtRatioInPct 9
OvrlTrdCmplncLegalCtrlChkSts TradeCmplncLegalCtrlChkSts 1
PartialDeliveryIsAllowed PartialDeliveryIsAllowed 9
PayerParty PayerParty 12
PaymentMethod PaymentMethod 9
Plant Plant,ProductionPlant 37
PriceDetnExchangeRate PriceDetnExchangeRate 7
PricingDate PricingDate 10
PricingIncompletionStatus PricingIncompletionStatus 9
ProdAvailabilityCheckGroup ProdAvailabilityCheckGroup 5
ProductCatalog ProductCatalog 8
ProductCharacteristic1 ProductCharacteristic1 6
ProductCharacteristic2 ProductCharacteristic2 6
ProductCharacteristic3 ProductCharacteristic3 6
ProductCollection ProductCollection 6
ProductGroup ProductGroup 12
ProductHierarchyNode ProductHierarchyNode 11
ProductSeason ProductSeason 6
ProductSeasonYear ProductSeasonYear 6
ProductTaxClassification1 ProductTaxClassification1 2
ProductTaxClassification2 ProductTaxClassification2 2
ProductTaxClassification3 ProductTaxClassification3 2
ProductTaxClassification4 ProductTaxClassification4 2
ProductTaxClassification5 ProductTaxClassification5 2
ProductTaxClassification6 ProductTaxClassification6 2
ProductTaxClassification7 ProductTaxClassification7 2
ProductTaxClassification8 ProductTaxClassification8 2
ProductTaxClassification9 ProductTaxClassification9 2
ProductTheme ProductTheme 6
ProfitabilitySegment ProfitabilitySegment 3
ProfitabilitySegment_2 ProfitabilitySegment,ProfitabilitySegment_2 8
ProfitCenter object_prctr,ProfitCenter 17
PurchaseConfirmationStatus PurchaseConfirmationStatus 4
PurchaseOrderByCustomer PurchaseOrderByCustomer 6
PurchasingDocumentItem PurchasingDocumentITem 1
QuantityIsFixed QuantityIsFixed 7
ReferenceSDDocumentCategory ReferenceSDDocumentCategory 15
RequestedDeliveryDate RequestedDeliveryDate 7
RequestedQuantity RequestedQuantity 15
RequestedQuantityInBaseUnit AggregatedOrderQuantity,OrderQuantity,RequestedQuantityInBaseUnit,RequestedRqmtQtyInBaseUnit 12
RequestedQuantityUnit RequestedQuantityUnit 15
RequirementSegment RequirementSegment,StockSegment 8
ResponsibleEmployee ResponsibleEmployee 6
ResponsibleEmployeeWorkAgrmt ResponsibleEmployeeWorkAgrmt 4
ResultAnalysisInternalID ResultAnalysisInternalID 4
RetailPromotion RetailPromotion 2
RetsMgmtProcessingBlock RetsMgmtProcessingBlock 4
ReturnReason ReturnReason 6
ReturnsRefundExtent ReturnsRefundExtent 3
Route Route 14
SalesContractCanclnParty SalesContractCanclnParty 1
SalesContractCanclnReason SalesContractCanclnReason 1
SalesDeal SalesDeal 6
SalesDistrict SalesDistrict 18
SalesDocumentCondition CustomerReturnCondition,SalesDocumentCondition 5
SalesDocumentDate CustomerReturnDate,SalesDocumentDate 4
SalesDocumentItemCategory CustomerReturnItemCategory,SalesDocumentItemCategory,SalesOrderItemCategory 32
SalesDocumentItemText CustomerReturnItemText,SalesDocumentItemText,SalesOrderItemText 26
SalesDocumentItemType CustomerReturnItemType,SalesDocumentItemType 11
SalesDocumentItemUUID CustomerReturnItemUUID,SalesDocumentItemUUID 5
SalesDocumentRjcnReason SalesDocumentRjcnReason 20
SalesDocumentType OrderType,SalesDocumentType 19
SalesEmployee SalesEmployee 6
SalesEmployeeWorkAgreement SalesEmployeeWorkAgreement 4
SalesGroup SalesGroup 8
SalesOffice SalesOffice 8
SalesOrganization SalesOrganization 20
SalesPromotion SalesPromotion 2
SDDocReferenceStatus SDDocReferenceStatus 6
SDDocumentCategory SDDocumentCategory 17
SDDocumentReason SDDocumentReason 7
SDDocumentRejectionStatus SDDocumentRejectionStatus 17
SDProcessStatus SDProcessStatus 15
ServicesRenderedDate ServicesRenderedDate 8
ShippingCondition ShippingCondition 5
ShippingGroupNumber ShippingGroupNumber 4
ShippingGroupRule ShippingGroupRule 4
ShippingPoint ShippingPoint 23
ShippingType ShippingType 14
ShipToParty ShipToParty 18
StatisticalValueControl StatisticalValueControl 9
StorageLocation StorageLocation 24
Subtotal1Amount Subtotal1Amount 11
Subtotal2Amount Subtotal2Amount 11
Subtotal3Amount Subtotal3Amount 11
Subtotal4Amount Subtotal4Amount 11
Subtotal5Amount Subtotal5Amount 11
Subtotal6Amount Subtotal6Amount 11
TargetDelivQtyInOrderQtyUnit TargetDelivQtyInOrderQtyUnit 9
TargetQuantity TargetQuantity 10
TargetQuantityUnit TargetQuantityUnit 12
TargetToBaseQuantityDnmntr TargetToBaseQuantityDnmntr 7
TargetToBaseQuantityNmrtr TargetToBaseQuantityNmrtr 7
TaxAmount TaxAmount 10
TotalDeliveryStatus TotalDeliveryStatus 14
TotalSDDocReferenceStatus TotalSDDocReferenceStatus 7
TotalStandAloneSellingPrice TotalStandAloneSellingPrice 2
TransactionCurrency Currency,DocumentCurrency,TransactionCurrency 37
TrdgContrTotalNetAmountCrcy PrepaymentTotalAmtCrcy 1
UnderdelivTolrtdLmtRatioInPct UnderdelivTolrtdLmtRatioInPct 9
UnderlyingPurchaseOrderItem UnderlyingPurchaseOrderItem 1
UnlimitedOverdeliveryIsAllowed UnlimitedOverdeliveryIsAllowed 9
ValueContract ValueContract 4
ValueContractItem ValueContractItem 4
WBSElement WBSElement 7

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Sales Document Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SALESDOCUMENTITEM (
    BILLINGPLAN,
    PRODUCT,
    PRODUCTCONFIGURATION,
    REFERENCESDDOCUMENT,
    REFERENCESDDOCUMENTITEM,
    SALESDOCUMENT,
    SALESDOCUMENTITEM,
    SOLDTOPARTY,
    TRADINGCONTRACTITEM,
    WBSELEMENTINTERNALID,
    _ADDITIONALCUSTOMERGROUP1,
    _ADDITIONALCUSTOMERGROUP2,
    _ADDITIONALCUSTOMERGROUP3,
    _ADDITIONALCUSTOMERGROUP4,
    _ADDITIONALCUSTOMERGROUP5,
    _ADDITIONALMATERIALGROUP1,
    _ADDITIONALMATERIALGROUP2,
    _ADDITIONALMATERIALGROUP3,
    _ADDITIONALMATERIALGROUP4,
    _ADDITIONALMATERIALGROUP5,
    _BASEUNIT,
    _BATCH,
    _BILLINGBLOCKSTATUS,
    _BILLTOPARTY,
    _BUSINESSAREA,
    _BUSINESSAREATEXT,
    _CHMLCMPLNCSTATUS,
    _CONTROLLINGAREA,
    _CREATEDBYUSER,
    _CUSTOMERACCOUNTASSGMTGROUP,
    _CUSTOMERGROUP,
    _CUSTOMERPAYMENTTERMS,
    _DANGEROUSGOODSSTATUS,
    _DELIVERYBLOCKSTATUS,
    _DELIVERYCONFIRMATIONSTATUS,
    _DELIVERYPRIORITY,
    _DELIVERYSTATUS,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _INCOTERMSCLASSIFICATION,
    _INCOTERMSVERSION,
    _ITEMBILLINGBLOCKREASON,
    _ITEMBILLINGINCOMPLETIONSTATUS,
    _ITEMCATEGORY,
    _ITEMDELIVINCOMPLETIONSTS,
    _ITEMGENERALINCOMPLETIONSTATUS,
    _ITEMISBILLINGRELEVANT,
    _ITEMVOLUMEUNIT,
    _ITEMWEIGHTUNIT,
    _MATERIAL,
    _MATERIALGROUP,
    _MATERIALSUBSTITUTIONREASON,
    _MATERIALTEXT,
    _MATLACCOUNTASSIGNMENTGROUP,
    _NETPRICEQUANTITYUNIT,
    _ORDERQUANTITYUNIT,
    _ORDERRELATEDBILLINGSTATUS,
    _ORGANIZATIONDIVISION,
    _ORIGINALLYREQUESTEDMATERIAL,
    _ORIGMATERIALTEXT,
    _OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    _PARTIALDELIVERYITEM,
    _PARTNER,
    _PAYERPARTY,
    _PLANT,
    _PRICINGINCOMPLETIONSTATUS,
    _PRODUCT,
    _PRODUCTGROUP,
    _PRODUCTHIERARCHYNODE,
    _PRODUCTTEXT,
    _PROFITCENTER,
    _PURCHASECONFIRMATIONSTATUS,
    _REFERENCESDDOCUMENT,
    _REFERENCESDDOCUMENTCATEGORY,
    _REFERENCESDDOCUMENTITEM,
    _REQUESTEDQUANTITYUNIT,
    _RESPONSIBLEEMPLOYEE,
    _RETURNREASON,
    _RETURNSREFUNDEXTENT,
    _ROUTE,
    _SAFETYDATASHEETSTATUS,
    _SALESCONTRACTCANCLNPARTY,
    _SALESCONTRACTCANCLNREASON,
    _SALESDEAL,
    _SALESDISTRICT,
    _SALESDOCUMENT,
    _SALESDOCUMENTRJCNREASON,
    _SALESDOCUMENTTYPE,
    _SALESEMPLOYEE,
    _SALESGROUP,
    _SALESOFFICE,
    _SALESORGANIZATION,
    _SCHEDULELINE,
    _SDDOCUMENTCATEGORY,
    _SDDOCUMENTREASON,
    _SDDOCUMENTREJECTIONSTATUS,
    _SDPROCESSSTATUS,
    _SHIPPINGCONDITION,
    _SHIPPINGPOINT,
    _SHIPPINGPOINTTEXT,
    _SHIPPINGTYPE,
    _SHIPTOPARTY,
    _SOLDTOPARTY,
    _STATISTICALVALUECONTROL,
    _STORAGELOCATION,
    _TARGETQUANTITYUNIT,
    _TOTALDELIVERYSTATUS,
    _TOTALSDDOCREFERENCESTATUS,
    _TRANSACTIONCURRENCY,
    _TRDCMPLNCEMBARGOSTS,
    _TRDCMPLNCSNCTNDLISTCHKSTS,
    _WBSELEMENTBASICDATA_2,
    ADDITIONALCUSTOMERGROUP1,
    ADDITIONALCUSTOMERGROUP2,
    ADDITIONALCUSTOMERGROUP3,
    ADDITIONALCUSTOMERGROUP4,
    ADDITIONALCUSTOMERGROUP5,
    ADDITIONALMATERIALGROUP1,
    ADDITIONALMATERIALGROUP2,
    ADDITIONALMATERIALGROUP3,
    ADDITIONALMATERIALGROUP4,
    ADDITIONALMATERIALGROUP5,
    ADDITIONALVALUEDAYS,
    BASEUNIT,
    BATCH,
    BILLINGBLOCKSTATUS,
    BILLINGDOCUMENTDATE,
    BILLOFMATERIAL,
    BILLTOPARTY,
    BOMEXPLOSIONDATE,
    BUSINESSAREA,
    BUSINESSSOLUTIONORDER,
    CAPPEDNETAMOUNT,
    COMMITTEDDELIVCREATIONDATE,
    COMMITTEDDELIVERYDATE,
    COMMITTEDDELIVQTYINORDQTYUNIT,
    COMPLETIONRULE,
    CONFDDELIVERYQTYINBASEUNIT,
    CONFDDELIVQTYINORDERQTYUNIT,
    CONTRACTPARTNERCANCLNDOCDATE,
    CONTROLLINGAREA,
    CONTROLLINGOBJECT,
    COSTAMOUNT,
    CREATEDBYUSER,
    CREATIONDATE,
    CREATIONTIME,
    CUSTOMERACCOUNTASSIGNMENTGROUP,
    CUSTOMERGROUP,
    CUSTOMERPAYMENTTERMS,
    CUSTOMERPURCHASEORDERDATE,
    DELIVERYBLOCKSTATUS,
    DELIVERYCONFIRMATIONSTATUS,
    DELIVERYDATEQUANTITYISFIXED,
    DELIVERYGROUP,
    DELIVERYPRIORITY,
    DELIVERYSTATUS,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    EXCHANGERATEDATE,
    FASHIONCANCELDATE,
    FISCALPERIOD,
    FISCALYEAR,
    FIXEDVALUEDATE,
    HIGHERLEVELITEM,
    INCOTERMSCLASSIFICATION,
    INCOTERMSLOCATION1,
    INCOTERMSLOCATION2,
    INCOTERMSTRANSFERLOCATION,
    INCOTERMSVERSION,
    INTERNATIONALARTICLENUMBER,
    INVENTORYSPECIALSTOCKTYPE,
    ISRETURNSITEM,
    ITEMBILLINGBLOCKREASON,
    ITEMBILLINGINCOMPLETIONSTATUS,
    ITEMDELIVERYINCOMPLETIONSTATUS,
    ITEMGENERALINCOMPLETIONSTATUS,
    ITEMGROSSWEIGHT,
    ITEMISBILLINGRELEVANT,
    ITEMISDELIVERYRELEVANT,
    ITEMNETWEIGHT,
    ITEMORDERPROBABILITYINPERCENT,
    ITEMVOLUME,
    ITEMVOLUMEUNIT,
    ITEMWEIGHTUNIT,
    LASTCHANGEDATE,
    MAINITEMPRICINGREFPRODUCT,
    MATERIAL,
    MATERIALBYCUSTOMER,
    MATERIALGROUP,
    MATERIALPRICINGGROUP,
    MATERIALSUBSTITUTIONREASON,
    MATLACCOUNTASSIGNMENTGROUP,
    MAXNMBROFPARTIALDELIVERY,
    MINDELIVERYQTYINBASEUNIT,
    MRPAREA,
    NETAMOUNT,
    NETPRICEAMOUNT,
    NETPRICEQUANTITY,
    NETPRICEQUANTITYUNIT,
    OPENDELIVERYLEADINGUNITCODE,
    ORDERCOMBINATIONISALLOWED,
    ORDERID,
    ORDERQUANTITY,
    ORDERQUANTITYUNIT,
    ORDERRELATEDBILLINGSTATUS,
    ORDERTOBASEQUANTITYDNMNTR,
    ORDERTOBASEQUANTITYNMRTR,
    ORGANIZATIONDIVISION,
    ORIGINALLYREQUESTEDMATERIAL,
    ORIGINSDDOCUMENT,
    ORIGINSDDOCUMENTITEM,
    OUTLINEAGREEMENTTARGETAMOUNT,
    OVERDELIVTOLRTDLMTRATIOINPCT,
    OVRLTRDCMPLNCLEGALCTRLCHKSTS,
    PARTIALDELIVERYISALLOWED,
    PAYERPARTY,
    PAYMENTMETHOD,
    PLANT,
    PRICEDETNEXCHANGERATE,
    PRICINGDATE,
    PRICINGINCOMPLETIONSTATUS,
    PRODAVAILABILITYCHECKGROUP,
    PRODUCTCATALOG,
    PRODUCTCHARACTERISTIC1,
    PRODUCTCHARACTERISTIC2,
    PRODUCTCHARACTERISTIC3,
    PRODUCTCOLLECTION,
    PRODUCTGROUP,
    PRODUCTHIERARCHYNODE,
    PRODUCTSEASON,
    PRODUCTSEASONYEAR,
    PRODUCTTAXCLASSIFICATION1,
    PRODUCTTAXCLASSIFICATION2,
    PRODUCTTAXCLASSIFICATION3,
    PRODUCTTAXCLASSIFICATION4,
    PRODUCTTAXCLASSIFICATION5,
    PRODUCTTAXCLASSIFICATION6,
    PRODUCTTAXCLASSIFICATION7,
    PRODUCTTAXCLASSIFICATION8,
    PRODUCTTAXCLASSIFICATION9,
    PRODUCTTHEME,
    PROFITABILITYSEGMENT,
    PROFITABILITYSEGMENT_2,
    PROFITCENTER,
    PURCHASECONFIRMATIONSTATUS,
    PURCHASEORDERBYCUSTOMER,
    PURCHASINGDOCUMENTITEM,
    QUANTITYISFIXED,
    REFERENCESDDOCUMENTCATEGORY,
    REQUESTEDDELIVERYDATE,
    REQUESTEDQUANTITY,
    REQUESTEDQUANTITYINBASEUNIT,
    REQUESTEDQUANTITYUNIT,
    REQUIREMENTSEGMENT,
    RESPONSIBLEEMPLOYEE,
    RESPONSIBLEEMPLOYEEWORKAGRMT,
    RESULTANALYSISINTERNALID,
    RETAILPROMOTION,
    RETSMGMTPROCESSINGBLOCK,
    RETURNREASON,
    RETURNSREFUNDEXTENT,
    ROUTE,
    SALESCONTRACTCANCLNPARTY,
    SALESCONTRACTCANCLNREASON,
    SALESDEAL,
    SALESDISTRICT,
    SALESDOCUMENTCONDITION,
    SALESDOCUMENTDATE,
    SALESDOCUMENTITEMCATEGORY,
    SALESDOCUMENTITEMTEXT,
    SALESDOCUMENTITEMTYPE,
    SALESDOCUMENTITEMUUID,
    SALESDOCUMENTRJCNREASON,
    SALESDOCUMENTTYPE,
    SALESEMPLOYEE,
    SALESEMPLOYEEWORKAGREEMENT,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SALESPROMOTION,
    SDDOCREFERENCESTATUS,
    SDDOCUMENTCATEGORY,
    SDDOCUMENTREASON,
    SDDOCUMENTREJECTIONSTATUS,
    SDPROCESSSTATUS,
    SERVICESRENDEREDDATE,
    SHIPPINGCONDITION,
    SHIPPINGGROUPNUMBER,
    SHIPPINGGROUPRULE,
    SHIPPINGPOINT,
    SHIPPINGTYPE,
    SHIPTOPARTY,
    STATISTICALVALUECONTROL,
    STORAGELOCATION,
    SUBTOTAL1AMOUNT,
    SUBTOTAL2AMOUNT,
    SUBTOTAL3AMOUNT,
    SUBTOTAL4AMOUNT,
    SUBTOTAL5AMOUNT,
    SUBTOTAL6AMOUNT,
    TARGETDELIVQTYINORDERQTYUNIT,
    TARGETQUANTITY,
    TARGETQUANTITYUNIT,
    TARGETTOBASEQUANTITYDNMNTR,
    TARGETTOBASEQUANTITYNMRTR,
    TAXAMOUNT,
    TOTALDELIVERYSTATUS,
    TOTALSDDOCREFERENCESTATUS,
    TOTALSTANDALONESELLINGPRICE,
    TRANSACTIONCURRENCY,
    TRDGCONTRTOTALNETAMOUNTCRCY,
    UNDERDELIVTOLRTDLMTRATIOINPCT,
    UNDERLYINGPURCHASEORDERITEM,
    UNLIMITEDOVERDELIVERYISALLOWED,
    VALUECONTRACT,
    VALUECONTRACTITEM,
    WBSELEMENT,
    PRIMARY KEY (BILLINGPLAN, PRODUCT, PRODUCTCONFIGURATION, REFERENCESDDOCUMENT, REFERENCESDDOCUMENTITEM, SALESDOCUMENT, SALESDOCUMENTITEM, SOLDTOPARTY, TRADINGCONTRACTITEM, WBSELEMENTINTERNALID)
);

Learn More