MCJHTFK SAP (IS-PAM: Billing header, LIS communication structure) Structure details
Description: IS-PAM: Billing header, LIS communication structure
Structure field list including key, data, relationships and ABAP select examples
MCJHTFK is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "IS-PAM: Billing header, LIS communication structure" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MCJHTFK TYPE MCJHTFK.
The MCJHTFK table consists of various fields, each holding specific information or linking keys about IS-PAM: Billing header, LIS communication structure data available in SAP. These include MANDT (Client), VBELN (IS-M/AM: Billing Document), ERFUSER (Created By), ERFDATE (Created On).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MCJHTFK structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VBELN | IS-M/AM: Billing Document | JJBELNR | CHAR | 10 | Assigned to domain | ALPHA | JJBELNR | JHB | MJHF |
ERFUSER | Created By | ERFUSER | CHAR | 12 | USNAM | ||||
ERFDATE | Created On | ERFDATE | DATS | 8 | DATUM | ||||
ERFTIME | Time Created | ERFTIME | TIMS | 6 | UZEIT | ||||
AENUSER | Last Changed By | AENUSER | CHAR | 12 | USNAM | ||||
AENDATE | Date of Last Change | AENDATE | DATS | 8 | DATUM | ||||
AENTIME | Time of Last Change | AENTIME | TIMS | 6 | UZEIT | ||||
SFAKN | IS-M: Reversal Reference | JJBELNRSV | CHAR | 10 | JHTFK | ALPHA | JJBELNR | ||
XEZER | Indicator: Is there collection authorization ? | XEZER | CHAR | 1 | XFELD | ||||
BANKS | Bank country key | BANKS | CHAR | 3 | T005 | LAND1 | BKL | ||
BANKN | Bank account number | BANKN | CHAR | 18 | BANKN | ||||
BANKL | Bank number | BANKL | CHAR | 15 | BANKL | BLZ | |||
BKONT | Bank Control Key | BKONT | CHAR | 2 | BKONT | ||||
BVTYP | Partner Bank Type | BVTYP | CHAR | 4 | BVTYP | ||||
FKART | IS-M/AM: Billing/Settlement Document Type | FKART_PAM | CHAR | 4 | TJH05 | FKART_PAM | MJHFKART | ||
FKDAT | IS-M: Actual Billing/Settlement Date | JHFKDAT | DATS | 8 | DATUM | ||||
FKTYP | IS-M/AM: Billing Category | JHFKTYP | CHAR | 1 | TJH19 | JHFKTYP | |||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
LAND1 | Country of Destination | LLAND | CHAR | 3 | T005 | LAND1 | VLL | ||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
TAXK1 | IS-M: Tax classification for business partner | JTACLGP1 | CHAR | 1 | JTACLGP | ||||
TAXK2 | IS-M: Tax classification 2 for business partner | JTACLGP2 | CHAR | 1 | JTACLGP | ||||
TAXK3 | IS-M: Tax classification 3 for business partner | JTACLGP3 | CHAR | 1 | JTACLGP | ||||
TAXK4 | IS-M: Tax classification 4 for business partner | JTACLGP4 | CHAR | 1 | JTACLGP | ||||
TAXK5 | IS-M: Tax classification 5 for business partner | JTACLGP5 | CHAR | 1 | JTACLGP | ||||
TAXK6 | IS-M: Tax classification 6 for business partner | JTACLGP6 | CHAR | 1 | JTACLGP | ||||
TAXK7 | IS-M: Tax classification 7 for business partner | JTACLGP7 | CHAR | 1 | JTACLGP | ||||
TAXK8 | IS-M: Tax classification 8 for business partner | JTACLGP8 | CHAR | 1 | JTACLGP | ||||
TAXK9 | IS-M: Tax classification 9 for business partner | JTACLGP9 | CHAR | 1 | JTACLGP | ||||
UEBAR | IS-M: Transfer type | JHUEBART | CHAR | 1 | TJH41 | JHUEBART | |||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
VALTG | Additional value days | VALTG | NUMC | 2 | TAGE2 | ||||
VALDT | Fixed value date | VALDT | DATS | 8 | DATUM | ||||
ZLSCH | Payment Method | SCHZW_BSEG | CHAR | 1 | T042Z | ZLSCH | |||
MSCHL | Dunning key | MSCHL | CHAR | 1 | T040 | MSCHL | |||
MANSP | Dunning block | MANSP | CHAR | 1 | T040S | MANSP | |||
NATIO | International address version ID | INTER | CHAR | 1 | TSAV | NATION | |||
ADRNR | IS-M: One-Time Customer Address | ISM_CPDADDRNUM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
CCINS | Payment cards: Card type | CCINS | CHAR | 4 | TVCIN | CCINS | |||
CCNUM | Payment cards: Card number | CCNUM | CHAR | 25 | VCNUM | CCNUM | |||
DATBI | Payment Cards: Valid To | DATBI_CC | DATS | 8 | DATUM | ||||
CCNAME | Payment cards: Name of cardholder | CCNAME | CHAR | 40 | TEXT40 | ||||
CCAUA | Payment cards: Authorization type | CCAUA | CHAR | 1 | CCAUA | ||||
CCACT | G/L Account Number for Payment Card Receivables | CCACT | CHAR | 10 | SKA1 | ALPHA | SAKNR | ||
AUDAT_CC | Payment cards: Authorization date | AUDAT_CC | DATS | 8 | DATUM | ||||
AUTIM | Payment cards: Authorization time | AUTIM | TIMS | 6 | UZEIT | ||||
CCALL | Payment cards: Status when external system is called? | CCALL | CHAR | 1 | CCALL | ||||
REACT | Payment cards: Response to authorization checks | REACT_SD | CHAR | 1 | REACT_SD | ||||
AUTWR | Payment cards: Authorized amount | AUTWR | CURR | 15(2) | WERTV8 | ||||
CCWAE | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
AUNUM | Payment cards: Authorization number | AUNUM | CHAR | 10 | CHAR10 | ||||
AUTRA | Payment cards: Authoriz. reference code of clearing house | AUTRA | CHAR | 15 | CHAR15 | ||||
SETTL | Payment cards: Settlement carried out | SETTL | CHAR | 1 | XFELD | ||||
CGUID | GUID of a Payment Card | CARD_GUID | RAW | 16 | SYSUUID | ||||
ENCTP | Type of Encryption | CCSECA_ENCTYPE | CHAR | 1 | CCSECA_ENCTYPE | ||||
IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
STTYP | IS-M: Reversal Type | STORNOTYP | CHAR | 1 | STORNOTYP | ||||
MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
EXPKZ | Export indicator | EXPKZ | CHAR | 1 | EXPKZ | ||||
EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | EIKP | EXNUM | |||
POPER | Posting period | POPER | NUMC | 3 | POPER | POPR | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
MONAT | Fiscal Period | MONAT | NUMC | 2 | MONAT | ||||
XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
UNRFI | IS-M: Field is not used | JHUNRFI | CHAR | 10 | CHAR10 | ||||
KURRF | Exchange rate for FI postings | KURRF | DEC | 9(5) | KURRF | ||||
CPKUR | ID:Exchange rate setting (no new rate determ.in bill.doc.) | CPKUR | CHAR | 1 | CPKUR | ||||
BRTWK | IS-M: Gross Value in Document Currency (Header) | JHBRTWRK | CURR | 15(2) | WERTV8 | ||||
NETWK | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
MWSBK | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
STAFO | IS-M: Update group for statistics update | JHSTAFO | CHAR | 6 | TMCB | ALPHA | STAFO | MCF | |
RFBSK | IS-M/AM: Status for Transfer to Accounting / HR | JHRFBSK | CHAR | 1 | JHRFBSK | ||||
STAFI | IS-M: Status of the Financial Accounting Document | ISMSTAFI | CHAR | 1 | ISMSTAFI | ||||
MABER | Dunning Area | MABER | CHAR | 2 | T047M | MABER | |||
VBTYP | IS-M/AM: Sales Document Category | ISPVBTYP | CHAR | 1 | ISPVBTYP | ||||
PERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | TFACD | WFCID | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | TVKT | KTGRD | |||
PLTYP | Price list type | PLTYP | CHAR | 2 | T189 | PLTYP | VPL | ||
KUNRG | IS-M: Payer | REGULIERER | CHAR | 10 | JGTGPNR | ALPHA | GPNR | MJG0 | |
KUNRE | IS-M: Business Partner - Bill-To Party | GPNR_RECH | CHAR | 10 | JGTGPNR | ALPHA | GPNR | KUN | |
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
STCEG_H | Origin of sales tax ID number | STCEG_H | CHAR | 1 | STCEG_H | ||||
STCEG_L | Country of Sales Tax ID Number | STCEG_L | CHAR | 3 | T005 | LAND1 | LND | ||
LANDTX | Tax departure country | LANDTX | CHAR | 3 | Assigned to domain | LAND1 | LND | ||
COUNC | County Code | COUNC | CHAR | 3 | Assigned to domain | COUNC | |||
CITYC | City Code | CITYC | CHAR | 4 | Assigned to domain | CITYC | |||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | Assigned to domain | TXJCD | TXJ | ||
ZUKRI | Combination criteria in the billing document | DZUKRI | CHAR | 40 | CHAR40 | ||||
LOGSYS | Logical system | LOGSYS | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
KREZE | IS-M: Payee | JHKREZE | CHAR | 10 | JGTGPNR | ALPHA | GPNR | ||
KRERS | IS-M: Invoicing Party | JHKRERS | CHAR | 10 | JGTGPNR | ALPHA | GPNR | ||
VNR | IS-M: Media Sales Agent Contract Number | JVMVVNR | CHAR | 10 | JJTVV | ALPHA | JVMVVNR | JJA | MJJV |
VTYP | IS-M: Contract Category for Media Sales Agent Contract | JVERMVTYP | CHAR | 1 | JVERMVTYP | ||||
KTGRV | IS-M: Account Assignment Group for Sales Agent Contract | KTGRV | CHAR | 2 | TJJAF | KTGRV | |||
UEBERLART | IS-M: Transfer Destination | UEBERLZIEL | CHAR | 1 | UEBERLZIEL | ||||
PERNR | IS-M: Personnel Number | JJPERNR | CHAR | 20 | JPERNR | ||||
VTNR | IS-M: Contract Number | ABS_VTNR | NUMC | 6 | JHTVKO | ABS_VTNR | JHW | MJHW | |
ABRGNR | IS-M/AM: Contract Settlement Number | ABRGNR | NUMC | 4 | JHTVAABK | ABRGNR | |||
FAB_PROZNT | IS-M: Percentage Rate for Receivables Charge-Off | FAB_PROZNT | DEC | 6(3) | DEC3_3 | ||||
SD_VBELN_VF | IS-M: SD Billing Number Referenced | JHVBELN_VF | CHAR | 10 | Assigned to domain | ALPHA | VBELN | VF | |
SD_NEWGL_STA | Order Status newGL Enhancement | ISM_SPLIT_CRITERION_STATUS | CHAR | 1 | ISM_SPLIT_CRITERION_STATUS | ||||
HWAER | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
STGKU | Customer Statistics Group | STGKU | CHAR | 1 | Assigned to domain | STGKU |
Key field | Non-key field |
How do I retrieve data from SAP structure MCJHTFK using ABAP code?
As MCJHTFK is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCJHTFK as there is no data to select.How to access SAP table MCJHTFK
Within an ECC or HANA version of SAP you can also view further information about MCJHTFK and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects