I_SalesDocumentItem

Sales Document Item | view: ISDSALESDOCITEM | ATTR | Extraction: Not supported | Component: Sales
Tables used: VBAP, VBAK, VBAP, VBKD, VEDA
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
OutlineAgreementTargetAmount Target Value for Outline Agreement in Document Currency
NetAmount Net Value of the Order Item in Document Currency
NetPriceAmount Net Price
TaxAmount Tax Amount in Document Currency
CostAmount Cost in Document Currency
Subtotal1Amount Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount Subtotal 6 from Pricing Procedure for Price Element
CappedNetAmount Net Amount Cap
TotalStandAloneSellingPrice IFRS 15: Standalone Selling Price
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
TargetDelivQtyInOrderQtyUnit Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)
CommittedDelivQtyInOrdQtyUnit Committed Delivery Quantity in Order Quantity Unit
📏 Target Quantity UoM (TargetQuantityUnit):
TargetQuantity Target Quantity in Sales Units
📏 Base Unit of Measure (BaseUnit):
ConfdDeliveryQtyInBaseUnit Cumulative Confirmed Quantity in Base Unit
RequestedQuantityInBaseUnit Requested Order Quantity in Base Unit
MinDeliveryQtyInBaseUnit Minimum Delivery Quantity in Delivery Note Processing
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity Requested Quantity
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
Column Name Description
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
BOMExplosionDate Key date of the bill of material
CommittedDelivCreationDate Deliv. Creation Date in Order to Meet Committed Deliv. Date
CommittedDeliveryDate Delivery Date that the Supplier has Committed to
ServicesRenderedDate Date on which services are rendered
SalesContractValidityStartDate Contract Start Date
SalesContractValidityEndDate Contract End Date
SalesContractSignedDate Date on Which Contract Is Signed
EquipmentInstallationDate Installation Date
EquipmentDeliveryAccptcDate Agreement Acceptance Date
EquipmentDismantlingDate Dismantling Date
RequestedCancellationDate Requested Cancellation Date
SlsContractCanclnReqRcptDate Date on Which Cancellation Request Was Received
ContractPartnerCanclnDocDate Date of Cancellation Document from Contract Partner
SlsContractFollowUpActionDate Date for Action
PricingDate Date for Pricing and Exchange Rate
ExchangeRateDate Translation date
FashionCancelDate Cancellation Date
BillingDocumentDate Billing Date
FixedValueDate Fixed Value Date
SalesDocumentDate Document Date (Date Received/Sent)
RequestedDeliveryDate Requested Delivery Date
Column Name Description
SDDocumentCategory SD Document Category Show values
SalesDocumentItemType Item Type Show values
IsReturnsItem Returns Item Show values
CompletionRule Completion Rule for Quotation / Contract Show values
MaterialDeterminationType ID for material determination Show values
HigherLevelItemUsage ID for higher-level item usage Show values
SlsDocIsRlvtForProofOfDeliv Relevant for POD processing Show values
RetsMgmtProcessingBlock Approval Block Show values
QuantityIsFixed Quantity is fixed Show values
ItemOrderProbabilityInPercent Order Probability of the Item Show values
SalesContractValidityPerdUnit Unit of Validity Period of Contract Show values
SalesContractCanclnParty Cancellation Party Show values
SalesDocumentItemProcgCode Item Processing Code Show values
StatisticalValueControl Statistical Values Show values
InventorySpecialStockValnType Valuation of Special Stock Show values
DeliveryDateQuantityIsFixed Delivery Date and Quantity Fixed Show values
PartialDeliveryIsAllowed Partial Delivery at Item Level Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
OpenDeliveryLeadingUnitCode ID: Leading unit of measure for completing a transaction Show values
ItemIsDeliveryRelevant Item Is Relevant for Delivery Show values
ItemIsBillingRelevant Relevant for Billing Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SDProcessStatus Overall Processing Status (Item) Show values
DeliveryConfirmationStatus Delivery Confirmation Status (Item) Show values
DeliveryDateTypeRule Delivery Date Rule Show values
PurchaseConfirmationStatus Purchasing Confirmation Status Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
DeliveryBlockStatus Delivery Block Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
BillingBlockStatus Billing Block Status (Item) Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
SDDocReferenceStatus Reference Status (Item) Show values
ChmlCmplncStatus Product Marketability Status (Item) Show values
DangerousGoodsStatus Dangerous Goods Status (Item) Show values
SafetyDataSheetStatus Safety Data Sheet Status (Item) Show values
TrdCmplncEmbargoSts Embargo Status (Item) Show values
TrdCmplncSnctndListChkSts Screening Status (Item) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status (All Schedule Lines) Show values
AltvBsdConfSubstitutionStatus Substitution Status for Alternative-Based Confirmation (ABC) Show values
ContractItemDownPaymentStatus Down Payment Status Show values
ConsumptionPosting Consumption posting Show values
Column Name Description Domain name
SalesDocumentItemUUID GUID in 'CHAR' Format in Uppercase SYSUUID_C
CreatedByUser Name of Person Responsible for Creating the Object USNAM
MaterialByCustomer Material Number Used by Customer IDNEX
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
ProductConfiguration Configuration CUOBJ
MRPArea MRP Area BERID
BillOfMaterial Bill of Material STNUM
SalesDocumentItemText Short text for sales order item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
PurchaseOrderByShipToParty Ship-to Party's Customer Reference BSTKD
UnderlyingPurchaseOrderItem Item Number of the Underlying Purchase Order POSEX
ExternalItemID External Item ID CHAR40
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
TargetToBaseQuantityDnmntr Factor for Converting Sales Units to Base Units (Target Qty) UMBSN
TargetToBaseQuantityNmrtr Factor for Converting Sales Units to Base Units (Target Qty) UMBSZ
MDSubstnConversionNumerator Quantity Conversion: Numerator
MDSubstnConversionDenominator Quantity Conversion: Denominator
AlternativeToItem Item for Which this Item is an Alternative GRPOS
RequirementSegment Requirement Segment SGT_SRCA
NmbrOfSalesContractValdtyPerd Validity Period of Contract NUM3
CanclnDocByContrPartner Cancellation Document Number of Contract Partner CHAR20
ProductTaxClassification1 Tax Classification for Material TAXKD
ProductTaxClassification2 Tax Classification for Material TAXKD
ProductTaxClassification3 Tax Classification for Material TAXKD
ProductTaxClassification4 Tax Classification for Material TAXKD
ProductTaxClassification5 Tax Classification for Material TAXKD
ProductTaxClassification6 Tax Classification for Material TAXKD
ProductTaxClassification7 Tax Classification for Material TAXKD
ProductTaxClassification8 Tax Classification for Material TAXKD
ProductTaxClassification9 Tax Classification for Material TAXKD
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
NetPriceQuantity Condition Pricing Unit KPEIN
SalesDocumentCondition Number of the Document Condition KNUMV
Plant Plant (Own or External) WERKS
OriginalPlant Original Plant in Plant Substitution WERKS
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
MaxNmbrOfPartialDelivery Number of Allowed Partial Deliveries ANTLF
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
ShippingGroupRule PSST Grouping Rule RFM_PSST_RULE
ARunPriorityValue ARun Demand Priority VBELN
ARunDemandGroupPriority ARun Demand Group Priority VBELN
ReferenceBillingPlan Billing plan number / invoicing plan number FPLNR
ReferenceBillingPlanItem Item for billing plan/invoice plan/payment cards FPLTR
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
AdditionalValueDays Additional Value Days TAGE2
ContractAccount Contract Account Number CORR_VKONT_KK
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating Item POSNR
AccountingExchangeRate Exchange Rate for Postings to Financial Accounting KURRF
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
BusinessSolutionOrderItem Solution Order Item CRMS4_NUMBER_INT
CappedNetAmtAlertThldInPct Notification Threshold (in Pct) for Exceeded Net Amount Cap CAPPED_NET_AMOUNT_ALERT_THLD
ServiceDocument Service Document ID CRM_OBJECT_ID
ServiceDocumentItem Service Document Item ID FCO_SRVDOC_ITEM_ID
SalesDocumentType Sales Document Type AUART
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Division SPART
SalesOffice Sales office VKBUR
SalesGroup Sales group VKGRP
SoldToParty Sold-to Party KUNNR
AdditionalCustomerGroup1 Customer Group 1 KVGR1
AdditionalCustomerGroup2 Customer Group 2 KVGR2
AdditionalCustomerGroup3 Customer Group 3 KVGR3
AdditionalCustomerGroup4 Customer Group 4 KVGR4
AdditionalCustomerGroup5 Customer Group 5 KVGR5
SDDocumentReason Order Reason (Reason for the Business Transaction) AUGRU
ShippingCondition Shipping Conditions VSBED
ShipToParty Ship-to Party KUNNR
PayerParty Payer KUNNR
BillToParty Bill-to Party KUNNR
SalesEmployee Sales Employee PERNR
ResponsibleEmployee Employee Responsible PERNR
SalesEmployeeWorkAgreement Sales Employee PERNR
ResponsibleEmployeeWorkAgrmt Employee Responsible PERNR
OmniChannelSalesPromotion ID for Omnichannel Sales Promotion DOM_BOB_PROMOTION_ID
OmniChannelSalesPromotionRule Free Goods ID of Omnichannel Sales Promotions DOM_BOB_FG_ID
Master Data Relations Join Conditions
Material Group 1
  • Material Group 1
  • Client
  • I_SALESDOCUMENTITEM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
  • I_SALESDOCUMENTITEM.MANDT == TVM1.MANDT
