Skip to Content

Questions about mapping SAP fields (GL data & Tax, customers, vendors & material master)

Dec 04, 2017 at 02:16 PM


avatar image

Hello everyone,

I'm performing a mapping to SAP fields of fields that the tax department wants to have to perform their checks. The questions asked beneath concern a collection of fields that we can't directly find or know how to determine them.

  1. Could a field named TaxAuthority be the same as TaxCountry(KNA1/LFA1.TXJCD) ? You have LFA1.STERN for example on supplier level but this contains tax authority which we have to get from somewhere else. Where to find tax authority for vendors & customers on a master level?
  2. What could be the meaning of a field accountID on customer & supplier masterlevel while we already have CustomerID (KNA1.KUNNR) and SupplierID (LFA1.LIFNR). Doesn't this just correspond to GL accountID ( SKA1.SAKNR/SKB1.SAKNR)?
  3. Any idea where to find a field that corresponds to "SelfBillingIndicator" in the customer and vendor masterdata?
  4. I'm pretty sure that the following field is customer TaxClassification: KNVI.TAXKD. I can't seem to find a corresponding field on vendor level.
  5. GL data: Anyone heard about fields in sap that gives information about Analysis type, analysis ID & analysis amount?
  6. GL data: where to find TaxBaseDescription which would give us more information about BSET.HWBAS and/or BSET.FWBAS?
  7. Can the T5UT* or T007 SAP tables be used as TAX master tables? We need Tax master data but i can't seem to find a dedicated table that contains tax master data. The following fields we need from tax master:
  • Tax Type ( i think T007A.MWART)
  • Tax Type description
  • Tax code ( i think T007A.MWSKZ)
  • Tax code description (i think T007S.TEXT1)
  • Effective date
  • Expiration date
  • Tax percentage (BSET.KBETR, but that's not master level)
  • Flat tax rate

Thanks in advance!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers