SAP table AKKP (Documentary Payment Guarantee: Fin.Doc.Master - Header Data)

SAP table AKKP has 2 primary key fields being MANDT,LCNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
LCNUM Financial doc. processing: Internal financial doc. number CHAR 10 0 LCNUM
REFLCNUM Financial document processing: Search term CHAR 40 0 AKKSUCH
AKKEI Financial document processing: Export / Import CHAR 1 0 AKKEI
1 Import: Financial doc. for MM business transactions
2 Export: Financial doc. for SD business transactions
BUKRS Company Code CHAR 4 0 T001 BUKRS
AKART Financial Document Processing: Financial Document Type CHAR 2 0 T607I AKART
AKKTP Financial document processing: Financial document category CHAR 1 0 AKKTP
C Irrevocable confirmed
O Others
R Revocable
U Irrevocable unconfirmed
KUNNR Customer Number CHAR 10 0 KNB1 KUNNR
ELIFN Vendor's account number CHAR 10 0 LFA1 ELIFN
CADNR Address Number CHAR 10 0 ADRC AD_ADDRNUM
INTER International address version ID CHAR 1 0 TSAV INTER
WAEMP Customer Number CHAR 10 0 KNA1 KUNNR
CADNR_WE Address Number CHAR 10 0 ADRC AD_ADDRNUM
AKKST Financial document processing: Status CHAR 1 0 AKKST
A Document has been created
B Document is incomplete - Further papers required
C Notification that document has been sent
D Document is available and can be used
E Change in document has been submitted
F Document has been cancelled
Z Document is closed and can be reorganized
TSSTA Financial document determination: Time stamp for status NUMC 14 0 STTMS
TZSTA Financial document processing: Status of time zone CHAR 6 0 TTZZ STTMZ
KOMMA Text, 40 Characters Long CHAR 40 0 TEXT40
TSSTB Financial document determination: Time stamp for status NUMC 14 0 STTMS
TZSTB Financial document processing: Status of time zone CHAR 6 0 TTZZ STTMZ
KOMMB Text, 40 Characters Long CHAR 40 0 TEXT40
TSSTC Financial document determination: Time stamp for status NUMC 14 0 STTMS
TZSTC Financial document processing: Status of time zone CHAR 6 0 TTZZ STTMZ
KOMMC Text, 40 Characters Long CHAR 40 0 TEXT40
TSSTD Financial document determination: Time stamp for status NUMC 14 0 STTMS
TZSTD Financial document processing: Status of time zone CHAR 6 0 TTZZ STTMZ
KOMMD Text, 40 Characters Long CHAR 40 0 TEXT40
TSSTE Financial document determination: Time stamp for status NUMC 14 0 STTMS
TZSTE Financial document processing: Status of time zone CHAR 6 0 TTZZ STTMZ
KOMME Text, 40 Characters Long CHAR 40 0 TEXT40
AENDGRUND Financial Document Processing: Reason for Change CHAR 1 0 AENDGRUND
TSSTF Financial document determination: Time stamp for status NUMC 14 0 STTMS
TZSTF Financial document processing: Status of time zone CHAR 6 0 TTZZ STTMZ
KOMMF Text, 40 Characters Long CHAR 40 0 TEXT40
TSSTZ Financial document determination: Time stamp for status NUMC 14 0 STTMS
TZSTZ Financial document processing: Status of time zone CHAR 6 0 TTZZ STTMZ
KOMMZ Text, 40 Characters Long CHAR 40 0 TEXT40
AADAT Financial document processing: Request date NUMC 14 0 AADAT
AATZO Financial document processing: Time zone - Request Date CHAR 6 0 TTZZ AATZO
AIDAT Financial document processing: Opening date NUMC 14 0 AIDAT
AITZO Financial document processing: Time zone - Opening date CHAR 6 0 TTZZ AITZO
AJDAT Financial Document Processing: Date of Receipt NUMC 14 0 AJDAT
AJTZO Financial document processing: Time zone - Date of receipt CHAR 6 0 TTZZ AJTZO
AXDAT Financial document processing: Validity end date NUMC 14 0 AXDAT
AXTZO Financial document processing: Time zone - Validity end date CHAR 6 0 TTZZ AXTZO
AXLND Country/Region Key CHAR 3 0 T005 LAND1
AXORT City Code CHAR 4 0 CITYC
AXREG Region (State, Province, County) CHAR 3 0 T005S REGIO
AYDAT Financial document processing: Latest shipping date NUMC 14 0 AYDAT
AYTZO Financial doc. processing: Time zone - Latest shipping date CHAR 6 0 TTZZ AYTZO
AODAT Financial doc. procg: Latest date of shipped bill of lading NUMC 14 0 AODAT
AOTZO Fin.doc.procg: Time zone-Latest date-Shipped bill of lading CHAR 6 0 TTZZ AOTZO
AHDAT Financial doc. processing: Date when docs presented to bank NUMC 14 0 AHDAT
AHTZO Financial doc. processing : Time zone - Presentation to bank CHAR 6 0 TTZZ AHTZO
ANYTG Financial doc. procg: No. of days for submitt. docs to bank NUMC 3 0 ANYTG
WRTAK Financial document processing: Financial document value CURR 15 2 WRTAK
WAERS Currency key for letter-of-credit procg in foreign trade CUKY 5 0 TCURC AKWAE
IAPRZ Financial doc. proc.: Consumption factor of letter of credit DEC 5 2 IAPRZ
EUPRZ Financial document processing: Allowed overdraft percentage DEC 5 2 EUPRZ
ZTERM Terms of payment key CHAR 4 0 DZTERM
INCO1 Incoterms (Part 1) CHAR 3 0 TINC INCO1
INCO2 Incoterms (Part 2) CHAR 28 0 INCO2
AUTLF Complete Delivery Defined for Each Sales Order? CHAR 1 0 AUTLF
ATRSI Financial document processing: Reload indicator CHAR 1 0 ATRSI
AMINQ Financial document processing: Minimum quantity QUAN 13 3 AMINQ
AMAXQ Financial document processing: Maximum quantity QUAN 13 3 AMAXQ
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT_TS Date on which record has been added (time stamp) NUMC 14 0 ERDAT_TS
ERDAT_TZ Date on which record has been added (time zone) CHAR 6 0 TTZZ ERDAT_TZ
VOLL Financial document processing: Document completion flag CHAR 1 0 VOLL
AKKCONFIRM Financial Doc. Processing: MAIL User of Person Confirming FD CHAR 12 0 USR02 AKKCONFIRM
UNPRZ Allowed shortfall percentage rate for financial documents DEC 5 2 UNPRZ
KUNFS Financial doc. processing: Field sel. cust./vendor numbers CHAR 1 0 KUNFS
KUNCK Financial doc. processing: Check customer / vendor numbers CHAR 1 0 KUNCK
AADFS Financial document processing: Fld selection - Request date CHAR 1 0 AADFS
AADCK Financial document processing: Check request date CHAR 1 0 AADCK
AIDFS Financial Document Processing: Fld Selection - Opening Date CHAR 1 0 AIDFS
AIDCK Financial document processing: Check creation date CHAR 1 0 AIDCK
AEDFS Financial Doc. Processing: Fld Selection - Date of Receipt CHAR 1 0 AEDFS
AEDCK Financial document processing: Check date of receipt CHAR 1 0 AEDCK
AXDFS Financial doc. procg: Field selection - Validity end date CHAR 1 0 AXDFS
AXDCK Financial document processing: Check validity end date CHAR 1 0 AXDCK
AVDFS Financial doc. procg: Field selection - Latest shipping date CHAR 1 0 AVDFS
AVDCK financial document processing: Check latest shipping date CHAR 1 0 AVDCK
ALDFS Financial doc.procg: Fld selection - Date of bill of lading CHAR 1 0 ALDFS
ALDCK Financial doc. procg: Check date of shipped bill of lading CHAR 1 0 ALDCK
ADDFS Financial document processing: Fld ctrl - Submission of doc. CHAR 1 0 ADDFS
ADDCK Financial document processing: Check submission of document CHAR 1 0 ADDCK
AWEFS Financial doc. procg: Field selection - Financial doc. value CHAR 1 0 AWEFS
AWECK Financial doc. processing: Check financial document value CHAR 1 0 AWECK
IAPFS Financial document processing: Field selection consumption CHAR 1 0 IAPFS
EUPFS Financial document processing: Fld selection for overdraft % CHAR 1 0 EUPFS
EUPCK Financial document processing: Check percentage of overdraft CHAR 1 0 EUPCK
TEZFS Financial doc. proc.: Field selection terms of payment CHAR 1 0 TEZFS
TEZCK Financial doc. processing: Check terms of payment CHAR 1 0 TEZCK
INCFS Financial document processing: Incoterms field selection CHAR 1 0 INCFS
INCCK Financial doc. processing: Check INCOTerms CHAR 1 0 INCCK
AUTFS Financial doc. procg: Field selection for partial dlv. ind. CHAR 1 0 AUTFS
AUTCK Financial document processing: Check partial delivery ind. CHAR 1 0 AUTCH
ATRFS Financial Document Processing: Field Selection - Reload Ind. CHAR 1 0 ATRFS
ATRCK Financial doc. procg: Check reload indicator CHAR 1 0 ATRCK
AMIFS Financial document processing: Fld selection - Min./Max.qty CHAR 1 0 AMIFS
AMICK Financial document processing: Check minimum/maximum qty CHAR 1 0 AMICK
TXTGR Text Determination Procedure CHAR 2 0 TTXG TXTGR
FDLANGU Financial document processing: Default document language LANG 1 0 FDLANGU
REFFS Financial document processing: Field selection search term CHAR 1 0 SUCHFS
INDGRUND Financial document processing: Indicator for change reason CHAR 1 0 T607G INDGRUND
DOKFREI Financial document processing: Free entry of docs possible CHAR 1 0 DOKFREI
FTCCD Derivation of company code from org. unit for Foreign Trade CHAR 1 0 FTCCD
Derivation from the delivering plant of the document item
A Derivation from the sales organization of the document
DDZCK Existence check control of payment terms for financial docs CHAR 1 0 DDZCK
DDICK Existence check control of Incoterms for financial documents CHAR 1 0 DDICK
UNPFS Financial document processing: Field selection shortfall PR CHAR 1 0 UNPFS
UNPCK Financial document processing: Shortfall percentage rate CHAR 1 0 UNPCK
INCOV Incoterms Version CHAR 4 0 TINCV INCOV
INCO2_L Incoterms Location 1 CHAR 70 0 INCO2_L
INCO3_L Incoterms Location 2 CHAR 70 0 INCO3_L