Material Group 2
  • Client
  • Material Group 2
  • I_SALESDOCUMENTITEM.MANDT == TVM2.MANDT
  • I_SALESDOCUMENTITEM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • I_SALESDOCUMENTITEM.MANDT == TVM3.MANDT
  • I_SALESDOCUMENTITEM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Material Group 4
  • Client
  • I_SALESDOCUMENTITEM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
  • I_SALESDOCUMENTITEM.MANDT == TVM4.MANDT
Material Group 5
  • Material Group 5
  • Client
  • I_SALESDOCUMENTITEM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
  • I_SALESDOCUMENTITEM.MANDT == TVM5.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_SALESDOCUMENTITEM.BASEUNIT == T006.MSEHI
  • I_SALESDOCUMENTITEM.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Plant (Own or External)
  • Client
  • Material Number
  • Product Number
  • I_SALESDOCUMENTITEM.BATCH == MCHA.CHARG
  • I_SALESDOCUMENTITEM.PLANT == MCHA.WERKS
  • I_SALESDOCUMENTITEM.MANDT == MCHA.MANDT
  • I_SALESDOCUMENTITEM.MATERIAL == MCHA.MATNR
  • I_SALESDOCUMENTITEM.PRODUCT == MCHA.MATNR
Business Area
  • Business Area
  • Client
  • I_SALESDOCUMENTITEM.BUSINESSAREA == TGSB.GSBER
  • I_SALESDOCUMENTITEM.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • I_SALESDOCUMENTITEM.CONTROLLINGAREA == TKA01.KOKRS
  • I_SALESDOCUMENTITEM.MANDT == TKA01.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • I_SALESDOCUMENTITEM.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • I_SALESDOCUMENTITEM.MANDT == TVKT.MANDT
