Field Available In F4111

Purpose of Document

Is there any available column to use from F4111 for recording a certain process?

Table of Contents

• Simplified Routine
• A. Table Layout
• B. Assignment
• DF4312Z1B - XT4312Z1 Edit Object - Edit Line
• DXT4111Z1C - F4111FS Edit Line - Functional Server
• D4100050 - Inventory Cardex Shell
• D4100040 - Write Cardex Record

I have checked exiting tables and mapping, which appears,
- There are two columns which are not mapped are,
LPNU License Plate Number
IPCD As Of Posted Code : but this column is used for As-Of processing and reconciliation so do not use this column
- There are column which are dependent on Agreement management
DMCS Agreement Supplement
- There are specific usage (like Warehouse and production number) these are depending on your implementation

Simplified routine:

XXX Edit Line
|--- F4111EditLine (XT4111Z1, F4111 Edit Line): this master inventory transaction business function validates, defaults and creates cache F41UI001. Depending on the parameters in calling Edit Line, a certain columns from F41UI001 may (or may not) be assigned.

XXX End Document
     |--- F4111EndDocument (XT4111Z1, F4111 End Document): this function commits cache to the table F4111
         |--- InventoryCardexShell (B4100050, F4111 Format Item Ledger Record)
             |--- WriteCardexRecord (B4100040, F4111 Write Item Ledger)

A. Table Layout

Back To Top

B. Assignment

*** B4100040 ***
MathCopy(&lpdsF4111->ildoc, &lpDS->mnDocumentNumber ) ;
MathCopy(&lpdsF4111->ildoco, &lpDS->mnOrderNumber ) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilkco), (const JCHAR *)(lpDS->szCompanyNumber ) ) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilmmcu),(const JCHAR *)(lpDS->szCostCenter ) ) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ildct), (const JCHAR *)(lpDS->szDocumentType ) ) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ildcto),(const JCHAR *)(lpDS->szOrderType ) ) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilkcoo),(const JCHAR *)(lpDS->szCompanyOrderNumber ) ) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ildmct),(const JCHAR *)(lpDS->szContractNumber ) ) ;

/**********************************************************************
* Load Transaction Detail Information
*/

/* Load Item Numbers */
MathCopy(&lpdsF4111->ilitm, &lpDS->mnShortItemNumber) ;
MathCopy(&lpdsF4111->ilkit, &lpDS->mnParentItemNumber) ;
jdeStrcpy((JCHAR *)(lpdsF4111->illitm),(const JCHAR *)(lpDS->szSecondItemNumber)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilaitm),(const JCHAR *)(lpDS->szThirdItemNumber)) ;

/* Load Logical Location Information */
jdeStrcpy((JCHAR *)(lpdsF4111->ilmcu), (const JCHAR *)(lpDS->szBranchPlant)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->illocn),(const JCHAR *)(lpDS->szLocation)) ;

/* Load Lot Information */
MathCopy(&lpdsF4111->illotp, &lpDS->mnPotency) ;
jdeStrcpy((JCHAR *)(lpdsF4111->illotn),(const JCHAR *)(lpDS->szLot)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilplot),(const JCHAR *)(lpDS->szParentLot)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->illotg),(const JCHAR *)(lpDS->szGrade)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilrcd), (const JCHAR *)(lpDS->szReasonCode)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->illotc),(const JCHAR *)(lpDS->szLotStatusCodeExpanded)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->illrcd),(const JCHAR *)(lpDS->szLotStatusReasonCode)) ;
lpdsF4111->illots = lpDS->cLotStatus ;

/* Load Quantity Information */
MathCopy(&lpdsF4111->iltrqt, &lpDS->mnTransactionQuantity) ;
MathCopy(&lpdsF4111->ilsqor, &lpDS->mnUnitsSecondaryQtyOr) ;
jdeStrcpy((JCHAR *)(lpdsF4111->iltrum),(const JCHAR *)(lpDS->szTransactionUnitOfMeasure)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->iluom2),(const JCHAR *)(lpDS->szUnitOfMeasureSecondary)) ;

/* Load Supplier Information */
MathCopy(&lpdsF4111->ilan8, &lpDS->mnAddressNumber ) ;
/* SAR 7105876 - Life Science */
jdeStrcpy((JCHAR *)(lpdsF4111->ilrlot),(const JCHAR *)(lpDS->szSupplierLotNumber)) ;

