1. Home
  2. Resources
  3. SAP Tables
  4. TIVRAOPACTI - Settings for Line Item

SAP Table TIVRAOPACTI

Settings for Line Item

TIVRAOPACTI (Settings for Line Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TIVRAOPACTI to other SAP tables.

TIVRAOPACTI table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
OPACT Posting Activity RERAOPACT TIVRAOPACT CHAR 6 0
HEADERNO Sequence Number of Document RERAOPHEADERNO TIVRAOPACTH NUMC 2 0
ITEMNO Sequence Number of Line Item RERAOPITEMNO NUMC 10 0
ISOPTIONALITEM Line Item Is Optional RERAOPISOPTIONALITEM CHAR 1 0
X Yes
NULL No
DCINDICATOR Debit/Credit Indicator RERADCINDICATOR CHAR 1 0
C Credit
D Debit
ACCTYPE Account Type RERAOPACCTYPE CHAR 1 0
D Customers
K Vendors
S G/L Accounts
GLACCSYMB Account Determination: Account Symbols RERAGLACCSYMB TIVRAACCSYMB CHAR 15 0
FLOWTYPE Flow Type RECDFLOWTYPE TIVCDFLOWTYPE CHAR 4 0
ITEMTXT Default Line Item Text RERAOPITEMTXT CHAR 50 0
HASHOUSEBK Copy House Bank in Line Item RERAOPHASHOUSEBK CHAR 1 0
X Yes
NULL No
HASCPD Does the Line Item Allow Entering One-Time Data? RERAOPHASCPD CHAR 1 0
X Yes
NULL No
COUNTRY Country Key for One-Time Data RERAOPCPDCOUNTRY T005 CHAR 3 0
BANK_CTRY Bank Country for One-Time Data RERAOPCPDBANKCTRY T005 CHAR 3 0
HASSPECACCT Account Selection Is Limited RERAOPHASSPECACCT CHAR 1 0
X Yes
NULL No
HASCN Is Entering a Contract in Line Item Possible? RERAOPHASCN CHAR 1 0
X Yes
NULL No
CNITEMDEDUCT Logic for Deriving Contract for Line Item RERAOPCNITEMDEDUCT CHAR 1 0
NULL No Default for Contract
1 Contract of Basic Data
2 Lease-Out Contract of Rental Object of Basic Data
3 Assessment Contract of Rental Object of Basic Data
4 Lease-Out Contract for Assessment Contract of Basic Data
5 Management Contract for Assessment Contract of Basic Data
6 Condo Management Contract for Rental Object of Basic Data
SCKEY Default Service Charge Key RERAOPSCKEY TIVSCSCKEY CHAR 4 0
SHSTRATSCKEY Search Strategy for Service Charge Key RERASHSTRATSCKEY TIVCASHSTRATSYS CHAR 12 0
PROPOSEREFDATE Propose Settlement Reference Date? RERAOPPROPOSEREFDATE CHAR 1 0
X Yes
NULL No
OBJTYPE Object Type of Account Assignment RERAOPOBJTYPE CHAR 2 0
IW Business Entity
IG Land
IB Building
IM Rental Object
IS Contract
I1 Settlement Unit
KS Cost Center
PR WBS Element
OR Order
ISOBJNRDEDOBL Deriving Account Assignment Object Is Required RERAOPISOBJNRDEDOBL CHAR 1 0
X Yes
NULL No
OBJNRDEDUCT Derivation Logic for Account Assignment Object of Line Item RERAOPOBJNRDEDUCT CHAR 1 0
NULL No Derivation
1 From the Contract of the Basic Data
2 From the Contract of the Line Item
3 From the Rental Object of the Basic Data
4 From Corresponding Rental Object in COA Company Code
5 From Corresponding Rental Object in Manager/Condo Owner CC
6 From the Mandate
7 From the Distribution Formula
BPITEMDEDUCT Derivation Logic for Partner for Line Item RERAOPBPITEMDEDUCT CHAR 1 0
NULL No Default for Partner
1 Partner from Default Posting Term (Not Overwritable)
2 Partner Is Main Contractual Partner (Not Overwritable)
3 Partner Is Any Partner in Contract (Overwritable)
4 Partner from Contract Proposed Only (Overwritable)
5 Partner from Basic Data
VALUEDATEDEDUCT Derivation of Value Date for One-Time Postings RERAOPVALUEDATEDEDUCT CHAR 1 0
NULL No Default
1 Value Date Is Today's Date
2 Value Date Is Beginning of Month
3 Value Date Is Beginning of Next Month
4 Value Date Is End of Month
5 Value Date Is Posting Date
PERCENTAMT Share of the Full Document Amount in the Line Item RERAOPPERCENTAMT DEC 8 5
HASTAXFROMBASE Line Item Receives Tax Type and Group from Basic Data RERAOPHASTAXFROMBASE CHAR 1 0
X Yes
NULL No
TAXTYPEOPT Default Tax Type (Opting Company Code) RERAOPTAXTYPEOPT TIVRATAXTYPE CHAR 4 0
TAXGROUPOPT Default Tax Group (Opting Company Code) RERAOPTAXGROUPOPT TIVRATAXGROUP CHAR 20 0
TAXTYPENOOPT Default Tax Type (Non-Opting Company Code) RERAOPTAXTYPENOOPT TIVRATAXTYPE CHAR 4 0
TAXGROUPNOOPT Default Tax Group (Non-Opting Company Code) RERAOPTAXGROUPNOOPT TIVRATAXGROUP CHAR 20 0
PYMTMETH Payment Method DZLSCH T042Z CHAR 1 0
PAYMENTBLOCK Payment Block Key DZLSPR T008 CHAR 1 0
PAYMENTTRMS Terms of Payment Key DZTERM CHAR 4 0
DUNN_AREA Dunning Area MABER T047M CHAR 2 0
DUNN_KEY Dunning key MSCHL T040 CHAR 1 0
DUNN_BLOCK Dunning block MANSP T040S CHAR 1 0
HOUSEBKID Short Key for a House Bank HBKID T012 CHAR 5 0
BANKACCTID House Bank Account ID RERAOPHOUSEBANKACCTID T012K CHAR 5 0
HASDIST Is the Line Item a Distribution Item? RERAOPHASDIST CHAR 1 0
X Yes
NULL No
DISTRULEEXT External Distribution Formula RECDDISTRULEEXT TIVCDDISTEXT CHAR 4 0
DISTRULEINT Internal Distribution Formula RECDDISTRULEINT TIVCDDISTINT NUMC 4 0
DISTRULEPARA1 Untypified Parameter for a Distribution Formula RECDDISTRULEPARA CHAR 70 0
DISTRULEPARA2 Untypified Parameter for a Distribution Formula RECDDISTRULEPARA CHAR 70 0
FSVARIANTIT Field Status Variant for Line Item Data for One-Time Posting RERAOPFSVARIANTIT TIVRAOPFSIT CHAR 4 0

TIVRAOPACTI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TIVRAOPACTI BANKACCTID TIVRAOPACTI BANKACCTID T012K House Bank Accounts HKTID
TIVRAOPACTI BANKACCTID TIVRAOPACTI MANDT T012K House Bank Accounts MANDT
TIVRAOPACTI BANKACCTID * T012K House Bank Accounts BUKRS
TIVRAOPACTI BANKACCTID TIVRAOPACTI HOUSEBKID T012K House Bank Accounts HBKID
TIVRAOPACTI BANK_CTRY TIVRAOPACTI BANK_CTRY T005 Countries LAND1
TIVRAOPACTI BANK_CTRY TIVRAOPACTI MANDT T005 Countries MANDT
TIVRAOPACTI COUNTRY TIVRAOPACTI MANDT T005 Countries MANDT
TIVRAOPACTI COUNTRY TIVRAOPACTI COUNTRY T005 Countries LAND1
TIVRAOPACTI DISTRULEEXT TIVRAOPACTI MANDT TIVCDDISTEXT External Distribution Formula MANDT
TIVRAOPACTI DISTRULEEXT TIVRAOPACTI DISTRULEEXT TIVCDDISTEXT External Distribution Formula DISTRULEEXT
TIVRAOPACTI DISTRULEINT TIVRAOPACTI DISTRULEINT TIVCDDISTINT Internal Distribution Formula DISTRULEINT
TIVRAOPACTI DUNN_AREA TIVRAOPACTI DUNN_AREA T047M Dunning areas MABER
TIVRAOPACTI DUNN_AREA TIVRAOPACTI MANDT T047M Dunning areas MANDT
TIVRAOPACTI DUNN_AREA * T047M Dunning areas BUKRS
TIVRAOPACTI DUNN_BLOCK TIVRAOPACTI MANDT T040S Blocking reasons for dunning notices MANDT
TIVRAOPACTI DUNN_BLOCK TIVRAOPACTI DUNN_BLOCK T040S Blocking reasons for dunning notices MANSP
TIVRAOPACTI DUNN_KEY TIVRAOPACTI MANDT T040 Dunning keys MANDT
TIVRAOPACTI DUNN_KEY TIVRAOPACTI DUNN_KEY T040 Dunning keys MSCHL
TIVRAOPACTI FLOWTYPE TIVRAOPACTI MANDT TIVCDFLOWTYPE Flow Type MANDT
TIVRAOPACTI FLOWTYPE TIVRAOPACTI FLOWTYPE TIVCDFLOWTYPE Flow Type FLOWTYPE
TIVRAOPACTI FSVARIANTIT TIVRAOPACTI MANDT TIVRAOPFSIT Field Status for Line Item Data MANDT
TIVRAOPACTI FSVARIANTIT TIVRAOPACTI FSVARIANTIT TIVRAOPFSIT Field Status for Line Item Data FSVARIANTIT
TIVRAOPACTI GLACCSYMB TIVRAOPACTI MANDT TIVRAACCSYMB Accnt symbol MANDT
TIVRAOPACTI GLACCSYMB TIVRAOPACTI GLACCSYMB TIVRAACCSYMB Accnt symbol GLACCSYMB
TIVRAOPACTI HEADERNO TIVRAOPACTI MANDT TIVRAOPACTH Settings for Document Header MANDT
TIVRAOPACTI HEADERNO TIVRAOPACTI OPACT TIVRAOPACTH Settings for Document Header OPACT
TIVRAOPACTI HEADERNO TIVRAOPACTI HEADERNO TIVRAOPACTH Settings for Document Header HEADERNO
TIVRAOPACTI HOUSEBKID TIVRAOPACTI MANDT T012 House Banks MANDT
TIVRAOPACTI HOUSEBKID * T012 House Banks BUKRS
TIVRAOPACTI HOUSEBKID TIVRAOPACTI HOUSEBKID T012 House Banks HBKID
TIVRAOPACTI OPACT TIVRAOPACTI MANDT TIVRAOPACT Settings for Posting Activity MANDT
TIVRAOPACTI OPACT TIVRAOPACTI OPACT TIVRAOPACT Settings for Posting Activity OPACT
TIVRAOPACTI PAYMENTBLOCK TIVRAOPACTI MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
TIVRAOPACTI PAYMENTBLOCK TIVRAOPACTI PAYMENTBLOCK T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
TIVRAOPACTI PYMTMETH TIVRAOPACTI MANDT T042Z Payment Methods for Automatic Payment MANDT
TIVRAOPACTI PYMTMETH * T042Z Payment Methods for Automatic Payment LAND1
TIVRAOPACTI PYMTMETH TIVRAOPACTI PYMTMETH T042Z Payment Methods for Automatic Payment ZLSCH
TIVRAOPACTI SCKEY TIVRAOPACTI MANDT TIVSCSCKEY Service Charge Keys MANDT
TIVRAOPACTI SCKEY TIVRAOPACTI SCKEY TIVSCSCKEY Service Charge Keys SNKSL
TIVRAOPACTI SHSTRATSCKEY TIVRAOPACTI MANDT TIVCASHSTRATSYS Search Strategy - System-Defined MANDT
TIVRAOPACTI SHSTRATSCKEY 'SCSCKEY' TIVCASHSTRATSYS Search Strategy - System-Defined SHFLDNAME
TIVRAOPACTI SHSTRATSCKEY TIVRAOPACTI SHSTRATSCKEY TIVCASHSTRATSYS Search Strategy - System-Defined SHSTRAT
TIVRAOPACTI TAXGROUPNOOPT TIVRAOPACTI MANDT TIVRATAXGROUP Tax Group MANDT
TIVRAOPACTI TAXGROUPNOOPT TIVRAOPACTI TAXGROUPNOOPT TIVRATAXGROUP Tax Group TAXGROUP
TIVRAOPACTI TAXGROUPOPT TIVRAOPACTI MANDT TIVRATAXGROUP Tax Group MANDT
TIVRAOPACTI TAXGROUPOPT TIVRAOPACTI TAXGROUPOPT TIVRATAXGROUP Tax Group TAXGROUP
TIVRAOPACTI TAXTYPENOOPT TIVRAOPACTI MANDT TIVRATAXTYPE Tax Types MANDT
TIVRAOPACTI TAXTYPENOOPT * TIVRATAXTYPE Tax Types COUNTRY
TIVRAOPACTI TAXTYPENOOPT TIVRAOPACTI TAXTYPENOOPT TIVRATAXTYPE Tax Types TAXTYPE
TIVRAOPACTI TAXTYPEOPT TIVRAOPACTI TAXTYPEOPT TIVRATAXTYPE Tax Types TAXTYPE
TIVRAOPACTI TAXTYPEOPT TIVRAOPACTI MANDT TIVRATAXTYPE Tax Types MANDT
TIVRAOPACTI TAXTYPEOPT * TIVRATAXTYPE Tax Types COUNTRY