FAC_AUDIT_Z3_BILLHDRITEM

Billing Document Header & Item | view: FACZ3BLHDRITM | TRAN | Extraction: Not supported | Component: DART (Data Retention Tool)
Tables used: BKPFVBRKVBRPTVFKTVFKTTGSBTGSBTTKA01TINCTINCTT001WTVAPTVAPTTVKOTVKOTT000T683T683UFINSC_LD_CMPFINSC_PERIOD
Column Name Description
BillingDocument Billing Document
BillingDocumentItem Billing Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value in Document Currency
TaxAmount Tax Amount in Document Currency
NetAmount Net Value of Billing 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
BillingQuantity Actual billed quantity
MRPRequiredQuantityInBaseUnit Required quantity for mat.management in stockkeeping units
Column Name Description
BillingDocumentDate Billing Date
CreationDate Date on which the record was created
ServicesRenderedDate Date on which services are rendered
PricingDate Date for Pricing and Exchange Rate
Column Name Description
BillingDocumentIsCancelled Billing document is canceled Show values
SDDocumentCategory SD Document Category Show values
BillingDocumentCategory Billing Category Show values
VATRegistrationOrigin Origin of Sales Tax ID Number Show values
IsEUTriangularDeal Indicator: Triangular Deal Within the EU Show values
ReturnItemProcessingType Returns item Show values
StatisticalValueControl Statistical Values Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
Column Name Description Domain name
SystemClient Client
AccountingDocument Document Number of an Accounting Document BELNR
FiscalYear Fiscal Year GJAHR
FiscalPeriod Fiscal Period POPER
DocumentReferenceID Reference Document Number XBLNR1
BillingDocumentTypeName Description TEXT40
SDDocumentCategoryName SD Document Category Description DDTEXT
IncotermsClassificationName Description TEXT30
IncotermsTransferLocation Incoterms (Part 2) INCO2
PricingProcedureName Description TEXT30
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Object key AWKEY
PurchaseOrderByCustomer Customer Reference BSTKD
PricingDocument Number of the Document Condition KNUMV
SalesOrganizationName Sales Organization Description TEXT20
CustomerPaymentTerms Terms of payment key ZTERM
TaxDepartureCountry Tax Departure Country/Region LAND1
LogicalSystem Logical system LOGSYS
VATRegistration VAT Registration Number STCEG
VATRegistrationCountry Country/Region of Sales Tax ID Number LAND1
CreatedByUser Name of Person Responsible for Creating the Object USNAM
AccountingExchangeRate Exchange Rate for FI Postings KURRF_NOT_CONVERTED
CustomerTaxClassification1 Tax Classification 1 for Customer 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
SalesDocumentItemCategory Sales document item category PSTYV
SalesDocumentItemCategoryName Description TEXT20
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
SalesSDDocumentCategory SD Document Category
SalesSDDocumentCategoryName SD Document Category Description
BusinessArea Business Area GSBER
BusinessAreaName Business Area Description TEXT30
ControllingArea Controlling Area CACCD
ControllingAreaName Controlling Area Name TEXT25
BillingDocumentItemText Short text for sales order item TEXT40
MaterialGroup Material Group MATKL
Material Material Number MATNR
ProfitCenter Profit Center PRCTR
TaxJurisdiction Tax Jurisdiction TXJCD
Plant Plant WERKS
PlantName Plant Name TEXT30
Batch Batch Number CHARG
ProductHierarchyNode Product hierarchy PRODH
ProductTaxClassification1 Tax classification material TAXKM
ProductTaxClassification2 Tax Classification 2 for Material TAXKM
ProductTaxClassification3 Tax Classification 3 for Material TAXKM
ProductTaxClassification4 Tax Classification 4 for Material TAXKM
ProductTaxClassification5 Tax Classification 5 for Material TAXKM
ProductTaxClassification6 Tax Classification 6 for Material TAXKM
ProductTaxClassification7 Tax Classification 7 for Material TAXKM
ProductTaxClassification8 Tax Classification 8 for Material TAXKM
ProductTaxClassification9 Tax Classification 9 for Material TAXKM
StorageLocation Storage location LGORT
TaxCode Tax on sales/purchases code MWSKZ
ReferenceSDDocCategoryName SD Document Category Description
Master Data Relations Join Conditions
Billing Type
  • Billing Type
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.BILLINGDOCUMENTTYPE == TVFK.FKART
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == TVFK.MANDT
Company Code
  • Company Code
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.COMPANYCODE == T001.BUKRS
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == T001.MANDT
Destination Country/Region
  • Destination Country/Region
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.COUNTRY == T005.LAND1
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == T005.MANDT
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.FISCALYEARVARIANT == T009.PERIV
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == T009.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == TINC.MANDT
Company ID of Trading Partner
  • Company ID of Trading Partner
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.PARTNERCOMPANY == T880.RCOMP
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == T880.MANDT
Payer
  • Payer
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.PAYERPARTY == KNA1.KUNNR
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == KNA1.MANDT
Sales Organization
  • Sales Organization
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.SALESORGANIZATION == TVKO.VKORG
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == TVKO.MANDT
Pricing Procedure in Pricing
  • ?
  • Pricing Procedure in Pricing
  • ?
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.[column in domain "KVEWE"] == T683.KVEWE
  • FAC_AUDIT_Z3_BILLHDRITEM.SDPRICINGPROCEDURE == T683.KALSM
  • FAC_AUDIT_Z3_BILLHDRITEM.[column in domain "KAPPL"] == T683.KAPPL
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == T683.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.SOLDTOPARTY == KNA1.KUNNR
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == KNA1.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • FAC_AUDIT_Z3_BILLHDRITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • FAC_AUDIT_Z3_BILLHDRITEM.MANDT == TCURC.MANDT