/* Load Journal Entry Information */
MathCopy(&lpdsF4111->iluncs, &lpDS->mnUnitCost) ;
MathCopy(&lpdsF4111->ilpaid, &lpDS->mnExtendedCost) ;
MathCopy(&lpdsF4111->ilicu, &lpDS->mnBatchNumber) ;
MathCopy(&lpdsF4111->iljeln, &lpDS->mnJournalEntryNumber) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilsfx), (const JCHAR *)(lpDS->szPayItem)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilglpt),(const JCHAR *)(lpDS->szGLCategory)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilaid), (const JCHAR *)(lpDS->szAccountId)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilmcuz),(const JCHAR *)(lpDS->szCostCenterAlternative)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilobj), (const JCHAR *)(lpDS->szObjectAccount)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilsbl), (const JCHAR *)(lpDS->szSubledger)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilsub), (const JCHAR *)(lpDS->szSubsidiary)) ;
lpdsF4111->ilsblt = lpDS->cSubledgerType ;
memcpy((void *)(&lpdsF4111->ildgl),(const void *)(&lpDS->jdGLDate ),sizeof(JDEDATE)) ;

/* Load Warehouse Information */
MathCopy(&lpdsF4111->ilstun,&lpDS->mnStorageUnit) ;
MathCopy(&lpdsF4111->illdsq,&lpDS->mnSequenceNumberLocation) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilasid),(const JCHAR *)(lpDS->szSerialTagNumber)) ;

/* Load Line Information */
MathCopy(&lpdsF4111->ilukid,&lpDS->mnUniqueID) ;
MathCopy(&lpdsF4111->iltrno,&lpDS->mnTransactionLineNumber) ;
MathCopy(&lpdsF4111->illnid,&lpDS->mnUnqueLineNumber) ;
MathCopy(&lpdsF4111->ilnlin,&lpDS->mnNumberOfLines) ;
lpdsF4111->ilfrto = lpDS->cFromTo ;
lpdsF4111->illmcx = lpDS->cMasterCardex ;
lpdsF4111->ilipcd = lpDS->cAsOfPostedCode ;
lpdsF4111->ilcmoo = lpDS->cCommingledOtherOwner ;
lpdsF4111->ilre = lpDS->cReverseOrVoidRV ;
memcpy((void *)(&lpdsF4111->iltrdj),(const void *)(&lpDS->jdTransactionDate),
sizeof(JDEDATE)) ;

/* Load Reference Information */
MathCopy(&lpdsF4111->ildmcs, &lpDS->mnContractSupplement) ;
MathCopy(&lpdsF4111->ilrfln, &lpDS->mnRelatedFromLineNumber) ;
MathCopy(&lpdsF4111->iltgn, &lpDS->mnTransactionGroupNumber) ;
jdeStrcpy((JCHAR *)(lpdsF4111->iltref),(const JCHAR *)(lpDS->szTransactionReference)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->iltrex),(const JCHAR *)(lpDS->szTransactionExplanation)) ;
memcpy((void *)(&lpdsF4111->ilsvdt),(const void *)(&lpDS->jdFutureUseDate ),
sizeof(JDEDATE) ) ;
memcpy((void *)(&lpdsF4111->ilvpej),(const void *)(&lpDS->jdValuationPeriodEndingDate ),
sizeof(JDEDATE) ) ;
memcpy((void *)(&lpdsF4111->ilhdgj),(const void *)(&lpDS->jdHistoricalDateJulian ),
sizeof(JDEDATE) ) ;

/* Load Audit Information */
MathCopy(&lpdsF4111->iltday, &lpDS->mnTimeOfDay) ;
MathCopy(&lpdsF4111->ilshan, &lpDS->mnAddressNumberShipTo) ;
MathCopy(&lpdsF4111->ilopsq, &lpDS->mnSequenceNoOperations) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilterm),(const JCHAR *)(lpDS->szTerminalIdentification)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->iluser),(const JCHAR *)(lpDS->szUserID)) ;
jdeStrcpy((JCHAR *)(lpdsF4111->ilpid), (const JCHAR *)(lpDS->szProgramID)) ;

/* BUG - 11905201 - PMPN Enhancement - Begin */
/* Copy PMPN number and PNS Number to write into the F4111 Table */
MathCopy(&lpdsF4111->ilpns, &lpDS->mnProductionNumberShort) ;
if ((MathCompare(&lpDS->mnProductionNumberShort, &mnZero) > 0) && (jdeStrcmp(lpDS->szDocumentType, _J("IB")) != 0))
{
jdeStrncpy((JCHAR *)(lpdsF4111->ilpmpn),
(const JCHAR *)(lpDS->szProjectManufacturingProd),
DIM(lpdsF4111->ilpmpn));
}
else
{
jdeStrncpy((JCHAR *)(lpdsF4111->ilpmpn),
(const JCHAR *)(_J(" ")),
DIM(lpdsF4111->ilpmpn));
MathCopy(&lpdsF4111->ilpns, &mnZero) ;
}
/* BUG - 11905201 - PMPN Enhancement - End */

Additional information which affects each columns:-

Back To Top

DF4312Z1B - XT4312Z1 Edit Object - Edit Line

Back To Top

DXT4111Z1C - F4111FS Edit Line - Functional Server

Back To Top

D4100050 - Inventory Cardex Shell

Back To Top

D4100040 - Write Cardex Record