SAP TXI_AFVC Table in S/4 HANA - Operation within an order









TXI_AFVC is a standard SAP Table which is used to store Operation within an order data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TXI_AFVC table(ECC)

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: TXI_AFVC


TXI_AFVC table structure field list

Below is the full TXI_AFVC field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field


Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP SHLP Field
MANDTClientMANDTCLNT3(0) T000MANDT
AUFPLRouting number of operations in the orderCO_AUFPLNUMC10(0) AUFPL
APLZLGeneral counter for orderCO_APLZLNUMC8(0) Assigned to domainCO_APLZL
PLNFLSequencePLNFOLGECHAR6(0) ALPHAPLNFOLGE
PLNKNNumber of the Task List NodePLNKNNUMC8(0) KNTNR
PLNALGroup CounterPLNALCHAR2(0) ALPHAALTNRPAL
PLNTYTask List TypePLNTYCHAR1(0) TCA01PLNTYPTYH_TCA01PLNTY
VINTVIncrement between referenced operationsVINTVDEC3(0) VINTV
PLNNRKey for Task List GroupPLNNRCHAR8(0) ALPHAPLNNRPLNPLKSPLNNR
ZAEHLInternal counterCIM_COUNTNUMC8(0) CIM_COUNT
VORNROperation/Activity NumberVORNRCHAR4(0) NUMCVVORNRVGN
STEUSControl keySTEUSCHAR4(0) T430STEUS
ARBIDObject ID of the resourceCR_OBJIDNUMC8(0) CRIDCR_OBJID
PDESTPrinter for shop papersCR_PDESTCHAR4(0) TSP03SPDEVRSPOPNAME
WERKSPlantWERKS_DCHAR4(0) T001WWERKSWRKH_T001W_CWERKS
KTSCHStandard Text KeyKTSCHCHAR7(0) T435KTSCH
LTXA1Operation short textLTXA1CHAR40(0) TEXT40
LTXA2Second line of the descriptionLTXA2CHAR40(0) TEXT40
TXTSPLanguage KeySPRASLANG1(0) T002ISOLASPRASSPRH_T002SPRAS
VPLTYType of the referenced task listVPLNTYCHAR1(0) TCA01PLNTY
VPLNRGroup of the referenced task listVPLNNRCHAR8(0) ALPHAPLNNR
VPLALGroup counter of the referenced task listVPLNALCHAR2(0) ALPHAALTNR
VPLFLReferenced sequence in routingVPLBFLCHAR6(0) ALPHAPLNFOLGE
VGWTSStandard Value KeyVORGSCHLCHAR4(0) TC21VORGSCHL
LAR01Activity TypeLSTARCHAR6(0) CSLALSTARLARLART_EMPTYLSTAR
LAR02Activity TypeLSTARCHAR6(0) CSLALSTARLARLART_EMPTYLSTAR
LAR03Activity TypeLSTARCHAR6(0) CSLALSTARLARLART_EMPTYLSTAR
LAR04Activity TypeLSTARCHAR6(0) CSLALSTARLARLART_EMPTYLSTAR
LAR05Activity TypeLSTARCHAR6(0) CSLALSTARLARLART_EMPTYLSTAR
LAR06Activity TypeLSTARCHAR6(0) CSLALSTARLARLART_EMPTYLSTAR
ZERMAType of Standard Value DeterminationDZERMACHAR5(0) T429ZERMA
ZGDATDate when the standard value was calculatedDZGDATCHAR4(0) GJAHRCJAHR
ZCODEReference number for standard value codeDZCODECHAR6(0) ZCODE
ZULNRBasis for Determination of Standard ValueDZULNRCHAR5(0) ZULNR
LOANZNumber of Time TicketsLOHNANZDEC3(0) LOHNANZ
LOARTWage typeLOHNARTCHAR4(0) LOART
RSANZNumber of Confirmation SlipsCR_RS_ANZNUMC3(0) NUM03
QUALFSuitabilityQUALFCHAR2(0) T423QUALF
ANZMANumber of employeesANZMSDEC5(2) ANZMA
RFGRPSetup group categoryRUEFAGRPCHAR10(0) T426RUEFAGRP
RFSCHSetup group keyRUEFASCHLUCHAR10(0) T425RUEFASCHLU
RASCHSetup Type KeyRUEARSCHLUCHAR2(0) T428RUEARSCHLU
AUFAKScrap factorAUSCHUFAKDEC5(3) AUSCHUFAK
LOGRPWage GroupLOHNGRPCHAR3(0) T421LOHNGRP
UEMUSRequired OverlappingUEMUSKZCHAR1(0) XFELD
UEKANOptional OverlappingUEKANKZCHAR1(0) XFELD
FLIESFlow ManufacturingFLIESSKZCHAR1(0) XFELD
SPMUSSplitting RequiredSPLITTUNGCHAR1(0) XFELD
SPLIMMaximum Number of SplitsSPLITTANZDEC3(0) SPLITTANZ
ABLIPKZTeardown and Wait Occur in ParallelABLIPKZCHAR1(0) FLAG
RSTRAReduction Strategy per OperationRSTRACHAR2(0) T499QRSTRA
SUMNRNode Number of the Superior OperationSUMKNTNRNUMC8(0) KNTNR
SORTLSort Term for Non-Stock Info RecordsSORTICHAR10(0) CHAR10
LIFNRAccount Number of Vendor or CreditorLIFNRCHAR10(0) LFA1ALPHALIFNRLIFKRED_CLIFNR
PREISPricePREISCURR11(2) WERT11
PEINHPrice unitPEINHDEC5(0) PACK3
SAKTOCost ElementKSTARCHAR10(0) CSKAALPHAKSTARKAT
WAERSCurrency KeyWAERSCUKY5(0) TCURCWAERSFWS
INFNRNumber of purchasing info recordINFNRCHAR10(0) EINAALPHAINFNRINFMEIN_CINFNR
ESOKZPurchasing info record categoryESOKZCHAR1(0) ESOKZESO
EKORGPurchasing organizationEKORGCHAR4(0) T024EEKORGEKO
EKGRPPurchasing Group for External Processing ActivityVG_EKGRPCHAR3(0) T024EKGRP
KZLGFIndicator: Lot-Size-Independent External ProcessingKZLGFCHAR1(0) XFELD
KZWRTFIndicator: Fixed price for external processingKZWRTFCHAR1(0) XFELD
MATKLMaterial GroupMATKLCHAR9(0) T023MATKLMKLS_WBWGMATKL
DDEHNIndicator: flexible durationDAUDEHNCHAR1(0) X
ANZZLNumber of capacities requiredANZKAPINT13(0) INT1
PRZNTWork percentageAPROZENTINT13(0) INT1
MLSTNUsageMILESTONECHAR5(0) T433MILESTONE
PPRIOPriorityPRIORITAETCHAR2(0) PRIORITAET
BUKRSCompany CodeBUKRSCHAR4(0) T001BUKRSBUKC_T001BUKRS
ANFKORequesting Cost CenterANFKOCHAR10(0) CSKSALPHAKOSTL
ANFKOKRSControlling area of the requesting cost centerANFKOKRSCHAR4(0) TKA01CACCD
INDETKey for calculationINDETCHAR1(0) INDET
LARNTActivity TypeLSTARCHAR6(0) CSLALSTARLARLART_EMPTYLSTAR
PRKSTCosts in the activityPRKSTCURR11(2) PRKST
APLFLSequencePLNFOLGECHAR6(0) ALPHAPLNFOLGE
RUECKCompletion confirmation number for the operationCO_RUECKNUMC10(0) CO_RUECKRCK
RMZHLConfirmation counterCO_RMZHLNUMC8(0) CIM_COUNTRZL
PROJNWork breakdown structure element (WBS element)PS_PSP_ELENUMC8(0) PRPSKONPRPS_POSNR
OBJNRObject numberJ_OBJNRCHAR22(0) ONR00J_OBJNRONR
SPANZActual number of splitsSPLITTERMDEC3(0) DEC3
BEDIDID of the Capacity Requirements RecordBEDIDNUMC12(0) Assigned to domainBEDID
BEDZLInternal counterCIM_COUNTNUMC8(0) CIM_COUNT
BANFNPurchase Requisition NumberCO_BANFNCHAR10(0) ALPHABANFN
BNFPOItem Number of Purchase Requisition in OrderCO_BNFPONUMC5(0) EBANBNFPO
LEK01Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
LEK02Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
LEK03Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
LEK04Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
LEK05Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
LEK06Indicator: No Remaining Activity ExpectedCO_LEIKZCHAR1(0) XFELD
SELKZSelection indicator for costing line itemsCO_SELKZCHAR1(0) TCK08CK_SELKZ
KALIDFactory CalendarWFCIDCHAR2(0) TFACDWFCIDFCI
FRSPEarliest possible activity / Latest possible activityFRSPCHAR1(0) FRSP
STDKNNode of operation within reference operation setSTDKNNUMC8(0) KNTNR
ANLZUSystem ConditionANLZUCHAR1(0) T357MANLZU
ISTRUAssemblyISTRUCHAR40(0) MARAMATN1MATNR
ISTTYBOM categorySTLTYCHAR1(0) STLTY
ISTNRBill of MaterialSTNUMCHAR8(0) NUMCVSTNUMSTLNRSTLNR
ISTKNBOM item node numberSTLKNNUMC8(0) KNTNR
ISTPOInternal counterCIM_COUNTNUMC8(0) CIM_COUNT
IUPOZSubitem NumberUPOSZCHAR4(0) NUMCVSPOSN
EBORTInstallation Point for SubitemEBORTCHAR20(0) TEXT20
VERTLDistr.cap.reqmts (plant maint.,process order, network)CR_VERTNCHAR8(0) TC29CR_VERTL
LEKNWIndicator: No Remaining Work ExpectedLEKNWCHAR1(0) XFELD
NPRIOPriorityNW_PRIOCHAR1(0) TCN07NW_PRIO
PVZKNGeneral counter for orderCO_APLZLNUMC8(0) Assigned to domainCO_APLZL
PHFLGIndicator: PhasePHFLGCHAR1(0) XFELD
PHSEQControl Recipe DestinationPHSEQCHAR2(0) TC52PHSEQ
KNOBJNumber of Object with Assigned DependenciesKNOBJNUMC18(0) KNOBJ
ERFSICHTRecording ViewQERFSICHTCHAR2(0) QERFSICHTQER
QPPKTABSFlow Variants for Inspection Point CompletionQPPKTABSCHAR1(0) QPPKTABS
OTYPEObject TypeOTYPECHAR2(0) T778OOTYPEPOT
OBJEKTIDObject IDOBJEKTIDNUMC8(0) NUM08PON
QLKAPARCapacity categoryQL_KAPARTCHAR3(0) TC26KAPARTCAA
RSTUFReduction Level Which Reduces Operation Lead TimeRSTUFNUMC1(0) REDST
NPTXTKYInternal text number (12-character)TXTKYCHAR12(0) CHAR12
SUBSYSSubsystem Identifier for QM Subsystem InterfaceQEIFSUBSYSCHAR6(0) Assigned to domainQEIFSUBSYS
PSPNRStandard WBS elementPS_SPS_ELENUMC8(0) Assigned to domainKONPTPS_SPSNR
PACKNOPackage numberPACKNONUMC10(0) Assigned to domainPACKNO
TXJCDTax JurisdictionTXJCDCHAR15(0) TTXJTXJCDTXJ
SCOPEObject ClassSCOPE_CVCHAR2(0) SCOPESCOPE_CVPCO
GSBERBusiness AreaGSBERCHAR4(0) TGSBGSBERGSB
PRCTRProfit CenterPRCTRCHAR10(0) CEPCALPHAPRCTRPRCPRCTR_EMPTYPRCTR
NO_DISPEffective for Materials PlanningNO_DISP_PLUSCHAR1(0) NO_DISP_PLUS
QKZPRZEITInterval = Time (Time-Related)QKZPRZEITCHAR1(0) QKZ
QKZZTMG1Quantity Confirmation for Each Partial LotQKZZTMG1CHAR1(0) QKZ
QKZPRMENGInspection Cycle = Quantity (Quantity-Reference)QKZPRMENGCHAR1(0) QKZ
QKZPRFREIInterval Without Reference to Time or QuantityQKZPRFREICHAR1(0) QKZ
KZFEATIndicator Is Not Used CurrentlyQKZFEATCHAR1(0) QKZFEAT
QKZTLSBESTOperation with Stock-Related Partial Lot AssignmentQKZTLSBESTCHAR1(0) QKZ
AENNRChange NumberAENNRCHAR12(0) AENRAENNRAENNRAEN
CUOBJ_ARBConfiguration (internal object number)CUOBJNUMC18(0) CUOBJCUX
EVGEWAggregation weight for POC (PS progress)EV_WEIGHTDDEC8(0) DEC8
ARBIIActual operating resources object identificationCR_OBJID_INUMC8(0) CRIDCR_OBJID
WERKIActual plantWERKS_ICHAR4(0) T001WWERKSWRK
CY_SEQNRVSequence number operationCY_SEQNRVNUMC14(0) CY_SEQNR
KAPT_PUFFROperation floats after finite scheduling (in seconds)KAPT_PUFFRINT410(0) INT4
EBELNPurchasing Document NumberEBELNCHAR10(0) EKKOALPHAEBELNBESMEKK_CEBELN
EBELPItem Number of Purchasing DocumentEBELPNUMC5(0) EKPOEBELPBSP
WEMPFGoods recipientWEMPFCHAR12(0) WEMPF
ABLADUnloading PointABLADCHAR25(0) TEXT25
CLASFInd.: Respect Activity for Project SummarizationCLASFCHAR1(0) XFELD
FRUNVIndicator: External procurement data incompleteFRUNVCHAR1(0) KREUZ
ZSCHLOverhead keyAUFZSCHLCHAR6(0) CHAR6
KALSMCosting SheetAUFKALSMCHAR6(0) Assigned to domainKALSM
SCHED_ENDInd.: Purchase requisition at activity finish dateSCEND_ACTCHAR1(0) XFELD
NETZKONTIndicator for the account assignment of a network(hdr/act.)NETZKONTCHAR1(0) NETZKONT
OWAERObject currency for network activityOWAERSCUKY5(0) TCURCWAERS
AFNAMName of requisitioner/requesterAFNAMCHAR12(0) AFNAM
BEDNRRequirement Tracking NumberBEDNRCHAR10(0) CHAR10
KZFIXData of Purchasing Info Record Is FixedCN_KZFIXCHAR1(0) XFELD
PERNRPersonnel numberCO_PERNRNUMC8(0) PERNRPER
FRDLBIndicator: External Processing Operation with SubcontractingCO_FRDLBCHAR1(0) CHAR1
QPARTInspection TypeQPARTCHAR8(0) TQ30QPARTQLA
LOEKZDeletion FlagAUFLOEKZCHAR1(0) XFELD
WKURSExchange RateWKURSDEC9(5) EXCRTKURSP
PROD_ACTIndicator: Activity is a production activityPROD_ACTCHAR1(0) XFELD
FPLNRBilling plan number / invoicing plan numberFPLNRCHAR10(0) Assigned to domainFPLNR
OBJTYPEChange indicatorOCM_OBJ_TYPECHAR1(0) OCM_OBJ_TYPE
CH_PROCProcess that has lead to the change of an objectOCM_CH_PROCCHAR1(0) OCM_CH_PROC
KLVARCosting VariantCK_KLVARCHAR4(0) Assigned to domainKLVARKRT
KALNRCost Estimate Number for Cost Est. w/o Qty StructureCK_KALNRNUMC12(0) Assigned to domainCK_KALNRKNR
FORDNFramework OrderSFORDNCHAR10(0) Assigned to domainALPHAEBELN
FORDPItem of framework orderFORDPNUMC5(0) Assigned to domainEBELP
MAT_PRKSTMaterial planning in networks: primary costsMAT_PRKSTCURR11(2) PRKST
PRZ01Business ProcessCO_PRZNRCHAR12(0) Assigned to domainALPHACO_PRZNRKWP
RFPNTReference point for BOM transferCN_RFPNTCHAR20(0) TCNRFPCN_RFPNT
FUNC_AREAFunctional AreaFKBERCHAR16(0) TFKBFKBERFBE
TECHSParameter Variant/Standard VariantTECHSCHAR12(0) TECHS
ADPSPReference Element PM/PSADDCOMPARE_CORECHAR40(0) ADDCOMPARE_COREADCPADPSP
RFIPPNTReference Point for Relationship Between iPPE and PSCN_RPIPCHAR20(0) TCNRPIPCN_RFPNT
MES_OPERIDKey of an Operation from an ME SystemCO_MES_INT_OPERIDCHAR48(0) CHAR48
MES_STEPIDKey of a Step in a Routing (SAP ME)CO_MES_INT_STEPIDCHAR6(0) CHAR6
OAN_INST_ID_SETUPOperation Activity Network: Instance IDMPE_OAN_INSTANCE_IDINT410(0)
OAN_INST_ID_PRODUCEOperation Activity Network: Instance IDMPE_OAN_INSTANCE_IDINT410(0)
OAN_INST_ID_TEARDOWNOperation Activity Network: Instance IDMPE_OAN_INSTANCE_IDINT410(0)
TL_VERSNRouting VersionPLNVERSNCHAR4(0) ALPHAPLNVERSN
DUMMY_AFVC_INCL_EEW_PSDummy function in length 1DUMMYCHAR1(0) DUMMY
.INCLU--AP0(0)
/CUM/CUGUIDUUID in X form (binary)SYSUUID_XRAW16(0) /CUM/AFCUSYSUUID
.INCLU--AP0(0)
/ISDFPS/OBJNRObject numberJ_OBJNRCHAR22(0) Assigned to domainJ_OBJNRONR
.INCLU--AP0(0)
MILL_OC_AUFNR_MONumber of Combined OrderMILL_OC_AUFNR_MOCHAR12(0) Assigned to domainALPHAAUFNR
.INCLU--AP0(0)
WTY_INDWarranty indicatorWTYSC_WTY_INDICATORCHAR1(0) WTYSC_WTY_INDICATOR
TPLNRFunctional LocationTPLNRCHAR30(0) TPLNRTPLNRIFLIFLMTPLNR
EQUNREquipment NumberEQUNRCHAR18(0) ALPHAEQUNREQNEQUIEQUNR
.INCLU--AP0(0)
CPD_UPDATTime Stamp/CPD/PFP_SC_TSTMPDEC15(0) TSTLC/CPD/PFP_SC_TSTMP
PREIS_CYCUKY for SYSTSYCUKYCUKY5(0) SYCUKY
PRKST_CYCUKY for SYSTSYCUKYCUKY5(0) SYCUKY
MAT_PRKST_CYCUKY for SYSTSYCUKYCUKY5(0) SYCUKY




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!