AKKP foreign key relationships

Table Field Check Table Check Field
0 AKKP AATZO TTZZ Time zones TZONE
1 AKKP AHTZO TTZZ Time zones TZONE
0 AKKP AITZO TTZZ Time zones TZONE
1 AKKP AJTZO TTZZ Time zones TZONE
0 AKKP AKART T607I Documentary Payments: Financial Document Control MANDT
0 AKKP AKART T607I Documentary Payments: Financial Document Control AKKTP
1 AKKP AKKCONFIRM USR02 Logon Data (Kernel-Side Use) BNAME
0 AKKP AOTZO TTZZ Time zones TZONE
1 AKKP AXLND T005 Countries MANDT
1 AKKP AXLND T005 Countries LAND1
0 AKKP AXREG T005S Taxes: Region (Province) Key LAND1
1 AKKP AXTZO TTZZ Time zones TZONE
0 AKKP AYTZO TTZZ Time zones TZONE
1 AKKP BUKRS T001 Company Codes BUKRS
0 AKKP CADNR ADRC Addresses (Business Address Services) DATE_FROM
0 AKKP CADNR ADRC Addresses (Business Address Services) NATION
1 AKKP CADNR_WE ADRC Addresses (Business Address Services) DATE_FROM
1 AKKP CADNR_WE ADRC Addresses (Business Address Services) NATION
0 AKKP ELIFN LFA1 Supplier Master (General Section) MANDT
0 AKKP ELIFN LFA1 Supplier Master (General Section) LIFNR
1 AKKP ERDAT_TZ TTZZ Time zones TZONE
0 AKKP INCO1 TINC Customers: Incoterms INCO1
1 AKKP INCOV TINCV Incoterms Versions MANDT
1 AKKP INCOV TINCV Incoterms Versions INCOV
0 AKKP INDGRUND T607G Documentary Payments: Reasons for Change MANDT
0 AKKP INDGRUND T607G Documentary Payments: Reasons for Change AENDGRUND
1 AKKP INTER TSAV Address Versions (Business Address Services) (Obsolete) NATIO
0 AKKP KUNNR KNB1 Customer Master (Company Code) MANDT
0 AKKP KUNNR KNB1 Customer Master (Company Code) KUNNR
0 AKKP KUNNR KNB1 Customer Master (Company Code) BUKRS
1 AKKP MANDT T000 Clients MANDT
0 AKKP MEINS T006 Units of Measurement MANDT
0 AKKP MEINS T006 Units of Measurement MSEHI
1 AKKP TXTGR TTXG Text Processing: Text ID Groups MANDT
0 AKKP TZSTA TTZZ Time zones TZONE
1 AKKP TZSTB TTZZ Time zones TZONE
0 AKKP TZSTC TTZZ Time zones TZONE
1 AKKP TZSTD TTZZ Time zones TZONE
0 AKKP TZSTE TTZZ Time zones TZONE
1 AKKP TZSTF TTZZ Time zones TZONE
0 AKKP TZSTZ TTZZ Time zones TZONE
1 AKKP WAEMP KNA1 General Data in Customer Master MANDT
1 AKKP WAEMP KNA1 General Data in Customer Master KUNNR
0 AKKP WAERS TCURC Currency Codes MANDT
0 AKKP WAERS TCURC Currency Codes WAERS