Customer Group
  • Customer Group
  • Client
  • I_SALESDOCUMENTITEM.CUSTOMERGROUP == T151.KDGRP
  • I_SALESDOCUMENTITEM.MANDT == T151.MANDT
Customer Price Group
  • Customer Price Group
  • Client
  • I_SALESDOCUMENTITEM.CUSTOMERPRICEGROUP == T188.KONDA
  • I_SALESDOCUMENTITEM.MANDT == T188.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_SALESDOCUMENTITEM.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_SALESDOCUMENTITEM.MANDT == TPRIO.MANDT
Division
  • Division
  • Client
  • I_SALESDOCUMENTITEM.DIVISION == TSPA.SPART
  • I_SALESDOCUMENTITEM.MANDT == TSPA.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • I_SALESDOCUMENTITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • I_SALESDOCUMENTITEM.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • I_SALESDOCUMENTITEM.INCOTERMSVERSION == TINCV.INCOV
  • I_SALESDOCUMENTITEM.MANDT == TINCV.MANDT
Special Stock Indicator
  • Special Stock Indicator
  • Client
  • I_SALESDOCUMENTITEM.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
  • I_SALESDOCUMENTITEM.MANDT == T148.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • I_SALESDOCUMENTITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_SALESDOCUMENTITEM.MANDT == TVFS.MANDT
Volume unit
  • Volume unit
  • Client
  • I_SALESDOCUMENTITEM.ITEMVOLUMEUNIT == T006.MSEHI
  • I_SALESDOCUMENTITEM.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • I_SALESDOCUMENTITEM.ITEMWEIGHTUNIT == T006.MSEHI
  • I_SALESDOCUMENTITEM.MANDT == T006.MANDT
Material: order item
  • Client
  • Material Number
  • Product Number
  • I_SALESDOCUMENTITEM.MANDT == MARA.MANDT
  • I_SALESDOCUMENTITEM.MATERIAL == MARA.MATNR
  • I_SALESDOCUMENTITEM.PRODUCT == MARA.MATNR
