1. Home
  2. Resources
  3. SAP Tables
  4. DFKKREPZM - Recording Data for EC Sales List

SAP Table DFKKREPZM

Recording Data for EC Sales List

DFKKREPZM (Recording Data for EC Sales List) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link DFKKREPZM to other SAP tables.

DFKKREPZM table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
DATTY Reporting Date Type for EC Sales List DATTY_ZM_KK CHAR 1 0
1 Posting Date
2 Document Date
3 Due Date for Net Payment
9 Tax Reporting Date
DATUM Date for EC Sales List DATUM_ZM_KK DATS 8 0
GPART Business Partner Number GPART_KK CHAR 10 0
OPBEL Number of Contract Accts Rec. & Payable Doc. OPBEL_KK CHAR 12 0
LFDNR Sequence Number for Entries for EC Sales List LFDNR_ZM_KK NUMC 6 0
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
MWART Tax Type MWART CHAR 1 0
A Output tax
V Input tax
EGRKZ EU Code / Code EGRKZ CHAR 1 0
NULL Non-EU-Relevant
1 Delivery of Goods Within the EU
2 Services Within the EU
3 Subcontracting Within the EU
4 Output Tax for Services within the EU
5 Reverse Charge EU: Service with Tax with Zero Balance
6 HU: Triangular Deal with Country Outside the EU
7 As for value '1', but tax balance zero
8 As for value '3', but tax balance zero
9 Acquisition Tax or General Tax with Zero Balance
A Reverse Charge with Tax with Zero Balance
M Spain: EU Goods Delivery - After Tax-Exempt Import
H EU Goods Delivery - After Tax-Exempt Import by Fiscal Agent
B Non-EU-Relevant, No Check on Input Tax Acct/Output Tax Acct
LWAER Country currency WAERS_005 TCURC CUKY 5 0
HWAER Local Currency HWAER TCURC CUKY 5 0
LWBAS Tax Base Amount in National Currency LWBAS_ZM_KK CURR 13 2
HWBAS Tax Base Amount in Local Currency HWBAS CURR 13 2
LSTML Country for Tax Return LAND1_STML T005 CHAR 3 0
XBLNR Reference document number XBLNR_KK CHAR 16 0
BUDAT Posting Date in the Document BUDAT_KK DATS 8 0
BLDAT Document Date in Document BLDAT DATS 8 0
FAEDN Due date for net payment FAEDN_KK DATS 8 0
VATDATE Tax Reporting Date VATDATE_KK DATS 8 0
STBEL Number of Reversed Document STBEL_KK CHAR 12 0
STCEG VAT Registration Number STCEG CHAR 20 0
LAND1 Country Key LAND1 T005 CHAR 3 0
NAME1 Name field 1 (name1/last name) BU_NAME1 CHAR 40 0
GPRTP Type of Business Partner Reference GPRTP_KK CHAR 1 0
I Invoicing Service Provider
GPREF Reference to a Business Partner GPREF_KK CHAR 10 0

DFKKREPZM foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
DFKKREPZM BUKRS DFKKREPZM MANDT T001 Company Codes MANDT
DFKKREPZM BUKRS DFKKREPZM BUKRS T001 Company Codes BUKRS
DFKKREPZM HWAER DFKKREPZM MANDT TCURC Currency Codes MANDT
DFKKREPZM HWAER DFKKREPZM HWAER TCURC Currency Codes WAERS
DFKKREPZM LAND1 DFKKREPZM MANDT T005 Countries MANDT
DFKKREPZM LAND1 DFKKREPZM LAND1 T005 Countries LAND1
DFKKREPZM LSTML DFKKREPZM MANDT T005 Countries MANDT
DFKKREPZM LSTML DFKKREPZM LSTML T005 Countries LAND1
DFKKREPZM LWAER DFKKREPZM MANDT TCURC Currency Codes MANDT
DFKKREPZM LWAER DFKKREPZM LWAER TCURC Currency Codes WAERS