FAC_AUDIT_Z3_SALESHDRITM

Sales Document Header & Items | view: FACZ3SDHDRITM | TRAN | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: VBAPVBKDVEDAVBAKVBAKVBAPVBKDVEDATINCTINCTTVAPTVAPTTVAKTVAKTFINSC_LD_CMPFINSC_PERIOD
Column Name Description
SalesDocument FK Sales Document
SalesDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TaxAmount Tax Amount in Document Currency
TotalNetAmount Net Value of the Sales Order in Document Currency
NetAmount Net Value of the Order Item 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
Column Name Description
📏 Base Unit of Measure (BaseUnit):
ConfdDeliveryQtyInBaseUnit Cumulative Confirmed Quantity in Base Unit
Column Name Description
ServicesRenderedDate Date on which services are rendered
SalesDocumentDate Document Date (Date Received/Sent)
CreationDate Date on which the record was created
PricingDate Date for Pricing and Exchange Rate
Column Name Description
SDDocumentCategory SD Document Category Show values
StatisticalValueControl Statistical Values Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
Column Name Description Domain name
SystemClient Client
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
SDDocumentCategoryName SD Document Category Description DDTEXT
SalesDocumentItemCategoryName Description TEXT20
IncotermsClassificationName Description TEXT30
IncotermsTransferLocation Incoterms (Part 2) INCO2
SalesDocumentType Sales Document Type
SalesDocumentTypeName Sales Document Type Description TEXT20
PurchaseOrderByCustomer Customer Reference BSTKD
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CustomerPaymentTerms Terms of payment key ZTERM
SalesDocumentItemText Short text for sales order item TEXT40
ProfitCenter Profit Center PRCTR
Plant Plant (Own or External) WERKS
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
ReferenceSDDocCategoryName SD Document Category Description
CustomerTaxClassification1 Alternative Tax Classification TAXKD
CustomerTaxClassification2 Tax Classification 2 for Customer TAXKD
CustomerTaxClassification3 Tax Classification 3 for Customer TAXKD
CustomerTaxClassification4 Tax Classification 4 for Customer TAXKD
CustomerTaxClassification5 Tax Classification 5 for Customer TAXKD
CustomerTaxClassification6 Tax Classification 6 for Customer TAXKD
CustomerTaxClassification7 Tax Classification 7 for Customer TAXKD
CustomerTaxClassification8 Tax Classification 8 for Customer TAXKD
CustomerTaxClassification9 Tax Classification 9 for Customer TAXKD
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
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.BASEUNIT == T006.MSEHI
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Plant (Own or External)
  • Client
  • Material Number
  • FAC_AUDIT_Z3_SALESHDRITM.BATCH == MCHA.CHARG
  • FAC_AUDIT_Z3_SALESHDRITM.PLANT == MCHA.WERKS
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == MCHA.MANDT
  • FAC_AUDIT_Z3_SALESHDRITM.MATERIAL == MCHA.MATNR
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.BILLINGCOMPANYCODE == T001.BUKRS
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.BUSINESSAREA == TGSB.GSBER
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == TGSB.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.FISCALYEARVARIANT == T009.PERIV
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == T009.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == TINC.MANDT
Material: order item
  • Client
  • Material Number
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == MARA.MANDT
  • FAC_AUDIT_Z3_SALESHDRITM.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == T023.MANDT
  • FAC_AUDIT_Z3_SALESHDRITM.MATERIALGROUP == T023.MATKL
Sales unit
  • Sales unit
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.ORDERQUANTITYUNIT == T006.MSEHI
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == T006.MANDT
Product hierarchy: order item
  • Product hierarchy
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.PRODUCTHIERARCHYNODE == T179.PRODH
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == T179.MANDT
Sales document item category
  • Sales document item category
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == TVPT.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.SALESORGANIZATION == TVKO.VKORG
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == TVKO.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.SDDOCUMENTREASON == TVAU.AUGRU
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == TVAU.MANDT
Pricing Procedure in Pricing
  • Pricing Procedure in Pricing
  • ?
  • ?
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.SDPRICINGPROCEDURE == T683.KALSM
  • FAC_AUDIT_Z3_SALESHDRITM.[column in domain "KAPPL"] == T683.KAPPL
  • FAC_AUDIT_Z3_SALESHDRITM.[column in domain "KVEWE"] == T683.KVEWE
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == T683.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.SOLDTOPARTY == KNA1.KUNNR
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == KNA1.MANDT
Storage location
  • Storage location
  • Plant (Own or External)
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.STORAGELOCATION == T001L.LGORT
  • FAC_AUDIT_Z3_SALESHDRITM.PLANT == T001L.WERKS
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == T001L.MANDT
Tax Departure Country/Region
  • Tax Departure Country/Region
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.TAXDEPARTURECOUNTRY == T005.LAND1
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == T005.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.TRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == TCURC.MANDT
Tax Destination Country/Region
  • Tax Destination Country/Region
  • Client
  • FAC_AUDIT_Z3_SALESHDRITM.VATREGISTRATIONCOUNTRY == T005.LAND1
  • FAC_AUDIT_Z3_SALESHDRITM.MANDT == T005.MANDT