Material Group
  • Product Group
  • Material Group
  • Client
  • I_SALESDOCUMENTITEM.PRODUCTGROUP == T023.MATKL
  • I_SALESDOCUMENTITEM.MATERIALGROUP == T023.MATKL
  • I_SALESDOCUMENTITEM.MANDT == T023.MANDT
Material Price Group
  • Material Price Group
  • Client
  • I_SALESDOCUMENTITEM.MATERIALPRICINGGROUP == T178.KONDM
  • I_SALESDOCUMENTITEM.MANDT == T178.MANDT
Reason for material substitution
  • Reason for material substitution
  • Client
  • I_SALESDOCUMENTITEM.MATERIALSUBSTITUTIONREASON == TVSU.SUGRD
  • I_SALESDOCUMENTITEM.MANDT == TVSU.MANDT
Account Assignment Group for Material
  • Account Assignment Group for Material
  • Client
  • I_SALESDOCUMENTITEM.MATLACCOUNTASSIGNMENTGROUP == TVKM.KTGRM
  • I_SALESDOCUMENTITEM.MANDT == TVKM.MANDT
Condition Unit
  • Condition Unit
  • Client
  • I_SALESDOCUMENTITEM.NETPRICEQUANTITYUNIT == T006.MSEHI
  • I_SALESDOCUMENTITEM.MANDT == T006.MANDT
Order Number
  • Order Number
  • Client
  • I_SALESDOCUMENTITEM.ORDERID == AUFK.AUFNR
  • I_SALESDOCUMENTITEM.MANDT == AUFK.MANDT
Sales unit
  • Sales unit
  • Client
  • I_SALESDOCUMENTITEM.ORDERQUANTITYUNIT == T006.MSEHI
  • I_SALESDOCUMENTITEM.MANDT == T006.MANDT
Material Entered
  • Client
  • Material Entered
  • I_SALESDOCUMENTITEM.MANDT == MARA.MANDT
  • I_SALESDOCUMENTITEM.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Payment Method
  • ?
  • Client
  • Payment Method
  • I_SALESDOCUMENTITEM.[column in domain "LAND1"] == T042Z.LAND1
  • I_SALESDOCUMENTITEM.MANDT == T042Z.MANDT
  • I_SALESDOCUMENTITEM.PAYMENTMETHOD == T042Z.ZLSCH
Instruction for Planning Delivery Schedule
  • Instruction for Planning Delivery Schedule
  • Client
  • I_SALESDOCUMENTITEM.PLNGDELIVSCHEDINSTRN == TVZP.PLAVO
  • I_SALESDOCUMENTITEM.MANDT == TVZP.MANDT
Pricing Reference Material
  • Client
  • Pricing Reference Material
  • I_SALESDOCUMENTITEM.MANDT == MARA.MANDT
  • I_SALESDOCUMENTITEM.PRICINGREFERENCEMATERIAL == MARA.MATNR
Checking Group for Availability Check
  • Checking Group for Availability Check
  • Client
  • I_SALESDOCUMENTITEM.PRODAVAILABILITYCHECKGROUP == TMVF.MTVFP
  • I_SALESDOCUMENTITEM.MANDT == TMVF.MANDT
Material: order item
  • Client
  • Material Number
  • Product Number
  • I_SALESDOCUMENTITEM.MANDT == MARA.MANDT
  • I_SALESDOCUMENTITEM.MATERIAL == MARA.MATNR
  • I_SALESDOCUMENTITEM.PRODUCT == MARA.MATNR
Product Catalog
  • Product catalog number
  • Client
  • I_SALESDOCUMENTITEM.PRODUCTCATALOG == WWMI.WMINR
  • I_SALESDOCUMENTITEM.MANDT == WWMI.MANDT
Fashion Collection
  • Season
  • Fashion Collection
  • Season Year
  • Client
Product Group
  • Product Group
  • Material Group
  • Client
  • I_SALESDOCUMENTITEM.PRODUCTGROUP == T023.MATKL
  • I_SALESDOCUMENTITEM.MATERIALGROUP == T023.MATKL
  • I_SALESDOCUMENTITEM.MANDT == T023.MANDT
Product hierarchy: order item
  • Product hierarchy
  • Client
  • I_SALESDOCUMENTITEM.PRODUCTHIERARCHYNODE == T179.PRODH
  • I_SALESDOCUMENTITEM.MANDT == T179.MANDT
