MC45W_0ITM SAP (Agency business extraction: Item data) Structure details

Dictionary Type: Structure
Description: Agency business extraction: Item data




ABAP Code to SELECT data from MC45W_0ITM
Related tables to MC45W_0ITM
Access table MC45W_0ITM




Structure field list including key, data, relationships and ABAP select examples

MC45W_0ITM 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 "Agency business extraction: Item data" 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_MC45W_0ITM TYPE MC45W_0ITM.

The MC45W_0ITM table consists of various fields, each holding specific information or linking keys about Agency business extraction: Item data data available in SAP. These include ABART (Settlement Type), BLDAT (Document Date in Document), BUKRS (Company Code), BUKRS_DEB (AB: Company Code - Customer).. 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 MC45W_0ITM 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
ROCANCELIndicator: Cancel Data Record ROCANCELCHAR1BOOLE
ABARTSettlement Type NAFKTCHAR1NAFKT
BLDATDocument Date in Document BLDATDATS8DATUM
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BUKRS_DEBAB: Company Code - Customer WLF_BUKRS_CUSTOMER_REGUCHAR4Assigned to domainBUKRSWLF_BUKRS_DEB
CMWAECurrency key of credit control area WAERS_CMCUKY5Assigned to domainWAERS
CORR_DOCUMENTAB: Adjustment Document WLF_CORR_DOCUMENTCHAR1WLF_CORR_DOCUMENT
CPDK_ADDRAgency Business: Address of One-Time Customer WLF_CPDK_ADDRCHAR10Assigned to domainALPHAAD_ADDRNUM
CPDL_ADDRAgency Business: Address - One-Time Vendor WLF_CPDL_ADDRCHAR10Assigned to domainALPHAAD_ADDRNUM
CTLPCCredit management: Risk category CTLPC_CMCHAR3Assigned to domainCTLPC_CM
DIEKZService Indicator (Foreign Payment) DIEKZCHAR1DIEKZ
EKGRPPurchasing Group EKGRPCHAR3Assigned to domainEKGRPEKG
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
ESTATUSAgency business: Application status WSTATECHAR4Assigned to domainWSTATE
FKSTOBilling document is cancelled FKSTOCHAR1XFELD
FKSTO_PARTPartial Reversal WLF_FKSTO_PARTCHAR1XFELD
FKSTO_PARTYCancelled Partner WLF_FKSTO_PARTYCHAR1WLF_FKSTO_PARTY
GSKTOAmount eligible for cash discount in document currency SKFBPCURR13(2) WERTV7
GSKTODAmount eligible for cash discount in document currency SKFBPCURR13(2) WERTV7
HWAERLocal Currency HWAERCUKY5Assigned to domainWAERS
IDOBJ_CUSTOMERAB: Identification Object Customer WLF_IDOBJ_CUSTOMERCHAR30WLF_IDOBJ
IDOBJ_TYPE_CAB: Identification Object Type Customer WLF_IDOBJ_TYPE_CUSTOMERCHAR4Assigned to domainWLF_IDOBJ_TYPE_CUSTOMER
IDOBJ_TYPE_VAB: Identification Object Type Vendor WLF_IDOBJ_TYPE_VENDORCHAR4Assigned to domainWLF_IDOBJ_TYPE_VENDOR
IDOBJ_VENDORAB: Identification Object Vendor WLF_IDOBJ_VENDORCHAR30WLF_IDOBJ
INVOICE_IDBusinessTransactionDocumentID WLF_BTD_IDCHAR35
IV_ACCRAccrual WLF_IV_ACCRUALCHAR1WLF_IV_ACCRUAL
IV_CHECK_TYPE_HType of Check (Header) WLF_IV_CHECK_TYPE_HEADCHAR1WLF_IV_CHECK_TYPE_HEAD
KKBERCredit control area KKBERCHAR4Assigned to domainKKBERKKB
KUNREBill-to party KUNRECHAR10Assigned to domainALPHAKUNNRKUN
KUNRGPayer KUNRGCHAR10Assigned to domainALPHAKUNNR
KURSTExchange Rate Type KURSTCHAR4Assigned to domainKURSTKUT
LAND1TXTax Destination Country WLF_D_LAND1TXCHAR3Assigned to domainLAND1LND
LANDLSupplying Country LANDLCHAR3Assigned to domainLAND1
LANDTXTax Departure Country WLF_D_LANDTXCHAR3Assigned to domainLAND1LND
LFARTAgency business: Billing document type WFARTCHAR4Assigned to domainWFARTWFA
LFTYPAgency business: Billing category WFTYPCHAR2WFTYP
LIFREDifferent Invoicing Party LIFRECHAR10Assigned to domainALPHALIFNRLRE
LNRZBAgency business: Payee W_LIFZECHAR10Assigned to domainALPHALIFNR
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
MWSBKTax amount in document currency MWSBPCURR13(2) WERTV7
MWSBKDTax amount in document currency (customer-side) MWSBPDCURR13(2) WERTV7
NARVFVendor billing document is relevant for subseq. settlement NARVFCHAR1XFELD
NAVNKNon-deductible input tax NAVNWCURR13(2) WERT7
PARTNER_EXP_TYPEClassification of Partner for Expense Documents WB2_PARTNER_EXP_TYPECHAR1WB2_PARTNER_EXP_TYPE
POST_PARTYPosting Partner WLF_POST_PARTYCHAR1WLF_POST_PARTY
SETTLE_CATEGORYSettlement Attributes WSETTLE_CATEGORYCHAR1WSETTLE_CATEGORY
SETTLE_DOCGlobal Trade Expenses: Settlement Document WLF_EXP_SETTLE_DOCCHAR10Assigned to domainALPHAWBELN
SETTL_DOCTYPE_CAB: Settlement Document Type - Customer WLF_SETTLEMENT_DOCTYPE_CCHAR1WLF_SETTLEMENT_DOCTYPE_C
SETTL_DOCTYPE_VAB: Settlement Document Type - Vendor WLF_SETTLEMENT_DOCTYPE_VCHAR1WLF_SETTLEMENT_DOCTYPE_V
SETTL_METHODAB: Settlement Procedure WLF_SETTLEMENT_METHODCHAR1WLF_SETTLEMENT_METHOD
SETTL_PARTYAB: Settlement Partner WLF_SETTLEMENT_PARTYCHAR1WLF_POST_PARTY
SETTL_STATUS_CAB: Settlement Status - Customer WLF_SETTLEMENT_STATUS_CCHAR1WLF_SETTLEMENT_STATUS
SETTL_STATUS_VAB: Settlement Status - Vendor WLF_SETTLEMENT_STATUS_VCHAR1WLF_SETTLEMENT_STATUS
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
USE_CASEUse Case Type WLF_USE_CASE_TYPECHAR2WLF_USE_CASE_TYPE
VKBURSales Office VKBURCHAR4Assigned to domainVKBURVKB
VKGRPSales Group VKGRPCHAR3Assigned to domainVKGRPVKG
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
WAERLCurrency of Agency Document WAERLCUKY5Assigned to domainWAERSFWS
WBTYPSettlement request: Payment type WBTYPCHAR1WBTYP
WDTYPAgency Business: Document Category DOCTYPECHAR1DOCTYPE
WFDATAgency business: Posting date WFDATDATS8DATUM
WFDAT_RLAgency Business: Posting Date for the Remuneration List WFDAT_RLDATS8DATUM
WKURSExchange Rate WKURSDEC9(5) EXCRTKURSP
WKURS_DATTranslation Date WWERT_DDATS8DATUM
WRARTAgency business: Payment type WRARTCHAR4Assigned to domainWRARTWRA
WRTYPEntry category: payment WRTYPCHAR1WRTYP
WSTWAEAgency Business: Statistics Currency WSTWAECUKY5Assigned to domainWAERS
ZEITPEvent for which updating should take place DZEITPCHAR2Assigned to domainZEITP
AKTNRCOUPON WAKTIONCHAR10Assigned to domainALPHAWAKTIONWAK
BONBARebate basis 1 BONBACURR13(2) WERTV7
BONBADRebate basis 1 BONBACURR13(2) WERTV7
BRGEWGross Weight WLF_BRGEW_15QUAN15(3) MENG15
BRTWRGross value of the item in document currency BRTWR_LFPCURR15(2) WERTV8
BRTWRDGross value of item in document currency (customer-side) BRTWRD_LFPCURR15(2) WERTV8
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
CONTRACTReferencing Contract Number WCONTRACTCHAR10ALPHAWCONTRACT
CONTRACT_ITEMReferencing Contract Item Number WCONTRACT_ITEMNUMC6NUMC6
CONTRACT_TYPEContract Type for Contract Number WCONTRACT_TYPECHAR1WCONTRACT_TYPE
CWM_MEINSAB: Parallel Unit of Measure WLF_CWM_MEINSUNIT3Assigned to domainCUNITMEINS
CWM_MENGEQuantity in Parallel Unit of Measure WLF_CWM_MENGEQUAN13(3) MENG13
CWM_UOM_TYPEAB: Type of the Parallel Unit of Measure WLF_CWM_UOM_TYPECHAR1WLF_CWM_UOM_TYPE
DISTRIB_STATUSAB: Status Distribution of Item WLF_DISTRIBUTION_STATUSCHAR1WLF_DISTRIBUTION_STATUS
EFFWREffective Value of Item WLF_EFFWRCURR13(2) WERTV7
EFFWRDEffective value of the item (customer-side) EFFWRDCURR13(2) WERTV7
EKKOLCondition Group with Vendor EKKOGCHAR4CHAR4
ERDATDate on Which Record Was Created ERDATDATS8DATUM
FPRMEBilling price unit WFPRMEUNIT3Assigned to domainCUNITMEINS
FPUMNVendor billing doc.: denominator for converting BPUn to PBUn WPUMNDEC5UMBSZ
FPUMZVendor billing doc.: numerator for converting BPUn to PBUn WPUMZDEC5UMBSZ
GEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
GRWRTStatistical value for foreign trade GRWRTCURR13(2) GRWRT
GRWRTDStatistical Value for Foreign Trade (Customer-Side) GRWRTDCURR13(2) GRWRT
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
GSBERDCustomer Business Area WLF_GSBER_CUSTOMERCHAR4Assigned to domainGSBER
IDNLFMaterial Number Used by Vendor IDNLFCHAR35IDNEX
IDNLF_TYPEAB: Article Number Type - Vendor WLF_IDNLF_TYPECHAR4Assigned to domainWLF_IDNLF_TYPE
INCO1_PIncoterms (Part 1) INCO1CHAR3Assigned to domainINCO1
INCO2_PIncoterms (Part 2) INCO2CHAR28INCO2
ITEMCATAgency Business: Item Category WSHKZGCHAR1WSHKZG
ITEM_CANCELEDItem Was Canceled WLF_ITEM_CANCELEDCHAR1WLF_ITEM_CANCELED
ITEM_INTRA_RELDocument Item is Relevant for Intrastat Declarations WLF_ITEM_INTRASTAT_RELEVANTCHAR1WLF_ITEM_INTRASTAT_RELEVANT
ITEM_STATUSAgency Business: Item Status WLF_ITEM_STATUSCHAR1WLF_ITEM_STATUS
IV_CHECK_TYPE_IType of Check (Item) WLF_IV_CHECK_TYPE_ITEMCHAR1WLF_IV_CHECK_TYPE_ITEM
KOKRSControlling Area KOKRSCHAR4Assigned to domainCACCDCAC
KOKRSDCustomer Controlling Area WLF_KOKRS_CUSTOMERCHAR4Assigned to domainCACCD
KOLIFPrior Vendor KOLIFCHAR10Assigned to domainALPHALIFNR
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
KOSTLDCustomer Cost Center WLF_KOSTL_CUSTOMERCHAR10Assigned to domainALPHAKOSTL
KZWI1Subtotal 1 from pricing procedure for condition KZWI1CURR13(2) WERTV7
KZWI1DSubtotal 1 from pricing procedure for condition KZWI1CURR13(2) WERTV7
KZWI2Subtotal 2 from pricing procedure for condition KZWI2CURR13(2) WERTV7
KZWI2DSubtotal 2 from pricing procedure for condition KZWI2CURR13(2) WERTV7
KZWI3Subtotal 3 from pricing procedure for condition KZWI3CURR13(2) WERTV7
KZWI3DSubtotal 3 from pricing procedure for condition KZWI3CURR13(2) WERTV7
KZWI4Subtotal 4 from pricing procedure for condition KZWI4CURR13(2) WERTV7
KZWI4DSubtotal 4 from pricing procedure for condition KZWI4CURR13(2) WERTV7
KZWI5Subtotal 5 from pricing procedure for condition KZWI5CURR13(2) WERTV7
KZWI5DSubtotal 5 from pricing procedure for condition KZWI5CURR13(2) WERTV7
KZWI6Subtotal 6 from pricing procedure for condition KZWI6CURR13(2) WERTV7
KZWI6DSubtotal 6 from pricing procedure for condition KZWI6CURR13(2) WERTV7
LFGRUAgency business: Reason for activity WFGRUCHAR3Assigned to domainWFGRU
LTSNRVendor Subrange LTSNRCHAR6Assigned to domainLTSNR
MATBFMaterial in Respect of Which Stock is Managed MATBFCHAR18Assigned to domainMATN1MATNR
MATKLMaterial Group MATKLCHAR9Assigned to domainMATKLMKLS_WBWG
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
MENGEVendor billing document: actual quantity billed WFIMGQUAN13(3) MENGE13
MTARTMaterial Type MTARTCHAR4Assigned to domainMTARTMTA
MWERT_IMNet Value in Document Currency NETWRCURR15(2) WERTV8
MWERT_PRNet Value in Document Currency NETWRCURR15(2) WERTV8
MWERT_UMNet Value in Document Currency NETWRCURR15(2) WERTV8
MWSBPTax amount in document currency MWSBPCURR13(2) WERTV7
MWSBPDTax amount in document currency (customer-side) MWSBPDCURR13(2) WERTV7
MWSK2Agency business: Tax code (output tax) MWSKZ_RBCHAR2Assigned to domainMWSKZ
MWSKZAgency business: Tax code (input tax) MWSKZ_LFCHAR2Assigned to domainMWSKZ
NAVNWNon-deductible input tax NAVNWCURR13(2) WERT7
NETWRNet value of the item in document currency NETWR_LFPCURR15(2) WERTV8
NETWRDNet value of the item in document currency (customer-side) NETWRD_LFPCURR15(2) WERTV8
NTGEWNet Weight WLF_NTGEW_15QUAN15(3) MENG15
PAOBJNRDCustomer Profitability Segment Number (CO-PA) WLF_PAOBJNR_CUSTOMERNUMC10RKEOBJNR
PEINHPrice Unit of Vendor Billing Document Item WEINHDEC5DEC5
POSNRAgency business: Document item WPOSNR_LFNUMC6Assigned to domainWPOSNR
POSNR_MAINMain Item for Item WLF_POSNR_MAINNUMC6Assigned to domainWPOSNR
POSNR_SUB_EXISTSubitems Exist WLF_POSNR_SUB_EXISTCHAR1XFELD
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PRCTRDCustomer Profit Center WLF_PRCTR_CUSTOMERCHAR10Assigned to domainALPHAPRCTR
PRSDTDate for pricing and exchange rate PRSDTDATS8DATUM
REF_ITEM_NUMBERReference Document Item for Agency Document WLF_REF_ITEM_NUMBERNUMC10WLF_REF_ITEM_NUMBER
REF_NUMBERReference Document for Agency Document WLF_REF_NUMBERCHAR32WLF_REF_NUMBER
REF_TYPEReference Document Category WLF_REF_TYPECHAR2WFTYP_V
SETTL_ITEM_RELAB: Item Settlement Relevance WLF_SETTLEMENT_ITEM_RELEVANCECHAR1WLF_SETTLEMENT_ITEM_RELEVANCE
SETTL_STATUS_I_CAB: Settlement Status - Item - Customer WLF_SETTLEMENT_STATUS_ITEM_CCHAR1WLF_SETTLEMENT_STATUS_ITEM
SETTL_STATUS_I_VAB: Settlement Status - Item - Vendor WLF_SETTLEMENT_STATUS_ITEM_VCHAR1WLF_SETTLEMENT_STATUS_ITEM
SKFBPAmount eligible for cash discount in document currency SKFBPCURR13(2) WERTV7
SKFBPDAmount qualifying for cash discount in doc. currency (cust.) SKFBPDCURR13(2) WERTV7
STAFOUpdate group for statistics update STAFOCHAR6Assigned to domainALPHASTAFOMCF
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
UMRENFactor for converting qty in vendor bill. doc. to base unit UMWFNDEC5UMBSN
UMREZNumerator converting qty in vendor bill.doc. to base unit UMWFZDEC5UMBSZ
VOLEHVolume unit VOLEHUNIT3Assigned to domainCUNITMEINS
VOLUMVolume WLF_VOLUM_15QUAN15(3) MENG15
WBELNAgency Business: Document Number WBELN_AGCHAR10Assigned to domainALPHAWBELN
WBELN_VTriggering document of the agency document WBELN_VCHAR10CHAR10
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
WFKMEVendor billing document: unit of measure WFKMEUNIT3Assigned to domainCUNITMEINS
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
ANZRGKey figure: Number of payment requests MC_AWBRKRGDEC9MCZAEHLER
ANZLFKey figure: Number of vendor billing documents MC_AWBRKRLDEC9MCZAEHLER
ANZCSKey Figure: Number of Customer Settlements MC_AWBRKCSDEC9MCZAEHLER
ANZPOSRLKey figure: Number of documents in request lists (payment) MC_ARLRPRGRLALDEC9MCZAEHLER
ANZPOSLFKey figure: No. of vendor billing document items MC_AWBRPRLDEC9MCZAEHLER
ANZPOSRGKey figure: Number of payment request items MC_AWBRPRGDEC9MCZAEHLER
ANZPOSCSKey Figure: Number of Line Items in Customer Settlement MC_AWBRPCSDEC9MCZAEHLER
.INCLU--AP 0
DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
RRLCGAB-RRLE: Condition Type Group RRLCGCHAR4Assigned to domainALPHARRLCG
RRLPAAB-RRLE: Remuneration List Partner RRLPACHAR1RRLPA
REFSITEReference Plant REFSITECHAR4Assigned to domainWERKS
.INCLU--AP 0
DOC_SETTLEDGT Expenses: Document Settled WB2_EXP_DOCUMENT_SETTLEDCHAR1WB2_EXP_DOCUMENT_SETTLED
EXP_CALC_TYPEGT Expenses: Calculation Type WB2_EXPENSE_CALC_TYPECHAR1WB2_EXPENSE_CALC_TYPE
EXP_CLASSGT Expenses: Expense Class WB2_EXPENSE_CLASSCHAR3Assigned to domainWB2_EXPENSE_CLASSEXP_CLASS
PARTNER_EXPBusiness Partner PRQ_PARNOCHAR10ALPHAPRQ_PARNO
POST_TYPEGT Expenses: Posting Type of Expenses WB2_EXPENSE_POSTING_TYPECHAR1Assigned to domainWB2_EXPENSE_POSTING_TYPE
REF_VALUEGlobal Trade Reference Value for Expenses WB2_EXPENSE_REFERENCE_VALUECURR11(2) WERTV6
REF_VALUE_REFRef. Field for GT Expenses Ref. Value (Currency, %, Unit) WB2_EXPENSE_REF_VALUE_REFCUKY5Assigned to domainWAERS
STEPBusiness Process Step WB2_STEPCHAR4WB2_STEP
STEP_FROMBusiness Process Step WB2_STEPCHAR4WB2_STEP
STEP_TEWBusiness Process Step WB2_STEPCHAR4WB2_STEP

Key field Non-key field



How do I retrieve data from SAP structure MC45W_0ITM using ABAP code?

As MC45W_0ITM 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 MC45W_0ITM as there is no data to select.

How to access SAP table MC45W_0ITM

Within an ECC or HANA version of SAP you can also view further information about MC45W_0ITM and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!