Season
  • Season
  • Season Year
  • Client
  • I_SALESDOCUMENTITEM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_SALESDOCUMENTITEM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_SALESDOCUMENTITEM.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • I_SALESDOCUMENTITEM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_SALESDOCUMENTITEM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_SALESDOCUMENTITEM.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Season
  • Fashion Theme
  • Fashion Collection
  • Season Year
  • Client
  • I_SALESDOCUMENTITEM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_SALESDOCUMENTITEM.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_SALESDOCUMENTITEM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_SALESDOCUMENTITEM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_SALESDOCUMENTITEM.MANDT == FSH_THEMES.MANDT
Results Analysis Key
  • Results Analysis Key
  • Client
  • I_SALESDOCUMENTITEM.RESULTANALYSISINTERNALID == TKKAA.ABGSL
  • I_SALESDOCUMENTITEM.MANDT == TKKAA.MANDT
Retail promotion
  • Promotion
  • Client
  • I_SALESDOCUMENTITEM.RETAILPROMOTION == WAKH.AKTNR
  • I_SALESDOCUMENTITEM.MANDT == WAKH.MANDT
Return Reason
  • Client
  • Return Reason
Returns Refund Code
  • Returns Refund Code
  • Client
Route
  • Client
  • Route
  • I_SALESDOCUMENTITEM.MANDT == TVRO.MANDT
  • I_SALESDOCUMENTITEM.ROUTE == TVRO.ROUTE
Assignment Cancellation Procedure/Cancellation Rule
  • Client
  • Assignment Cancellation Procedure/Cancellation Rule
  • I_SALESDOCUMENTITEM.MANDT == TVKS.MANDT
  • I_SALESDOCUMENTITEM.SALESCONTRACTCANCLNPROCEDURE == TVKS.VKUESCH
Reason for Cancellation of Contract
  • Client
  • Reason for Cancellation of Contract
  • I_SALESDOCUMENTITEM.MANDT == TVKG.MANDT
  • I_SALESDOCUMENTITEM.SALESCONTRACTCANCLNREASON == TVKG.KUEGRU
Action at end of contract
  • Action at end of contract
  • Client
  • I_SALESDOCUMENTITEM.SALESCONTRACTFOLLOWUPACTION == TVAS.AKTVT
  • I_SALESDOCUMENTITEM.MANDT == TVAS.MANDT
Validity Period Category of Contract
  • Validity Period Category of Contract
  • Client
  • I_SALESDOCUMENTITEM.SALESCONTRACTVALIDITYPERDCAT == TVLZ.VLAUFK
  • I_SALESDOCUMENTITEM.MANDT == TVLZ.MANDT
Sales Deal
  • Sales Deal
  • Client
  • I_SALESDOCUMENTITEM.SALESDEAL == KONA.KNUMA
  • I_SALESDOCUMENTITEM.MANDT == KONA.MANDT
Sales District
  • Sales District
  • Client
  • I_SALESDOCUMENTITEM.SALESDISTRICT == T171.BZIRK
  • I_SALESDOCUMENTITEM.MANDT == T171.MANDT
Sales document item category
  • Sales document item category
  • Client
  • I_SALESDOCUMENTITEM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • I_SALESDOCUMENTITEM.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_SALESDOCUMENTITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_SALESDOCUMENTITEM.MANDT == TVAG.MANDT
Sales Promotion
  • Sales Promotion
  • Client
  • I_SALESDOCUMENTITEM.SALESPROMOTION == KONA.KNUMA
  • I_SALESDOCUMENTITEM.MANDT == KONA.MANDT
Service Document Type
  • Client
  • Service Document Type
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_SALESDOCUMENTITEM.SHIPPINGPOINT == TVST.VSTEL
  • I_SALESDOCUMENTITEM.MANDT == TVST.MANDT
Shipping Type
  • Client
  • Shipping Type
  • I_SALESDOCUMENTITEM.MANDT == T173.MANDT
  • I_SALESDOCUMENTITEM.SHIPPINGTYPE == T173.VSART
Storage location
  • Storage location
  • Plant (Own or External)
  • Client
  • I_SALESDOCUMENTITEM.STORAGELOCATION == T001L.LGORT
  • I_SALESDOCUMENTITEM.PLANT == T001L.WERKS
  • I_SALESDOCUMENTITEM.MANDT == T001L.MANDT
Target Quantity UoM
  • Target Quantity UoM
  • Client
  • I_SALESDOCUMENTITEM.TARGETQUANTITYUNIT == T006.MSEHI
  • I_SALESDOCUMENTITEM.MANDT == T006.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_SALESDOCUMENTITEM.MANDT == TCURC.MANDT
  • I_SALESDOCUMENTITEM.TRANSACTIONCURRENCY == TCURC.WAERS